Home› General support

Upgrade error 1.2.9 to 1.3.1

Megan Member
in General support
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

Comments

  • sbillard Member
    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.
  • Megan Member
    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?
  • sbillard Member
    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.
  • Megan Member
    I'm sorry, so would the missing drop permission be the problem then? You said it needed table rename permissions ... ??
  • sbillard Member
    So, what did Setup tell you?
  • Megan Member
    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.
  • Megan Member
    And that did it! Thanks for your help.
  • gracestanat Member
    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!
  • sbillard Member
    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.
  • gracestanat Member
    okay, thanks! if i discover anything interesting, i'll report back.
  • acrylian Administrator, Developer
    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.
  • gracestanat Member
    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
Sign In or Register to comment.