Geeklog Forums

Hi Guys, Good Morning!

When i try to make a safety backup form the Admin pannel, I get the following error message:
An error has occurred:

(This text is only displayed to users in the group 'Root'

256 - An SQL error has occurred. Please see error.log for details. @ /home4/glicerof/etc/gl_contrast/system/databases/mysql.class.php line 260

array(3) {
["sql"]=>
string(16) "SHOW TABLE TYPES"
["ignore_errors"]=>
int(0)
["result"]=>
bool(false)
}

and the error.log file is the following:

jue 05 sep 2013 07:45:34 CDT - 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

Any suggestions?

Could you be so kind in giving a hint on how to resolve this? Unfortunately i do not have the knowledge as you have.

Thanks and Regards

Which Geeklog version is that?

It seems you're using a rather new version of MySQL with an older version of Geeklog. The SQL statement in MySQL changed (in 5.5, I think) and should now read "SHOW STORAGE ENGINES".

You can fix that yourself in public_html/admin/database.php by searching for "SHOW TABLE TYPES" and replace it with "SHOW STORAGE ENGINES".

Alternatively, upgrade to a newer version of Geeklog (1.8.2 or later).

bye, Dirk