WordPress.org

Support

Support » Plugins and Hacks » WP Photo Album Plus » [Resolved] [Plugin: WPPA ] "Could not insert photo. query=INSERT INTO `wp_wppa_photos"

[Resolved] [Plugin: WPPA ] "Could not insert photo. query=INSERT INTO `wp_wppa_photos"

  • I get the following error whenever I try to upload a photo to an album or import one from the depot:

    Could not insert photo. query=INSERT INTO wp_wppa_photos (id, album, ext, name, p_order, description, mean_rating, linkurl, linktitle) VALUES (‘0’, ‘6’, ‘png’, ‘phototitle.png’, ‘0’, ”, ”, ”, ”)

Viewing 15 replies - 1 through 15 (of 20 total)
  • Plugin Author Jacob N. Breetvelt

    @opajaap

    Is this a new installation?
    Is this a multisite installation?
    Please check Table IX item 5 (allow debugging), go to the import page, add &debug to the address line and press enter. You may get a better errormessage.

    Also, try Table VIII item 3: re-initialize.

    It is not a new installation nor is it a multisite installation.

    I’m a bit new to this. what does this mean:


    Please check Table IX item 5 (allow debugging), go to the import page, add &debug to the address line and press enter. You may get a better errormessage.

    Also, try Table VIII item 3: re-initialize.

    Where are these Tables you speak of?

    Plugin Author Jacob N. Breetvelt

    @opajaap

    In the left sidebar of the admin screen you will find the Photo Albums menu. Select the Settings tab.
    You can open the tables by clicking the Show button.
    Each setting has help under the ? at the right hand side.

    I followed the steps you outlined above and added the &debug to the address line of the import page and I still get the following:

    Could not insert photo. query=INSERT INTO wp_wppa_photos (id, album, ext, name, p_order, description, mean_rating, linkurl, linktitle) VALUES (‘0’, ‘6’, ‘jpg’, ‘photo.jpg’, ‘0’, ”, ”, ”, ”)

    Plugin Author Jacob N. Breetvelt

    @opajaap

    Did you do the re-init (Table VIII item 3) ?
    You could create albums though?

    Yes I did the the re-init – Table VIII item 3

    And I was able to create an album before and after i did this but I am still unable to import any photos:

    Same error:
    Could not insert photo. query=INSERT INTO wp_wppa_photos (id, album, ext, name, p_order, description, mean_rating, linkurl, linktitle) VALUES (‘0′, ’20’, ‘png’, ‘Delgado.png’, ‘0’, ”, ”, ”, ”)

    Plugin Author Jacob N. Breetvelt

    @opajaap

    Please email me (opajaap at opajaap.nl) temporary login name and password to an administrator account.

    Hello Opajapp,

    Before doing that I decided to see if there was a problem with the photo album itself. It appears that there is and I sent you a .zip of the album a couple of days ago. Did you not receive it? If you did have you had a chance to look at it?

    Plugin Author Jacob N. Breetvelt

    @opajaap

    I tested it and had no problems. Only a warning that there were one or more too smal (smaller than the thumbnail, and because we do not stretch photos…) but no errors like you have.
    See the result: Here

    Please tell me that you inspected it, i will then delete your albums from my site.

    Did you upgrade to the latest rev?

    Hello again, thank you for doing this. Yes, I just updated to the latest rev this morning.

    Also I have inspected the album, you may delete it now.

    But before deleting it were you able to add photos to it?

    If so, then I guess something particular to the way it’s set up on our site is the problem. Check your email, I’ve just sent you two site log ins to see what the problem is.

    Plugin Author Jacob N. Breetvelt

    @opajaap

    I have the same problem now after importing your photos.
    The offending photo is: (see 9223372036854775807.pmf)

    name=Ozzie Guillén
    desc=Ozzie Guillén – Chicago White Sox Manager
    pord=4
    albm=Chicago Fire
    lnku=

    it has 9223372036854775807 as an id. That seems to be the max value.

    The id is the key of the table and is auto increment.

    I do not know where this value came from, but the problem now is that there is no possibility to create new keys.

    The only solution now is:
    1. export everything
    2. drop table wp_wppa_photos
    3. run re-initialize (Photo albums -> Settings page Table VIII item 3)
    4. DELETE 9223372036854775807.pmf and 9223372036854775807.png
    5. import everything.

    Do you remember anything special around the upload or import of the offending photo?

    Plugin Author Jacob N. Breetvelt

    @opajaap

    I forgot a step: Before importing, delete all photos and thumbnails in wp-content/uploads/wppa (photos) and wp-content/uploads/wppa/thumbs
    The old numbers will be recovered when available. If you do not delete them, you will have all photos twice. The albums is no problem, he will say: album already existed. that is not an error

    How do I drop table wp_wppa_photos?

    Ok. I figured it out and that did the trick. Can you tell me how I can reproduce the very cool looking album you made when you imported my album on your demo site?

    Plugin Author Jacob N. Breetvelt

    @opajaap

    Table VIII item 4, make a backup of your settings.
    Table VIII item 5, load OpaJaap-green.skin, then you have my settings. that should approximate wat you saw on my site.

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘[Resolved] [Plugin: WPPA ] "Could not insert photo. query=INSERT INTO `wp_wppa_photos"’ is closed to new replies.
Skip to toolbar