Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 07:34 am EDT

Geeklog Forums

Error Message when trying to backup the databse form Geeklog


Status: offline

mmeovz

Forum User
Newbie
Registered: 04/10/12
Posts: 4

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'Wink

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?
 Quote

Status: offline

mmeovz

Forum User
Newbie
Registered: 04/10/12
Posts: 4

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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

All times are EDT. The time is now 07:34 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content