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

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: https://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: https://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: https://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: https://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: https://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: https://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:

https://www.kaper.sk/up/1.jpg
https://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