more quote identeiifers fixessss
authorAlan Knowles <alan@roojs.com>
Fri, 7 Aug 2020 07:30:34 +0000 (15:30 +0800)
committerAlan Knowles <alan@roojs.com>
Fri, 7 Aug 2020 07:30:34 +0000 (15:30 +0800)
UpdateDatabase/MysqlEngineCharset.php

index f977bbe..af2f66b 100644 (file)
@@ -107,8 +107,8 @@ class Pman_Core_UpdateDatabase_MysqlEngineCharset {
             
             $ce = DB_DataObject::factory('core_enum');
             // not sure why, but convert to does not actually change the 'charset=' bit..
-            $ce->query("ALTER TABLE $tbl CHARSET=utf8");
-            $ce->query("ALTER TABLE {$tbl} CONVERT TO CHARACTER SET  utf8 COLLATE utf8_general_ci");
+            $ce->query("ALTER TABLE `$tbl` CHARSET=utf8");
+            $ce->query("ALTER TABLE `{$tbl}` CONVERT TO CHARACTER SET  utf8 COLLATE utf8_general_ci");
             echo "utf8: FIXED {$tbl}\n";
             
         }