Status: offline
jrivett
Forum User
Newbie
Registered: 12/17/11
Posts: 10
Running Geeklog 1.8.1 on WAMP with Apache 2.2.17, MySQL 5.5.16, and PHP 5.3.8.
When I try to go to the DB Backups feature in the Admin panel, I get this error (I have debugging turned on):
256 - An SQL error has occurred. Please see error.log for details. @ C:\wamp\apps\geeklog-private\system\databases\mysql.class.php line 260
array
'sql' => string 'SHOW TABLE TYPES' (length=16)
'ignore_errors' => int 0
'result' => boolean false
The error.log file shows this:
12/17/11 17:41:42 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPES' at line 1. SQL in question: SHOW TABLE TYPES
(a few minutes later...)
I figured it out. SHOW TABLE TYPES has been deprecated. Instead, SHOW STORAGE ENGINES should be used. I found one instance of this, on line 414 of admin\database.php. Changed it and now DB Backups works.
When I try to go to the DB Backups feature in the Admin panel, I get this error (I have debugging turned on):
256 - An SQL error has occurred. Please see error.log for details. @ C:\wamp\apps\geeklog-private\system\databases\mysql.class.php line 260
array
'sql' => string 'SHOW TABLE TYPES' (length=16)
'ignore_errors' => int 0
'result' => boolean false
The error.log file shows this:
12/17/11 17:41:42 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPES' at line 1. SQL in question: SHOW TABLE TYPES
(a few minutes later...)
I figured it out. SHOW TABLE TYPES has been deprecated. Instead, SHOW STORAGE ENGINES should be used. I found one instance of this, on line 414 of admin\database.php. Changed it and now DB Backups works.
