Welcome to Geeklog, Anonymous Saturday, December 03 2022 @ 02:36 pm EST

Geeklog Forums

DB Backups throws an error


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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: jrivett

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 admindatabase.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
 Quote

All times are EST. The time is now 02:36 pm.

  • 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