WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: NextGEN Gallery] Can't automatically update gallery database for the new version (40 posts)

  1. dee-m-cee
    Member
    Posted 5 years ago #

    Hi,

    I just updated my wordpress to version 2.7 and updated my NextGen Gallery to version 1.0.0.
    For adding a new gallery oder pictures I am asked to automatically update the database in order to use it with the new version. After I pressed the Update-Button nothing happened and the next time I'm asked again.

    Help me! Where's the problem with it?

    Thank you!
    markus

  2. Alex Rabe
    Member
    Posted 5 years ago #

    Doesn't sound good, do you get any error message ?

  3. The_cobra666
    Member
    Posted 5 years ago #

    Got the same problem, no errors, nothing in the logs, just nothing :P the only thing it says is "Upgrade NextGEN Gallery".

  4. The_cobra666
    Member
    Posted 5 years ago #

    [Thu Dec 11 13:31:19 2008] [error] [client XXXXXX] WordPress database error Table 'WorD.wp_ngg_pic2tags' doesn't exist for query SELECT t.*, tt.* FROM wp_ngg_pic2tags AS t INNER JOIN wp_ngg_tags AS tt ON t.tagid = tt.id WHERE t.picid = '25958' ORDER BY tt.slug ASC made by do_action, call_user_func_array, nggAdminPanel->show_menu, nggallery_upgrade_page, nggallery_start_upgrade, ngg_upgrade, ngg_convert_tags, referer: http://www.cobrapit.be/wp-admin/admin.php?page=nggallery-manage-gallery
    [Thu Dec 11 13:31:19 2008] [error] [client XXXXXX] WordPress database error Unknown table 'wp_ngg_tags' for query DROP TABLE wp_ngg_tags made by do_action, call_user_func_array, nggAdminPanel->show_menu, nggallery_upgrade_page, nggallery_start_upgrade, ngg_upgrade, referer: http://www.cobrapit.be/wp-admin/admin.php?page=nggallery-manage-gallery
    [Thu Dec 11 13:31:19 2008] [error] [client XXXXXX] WordPress database error Unknown table 'wp_ngg_pic2tags' for query DROP TABLE wp_ngg_pic2tags made by do_action, call_user_func_array, nggAdminPanel->show_menu, nggallery_upgrade_page, nggallery_start_upgrade, ngg_upgrade, referer: http://www.cobrapit.be/wp-admin/admin.php?page=nggallery-manage-gallery
    [Thu Dec 11 13:31:19 2008] [error] [client XXXXXX] WordPress database error Duplicate column name 'imagedate' for query ALTER TABLE wp_ngg_pictures ADD imagedate DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER alttext made by do_action, call_user_func_array, nggAdminPanel->show_menu, nggallery_upgrade_page, nggallery_start_upgrade, ngg_upgrade, referer: http://www.cobrapit.be/wp-admin/admin.php?page=nggallery-manage-gallery
    [Thu Dec 11 13:31:20 2008] [error] [client XXXXXX] PHP Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 35 bytes) in /var/www/vhosts/cobrapit.be/httpdocs/wp-includes/wp-db.php on line 636, referer: http://www.cobrapit.be/wp-admin/admin.php?page=nggallery-manage-gallery

    there is more... but it's all the same. The one below is repeating it self again and again in the logs, untill the messages from above.

    [Thu Dec 11 13:29:11 2008] [error] [client XXXXXXX] WordPress database error Table 'WorD.wp_ngg_pic2tags' doesn't exist for query SELECT t.*, tt.* FROM wp_ngg_pic2tags AS t INNER JOIN wp_ngg_tags AS tt ON t.tagid = tt.id WHERE t.picid = '20489' ORDER BY tt.slug ASC made by do_action, call_user_func_array, nggAdminPanel->show_menu, nggallery_upgrade_page, nggallery_start_upgrade, ngg_upgrade, ngg_convert_tags, referer: http://www.cobrapit.be/wp-admin/admin.php?page=nextgen-gallery

  5. engelsol
    Member
    Posted 5 years ago #

    I just upgraded nicely

  6. Alex Rabe
    Member
    Posted 5 years ago #

    @Cobra

    That means your script didn't detect the tables.
    Are you able to look into your table structure (PHPMyAdmin)?

  7. The_cobra666
    Member
    Posted 5 years ago #

    Yes I am, tell me what to do :)

  8. The_cobra666
    Member
    Posted 5 years ago #

    The only tables I've got from nextgen gallery are:

    wp_ngg_album
    wp_ngg_gallery
    wp_ngg_pictures

    I sence that one is missing? wp_ngg_pic2tags?

  9. andrejqo
    Member
    Posted 5 years ago #

    Some problem, ony text Upgrade NextGEN Gallery. No action...

  10. andrejqo
    Member
    Posted 5 years ago #

    Screenshots from my upgade steps:

    http://www.kaper.sk/up/1.jpg
    http://www.kaper.sk/up/2.jpg

    How log may durate solve this problem? If i must downgrade to WP265, couse i cant work...

  11. Alex Rabe
    Member
    Posted 5 years ago #

    a) Please check your memeory limit (Should be more than 32 MB),
    b) Please disable all other plugins during upgrade

  12. dee-m-cee
    Member
    Posted 5 years ago #

    Thank you for you support. I'll try these steps later and report about the results.

    As far as I am now I don't get any error message. My screen looks exactly like andrejqo's.

  13. andrejqo
    Member
    Posted 5 years ago #

    Where I can check memory limit? Is hosted site...

  14. The_cobra666
    Member
    Posted 5 years ago #

    I have disabled all the plugins but nextgen gallery, the memory limit is 40 MB. Same problem like andrejqo.

  15. Laws
    Member
    Posted 5 years ago #

    I had the same problem.
    I uninstalled the plugin completely and reinstalled it. Sadly that changed something in the database and my galleries were gone.
    So I used PHPMyAdmin and a backup of the old db to restore the wp_ngg_* tables from the older plugin. That worked surprisingly well.
    But i guess it is a bad idea to use the old dbstructure with new plugin, right? So what do I do about it?

  16. Alex Rabe
    Member
    Posted 5 years ago #

    Ok, seems to be a memory issue. I need to look why the upgrade routine requires so much memory

  17. agausemel
    Member
    Posted 5 years ago #

    Here is what I see when trying to upgrade:
    click here

    Otherwise It's the same as cobra & andrejqo with the never ending request to update the DB with no joy.

    bummer...

  18. andrejqo
    Member
    Posted 5 years ago #

    I think that problem is with quantity of galeries. I have up to 500

  19. andrejqo
    Member
    Posted 5 years ago #

    I think, that can be a quantity of galeries... I have up to 500

  20. boardopboy
    Member
    Posted 5 years ago #

    Gimme an oar andrejqo, as you and I are in the same boat.

    I turned off all but the NextGen Gallery plugins, memeory limit at 128 and 70 galleries.

    My results are the same as andrejqo's so I won't bother posting screenies.

    Where to now?

  21. Alex Rabe
    Member
    Posted 5 years ago #

    I tested under PHP 5 300-500 Images to upgrade, I never tested 500 galleries with 10000 images. I need to debug it on such a enviroment, If someone is willing to help I need please contact me by mail, I need access to a system with such problems.

    thanks

  22. The_cobra666
    Member
    Posted 5 years ago #

    andrejqo, not me :) Got maybe 30 or 50 gallery's. Not that much :) Doest'n work.

  23. boardopboy
    Member
    Posted 5 years ago #

    I'd love to help, but I only have about 1200 photos in my 70 galleries...

    That, and i downgraded to .99 just to get things back up and running.

  24. sruglass
    Member
    Posted 5 years ago #

    Alex I found out what the problem is, it is actually the number of galleries one has on his/her website.

    What I did to make the upgrade work was to rename the gallery folder in wp-content and create a blank gallery folder. That solved the problem. After the upgrade I simply delete the empty gallery folder and rename the original back to gallery.

  25. sruglass
    Member
    Posted 5 years ago #

    One problem though and I think this is major in my opinion. Galleries must have a name in order to view or edit pictures in a gallery. Older galleries that were uploaded via the zip file tool won't have a name therefore they can not be edited.

    Alex, can you edit the code so we can click on the gallery ID, instead of the gallery name, to edit the galleries or click on both.

    You also need to put back the [click to view original size] in the thickbox effect.

    Thanks in advance...

  26. boardopboy
    Member
    Posted 5 years ago #

    Hey THANKS sruglass!

    Your method worked wonderfully!

  27. sruglass
    Member
    Posted 5 years ago #

    No prob bro

  28. andrejqo
    Member
    Posted 5 years ago #

    Geat man! Thank you a lot !!! :-)))) I am saved !!! :D :D :D

    THIS IS SOLUTION:

    rename the gallery folder in wp-content and create a blank gallery folder. That solved the problem. After the upgrade I simply delete the empty gallery folder and rename the original back to gallery.

  29. Alex Rabe
    Member
    Posted 5 years ago #

    I have an idea what could be the problem, here are two solutions :

    a) Look into admin/upgrade.php and search for ngg_import_date_time();
    Comment it out by using //ngg_import_date_time();

    b) I've added some more debug information which may help, please downlaod this new admin/upgrade.php file and test it again... please post screenshots

  30. jag959
    Member
    Posted 5 years ago #

    @alexrabe

    Commenting-out that line worked.

    Thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic