Geeklog Forums

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.

Thanks for the heads-up. "Deprecated" shouldn't be a problem, but it seems that syntax was removed in MySQL 5.5. So we need to address that.

I've filed a bug report: http://project.geeklog.net/tracking/view.php?id=1410

bye, Dirk