WordPress.org

Support

Support » Plugins and Hacks » [Plugin: NextGEN Gallery] Can’t automatically update gallery database for the new version

[Plugin: NextGEN Gallery] Can’t automatically update gallery database for the new version

  • 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

Viewing 15 replies - 1 through 15 (of 39 total)
  • Doesn’t sound good, do you get any error message ?

    Got the same problem, no errors, nothing in the logs, just nothing 😛 the only thing it says is “Upgrade NextGEN Gallery”.

    [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

    I just upgraded nicely

    @cobra

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

    Yes I am, tell me what to do 🙂

    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?

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

    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…

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

    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.

    Where I can check memory limit? Is hosted site…

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

    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?

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

Viewing 15 replies - 1 through 15 (of 39 total)
  • The topic ‘[Plugin: NextGEN Gallery] Can’t automatically update gallery database for the new version’ is closed to new replies.