+- 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 error when upgrading (/thread-7666.html)
MYSQL error when upgrading - iris - 2010-09-27
Hello,
I'm upgrading from 1.2.6, and encountered this error:
Quote:About to update tables...
Migrating lib-auth data version 1 => version 2
Zenphoto encountered an error
MySQL Query ( SELECT pages.title,pages.titlelink FROM pages, admin_to_object WHERE admin_to_object.adminid=2 AND pages.id=admin_to_object.objectid AND admin_to_object.type='pages' ) failed. MySQL returned the error Table 'zen.pages' doesn't exist
Backtrace:
-> query (functions-db-MySQL.php [101])
-> query_full_array (admin-functions.php [2855])
-> populateManagedObjectsList (lib-auth.php [529])
-> Zenphoto_Administrator->getObjects (lib-auth.php [581])
-> Zenphoto_Administrator->save (setup-option-defaults.php [270])
-> require (setup.php [2224])
I've never had a 'pages' table in my database, and even tried to install the latest version (1.3.1.2) from scratch, and that installation didn't have a 'paged' table either, so I don't know why the setup script is looking for one.
Any help would be appreciated!
MYSQL error when upgrading - acrylian - 2010-09-27
If you upgrade from such an old version you have to upgrade bascially step by step. If you upgrade to the official 1.3.1.2 the pages table should acually be named "zenpage_pages" as it belongs to the optional CMS plugin Zenpage and is setup on installation preliminary.
If it really is named just "pages" you probably tried the nightly build.
Please try a forum search. There was a lengthly thread about this recently.
MYSQL error when upgrading - iris - 2010-09-27
Ah, I see... I like to use svn whenever possible (so much quicker than downloading, uploading, unpacking), but I think yours doesn't have the latest stable version?
Anyway, downloaded, uploaded and unpacked the zip, and all is working lovely. Thanks for you help!
MYSQL error when upgrading - kagutsuchi - 2010-09-27
The stable versions are also version controlled; check the tags directory.
MYSQL error when upgrading - sbillard - 2010-09-27
If you are really updating from the SVN, be sure that you run Setup each time. The tests for automatically running is are valid only for builds such as the nightly build. Also note that you may "grab" a change in progress if you are using the SVN. Really a much better idea to use nightly builds unless you are actually developing code for Zenphoto.