Zen Cart Logo
Forums / Upgrading to 1.5.x / WARNING: An Error occurred, please refresh the page and try again - DB Backup MySQL

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

Views: 1,829

Results 1 to 4 of 4
8 Jun 2015, 3:25 PM
#1
ideasgirl avatar

ideasgirl

Totally Zenned

Join Date:
Aug 2005
Location:
Trujillo Alto, Puerto Rico
Posts:
1,438
Plugin Contributions:
3

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

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:...

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

8 Jun 2015, 3:41 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

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())");
8 Jun 2015, 4:12 PM
#3
ideasgirl avatar

ideasgirl

Totally Zenned

Join Date:
Aug 2005
Location:
Trujillo Alto, Puerto Rico
Posts:
1,438
Plugin Contributions:
3

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

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.

8 Jun 2015, 4:24 PM
#4
ideasgirl avatar

ideasgirl

Totally Zenned

Join Date:
Aug 2005
Location:
Trujillo Alto, Puerto Rico
Posts:
1,438
Plugin Contributions:
3

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

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

THANKS! :smartalec: