Database backup fails

[frankludriks]

Attempting to backup database through Shop -> Tools -> Database Backup (admin/backup.php?action=backup) results in a 500 error.

From log file:

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tonerpak_2point4.osc_osc_action_recorder' doesn't exist' in /home/somewebsite/public_html/2point4/includes/OSC/OM/Db.php:94
Stack trace:
#0 /home/somewebsite/public_html/2point4/includes/OSC/OM/Db.php(94): PDO->query('select id, modu...')
#1 /home/somewebsite/public_html/2point4/includes/OSC/OM/Db.php(142): OSC\OM\Db->query('select id, modu...')
#2 /home/somewebsite/public_html/2point4/admin/backup.php(124): OSC\OM\Db->get('osc_action_reco...', Array)
#3 {main}
thrown in /home/somewebsite/public_html/2point4/includes/OSC/OM/Db.php on line 94

[scottcwilson]

Replicated. Looks like prefix is being added twice.

[Gergely]

I have different problem with schema

[17-Nov-2016 15:03:52 Europe/Budapest] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oscom24.osc_counter' doesn't exist in C:\wamp\www\projects\oscom24_g\catalog\includes\OSC\OM\Db.php:94
Stack trace:
#0 C:\wamp\www\projects\oscom24_g\catalog\includes\OSC\OM\Db.php(94): PDO->query('select startdat...')
#1 C:\wamp\www\projects\oscom24_g\catalog\includes\OSC\OM\Db.php(142): OSC\OM\Db->query('select startdat...')
#2 C:\wamp\www\projects\oscom24_g\catalog\admin\backup.php(124): OSC\OM\Db->get(Array, Array)
#3 {main}
thrown in C:\wamp\www\projects\oscom24_g\catalog\includes\OSC\OM\Db.php on line 94

[Gergely]

but the reason the same. You can get an error if new osc schema tables installed with previous version.

[Gergely]

Backup mechanism scans non-prefix tables but try to save prefixed table values

[Gergely]

@haraldpdl

Is it possible like filter in where clause in Db->Get ? Maybe its would be better prepare and run query directly with prefix. Is there any reason to use Get function here?

't.TABLE_NAME like \'' . OSCOM::getConfig('db_table_prefix') . '%\'',

[Gergely]

Could you test it?

master...Gergely:issue_503

[frankludriks]

Backup worked with that change Gergely.

[haraldpdl]

Fixed in #540 🍻