Home› General support

unknown column parentid error on upgrade

bitbybit Member
in General support
I just ran into the following error when trying to use the admin gui after upgrading an existing zenphoto install (1.2.0b3 -> 1.6):

`MySQL Query ( SELECT * FROM albums WHERE 'parentid' IS NULL ) Failed. Error: Unknown column 'parentid' in 'where clause'`

I had to manually go in and drop the zenphoto database (probably could've just added in the parentid column), and re-run the setup.php script to get it to populate properly. In any case, it doesn't appear that the column was automagically added when I ran the setup script initially (tried twice).

As I said, just a heads up in case anyone else runs into that error :)

Comments

  • mavathavieu Member
    Hi, I have a similar problem but I don't understand your solution : how do you "drop" the zenphoto database ?
  • mavathavieu Member
    Sorry I found out alone a solution, I guess the same as you did : I went to configure the mysql database from my host and deleted everything from zenphoto (drop tables) and then started the setup.php again.

    Thx for the help
  • trisweb Administrator
    There's also an 'upgrade.php' that you should run after any upgrade... just FYI in case you missed the instructions on the front page of zenphoto.org ;-)

    I just checked and the field 'parentid' is added in the upgrade.php and the setup.php, everything should work correctly if you just upgrade.
Sign In or Register to comment.