Posted on: 09/05/13 11:05am
By: mmeovz
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?
Re: Error Message when trying to backup the databse form Geeklog
Posted on: 09/07/13 04:19pm
By: mmeovz
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
Re: Error Message when trying to backup the databse form Geeklog
Posted on: 09/10/13 07:11am
By: Dirk
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