From: Alan Knowles Date: Fri, 7 Aug 2020 07:30:34 +0000 (+0800) Subject: more quote identeiifers fixessss X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=443623f47935eb52acd65a3ff0d84eab1fd5a98b more quote identeiifers fixessss --- diff --git a/UpdateDatabase/MysqlEngineCharset.php b/UpdateDatabase/MysqlEngineCharset.php index f977bbe6..af2f66b3 100644 --- a/UpdateDatabase/MysqlEngineCharset.php +++ b/UpdateDatabase/MysqlEngineCharset.php @@ -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"; }