Home› General support

Errors after 1.2.7 upgrade

mangg Member
in General support
I recently upgraded from 1.2.6. to 1.2.7 per the upgrade instructions here: http://www.zenphoto.org/2008/08/installation-and-upgrading/ Generally I am working but have a few MSQL/Zenphoto errors that happen when I open a gallery or certain pictures. Please note all the pictures have XMP in them and it seems related to the error. The error when opening the gallery or some images is:

Zenphoto Error
MySQL Query ( INSERT INTO `zp_tags` (name) VALUES ('text of XMP entires') ) failed. Error: Duplicate entry 'text of XMP entires' for key 2

Any ideas?

Thanks in advance! =)

Comments

  • sbillard Member
    What do you man by "have XMP in them"? Are you using the XMP Metadata plugin?
  • mangg Member
    Hello,

    Yes, I have the XMP plugin on and the error seems to be indicating that it might relate to that. Or am I off here?? Any other ideas relating to what might be causing this?

    Thanks!
  • sbillard Member
    Are you processing a lot of images at once? There is a check to see if the tag exists already in the database, but maybe there is a race condition where it could get created by another process between the time of the check and the time of the insert.

    Otherwise, does this happen with a particular image? Maybe there is something with that image which causes the problem.
  • mangg Member
    There are only 5 images in total at this point. How do I check if that tag exists in the DB? It seems to happen on 3 of 5 of the images.

    Any suggestions?

    TIA
  • sbillard Member
    You do not need to check. The error your getting is because the tag does exist in the database. Maybe the exact text of the error message would shed some clues (unless, of course, what you posted is the exact text. Then did you mean to have a tag named "Text of XMP entries")
  • mangg Member
    There are actually 8 images in the gallery and only 4 are now showing since the upgrade to 1.2.7. When I click on the Album I get the error message below. As well I get it on the forth image.

    The exact text is as follows:

    Zenphoto Error
    MySQL Query ( INSERT INTO zp_tags (name) VALUES ('Christmas Party 2008 Jim and friends having some fun at Santa's expense') ) failed. Error: Duplicate entry 'Christmas Party 2008 Jim and friends having some fun at Santa's expense' for key 2

    Any ideas? Should I check the XMP in the image files themselves?
  • sbillard Member
    What shows up in the list of tags on the admin tags tab?
  • mangg Member
    Do you mean /zenphoto/zp-core/admin-tags.php ??? These are the tags I used to describe the images. I tried deleting the tag that seems to appear twice and I get the following error:

    Zenphoto Error
    MySQL Query ( INSERT INTO `zp_obj_to_tag`(`objectid`, `tagid`, `type`) VALUES (11,,'images') ) failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''images')' at line 1
  • sbillard Member
    Does the tag exist with the name exactly as the error message? Does it exist only once?

    If you disable the XMPMetadata plugin do you still get the errors?
  • mangg Member
    There are duplicate tags in some of the images. When I disable the XMPmetadata plugin I still get the errors...
  • sbillard Member
    Please check your CGI logs to see if any errors are being reported.
Sign In or Register to comment.