ZenphotoCMS Forum
MySQL query failed during clean install - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: MySQL query failed during clean install (/thread-9838.html)



MySQL query failed during clean install - matthicksphoto - 2012-04-10

In an earlier post, I had an iframe that I never found the source of, so I decided to do a clean install. After uploading the latest version of zenphoto into my root directory, I tried to install it, but came up with the following error:

Zenphoto encountered an error
MySQL Query ( SHOW FULL COLUMNS FROM [prefix]images ) failed. MySQL returned the error Table 'matthick_zenphoto._images' doesn't exist

Of possible note is that before that there was this:
SHOW TABLES found: zenphoto_admin_to_object, zenphoto_administrators, zenphoto_albums, zenphoto_captcha, zenphoto_comments, zenphoto_images, zenphoto_menu, zenphoto_news, zenphoto_news2cat, zenphoto_news_categories, zenphoto_obj_to_tag, zenphoto_options, zenphoto_pages, zenphoto_plugin_storage, zenphoto_search_cache, zenphoto_tags




MySQL query failed during clean install - acrylian - 2012-04-10

What is the database prefix used? "matthickzenphoto." or "zenphoto_"? Sure you entered the same database credentials as on the old install (e.g. is the config file there?).




MySQL query failed during clean install - matthicksphoto - 2012-04-10

I discovered I had many, many more problems than that error. I ended up absolutely cleaning out my website and re-installing cPanel. Looks like I'm good to go from here! No idea what the problem was, though, I went about it the exact same way.