Hello,

I am upgrading from 1.2.6 to 1.3.1. I am working step-by-step through the versions in between there. At the 1.3.1 upgrade I encountered this error:

MySQL Query ( DELETE FROM ``admin_to_object WHERE adminid=3 ) failed. MySQL returned the error Table 'cpa_photos.admin_to_object' doesn't exist

My database user doesn't have drop privileges, could this be the problem? The gallery seems to work fine anyway.

Thanks for any help

More likely it is because your database user does not have table rename priviledges. Setup will attempt to review the priviledges of the database user and report any that are missing. You should check that.

Zenphoto will from time to time rename, add, or drop tables or fields of tables. If the user does not have permissions to do these things the upgrade will fail.

Hi sbillard,

I'm sorry for the delay - still having this problem. I do get an error on setup about database privileges:

Your Database user must have Alter, Create, Delete, Drop, Index, Insert, Select and Update rights.

Grants found:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER

So it's just Drop that's missing, right? Or am I blind? Is that the problem then? I just upgraded to 1.4.1 - should I go back to 1.3.1 and run that upgrade again?

It is most safe to go back to 1.3.1 and re-run setup after fixing this problem. Then upgrade to 1.4.0.1. Generally it may work to skip releases on an upgrade, but since we do not test this we do not recommend it.

I'm sorry, so would the missing drop permission be the problem then? You said it needed table rename permissions ... ??

So, what did Setup tell you?

What I posted above - it's just missing the drop permission and I was wondering if that was what was causing this problem. Yes ??? I'll have to put in a request to my server admin to get that added.

And that did it! Thanks for your help.

for the others among us that are doing the same thing, can you tell us the safe jumps to make, sbillard?

i'm currently on 1.2.7. i read the upgrading instructions on the site, but it's dated 2008 so i'm not confident that they are still accurate. is this page still the preferred method:

http://www.zenphoto.org/2008/08/installation-and-upgrading/

coming from 1.2.7, should i install 1.2.8, 1.2.9, 1.3.0, 1.3.1, then 1.4.01?

or can i just go from 1.2.7 to 1.3.1 to 1.4.01?

thanks in advance!

Unfortunately, no I cannot as there had not been any testing of these jump sequences. In therory you should be able to directly go to the 1.4.0.1 release. But in practice you may run into some bug in doing so.

If you have a good backup of your installation I would suggest trying to go directly to 1.4.0.1. If it fails you can tell us what happened and fall back to your original install and try smaller steps.

The upgrade if you are going to 1.4.0.1 can be a bit simpler. But that of course depends on what the intiial release was. We have not changed the instructions as these, while perhaps overkill, are known to work.

For instance, it is not really necessary to remove the old files. However, if you make an error in your FTP and some old files do not get overridden by their newer versions then the install will fail. Thus, best to delete them so you know that the FTP upload failed.

okay, thanks! if i discover anything interesting, i'll report back.

Quote:upgrading instructions on the site, but it's dated 2008 so i'm not confident that they are still accurate.
FYI, if we would change the date everytime the link would most likely outdate with our current Wordpress settings which would be unfortunate.

Okay, I've completed my process (mostly). I made some notes in case they might help somebody else in a similar situation:

http://www.zenphoto.org/support/topic.php?id=8718&replies=1#post-51351