MYSQL error when upgrading

iris

Hello,

I'm upgrading from 1.2.6, and encountered this error:

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!

acrylian

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.

iris

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!

kagutsuchi

The stable versions are also version controlled; check the `tags` directory.

sbillard

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.