[geeklog-cvs] geeklog: Fix database backup with MySQL 5.5 or later (SHOW TABLE...

[geeklog-cvs at lists.geeklog.net]

changeset 8521:a7e99d1b00a1
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/a7e99d1b00a1
user: Dirk Haun <dirk at haun-online.de>
date: Sun Mar 11 13:44:34 2012 +0100
description:
Fix database backup with MySQL 5.5 or later (SHOW TABLE TYPES no longer working, bug #0001410).
Note that this requires MySQL 4.1.2 or later, but our minimum required version is 4.1.3 now anyway.

diffstat:

 public_html/admin/database.php |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 55020eb3f309 -r a7e99d1b00a1 public_html/admin/database.php
--- a/public_html/admin/database.php	Sat Mar 10 23:48:05 2012 +0000
+++ b/public_html/admin/database.php	Sun Mar 11 13:44:34 2012 +0100
@@ -411,7 +411,7 @@
     $retval = false;
 
     if ($_DB_dbms == 'mysql') {
-        $result = DB_query("SHOW TABLE TYPES");
+        $result = DB_query("SHOW STORAGE ENGINES");
         $numEngines = DB_numRows($result);
         for ($i = 0; $i < $numEngines; $i++) {
             $A = DB_fetchArray($result);