WARNING: An Error occurred, please refresh the page and try again - DB Backup MySQL

[ideasgirl]

Upgrade from 1.3.9h to 1.5.4 with db patched.
Module: Database Backup Manager - MySQL

Everything works fine on the store, even the backup. The issue comes up when doing restores. It goes to a blank page stating:
WARNING: An Error occurred, please refresh the page and try again.

The error log is empty, but the cache errors state:

a:148:{i:0;a:2:{s:6:"cfgkey";s:23:"SHOW_PRODUCT_INFO_MODEL";s:8:"cfgvalue";s:1:"1";}i:1;a:2:{s:6:"cfgkey";s:24:"SHOW_PRODUCT_INFO_WEIGHT";s:8:"cfgvalue";s:1:"1";}i:2;a:2:...

I really don't know what's up...

[DrByte]

Those "cache errors" are not errors at all. That's the actual data in your store's cache.

Question: You said this happens only on "restore". Does the actual restore work? ie: is the data actually replaced with the backup as expected?

Try making this change to /admin/backup_mysql.php, around line 280:

            // store the last-restore-date, if successful
            $db->Execute("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'DB_LAST_RESTORE'");
            $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, date_added) values ('Last Database Restore', 'DB_LAST_RESTORE', '" . $specified_restore_file . "', 'Last database restore file', 6, now())");

[ideasgirl]

Yes, forgot to mention that. The db gets restored.

I did, no errors this time but I've been sent to admin home and I can't get now to the plugin page. I can browse the rest of the admin.

[ideasgirl]

Ok, I logoff from admin and re-login and everything is fine now.

THANKS!