Error while upgrading

Hello!

Im trying to upgrade to 1.0.8.2 but when I run the upgrade script I get this error:

MySQL Query ( DELETE FROM `albums` WHERE `id` = '47' ) Failed. Error: Cannot delete or update a parent row: a foreign key constraint fails (`zenphoto`.`images`, CONSTRAINT `images_ibfk1` FOREIGN KEY (`albumid`) REFERENCES `albums` (`id`))

Any ideas?

Comments

  • trisweb Administrator
    That's only in the garbage collection process, so it shouldn't affect anything. The tables have already been upgraded at that point.

    Looks like the 'ON DELETE CASCADE' didn't get into the images table schema somehow... it does it manually anyway, so it shouldn't be too big a problem, but to avoid that in the future I may change the order so images are deleted first. Thanks!
  • Zulan Member
    Thanks for your reply Trisweb, maybe it's not related but I cant get in to the admin pages. Whenever I try to go there I get the mentioned error message.

    Thanks again!

    -Z
Sign In or Register to comment.