diff options
author | Alexander M. Turek <me@derrabus.de> | 2004-04-20 02:10:42 +0400 |
---|---|---|
committer | Alexander M. Turek <me@derrabus.de> | 2004-04-20 02:10:42 +0400 |
commit | 7281232b884ccff2b533624d8adb8a13bcbcc295 (patch) | |
tree | aae53582c6640533969a9ce507b52421c7a2d6d1 /server_privileges.php | |
parent | 4199893379e8ad352864c7f25336f7dd5eb03296 (diff) |
Illegal mix of collations.
There's more where this came from... Will do the rest tomorrow.
Diffstat (limited to 'server_privileges.php')
-rw-r--r-- | server_privileges.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server_privileges.php b/server_privileges.php index e8d4fefbc5..3b1346b78b 100644 --- a/server_privileges.php +++ b/server_privileges.php @@ -1061,7 +1061,7 @@ if (empty($adduser) && empty($checkprivs)) { if (empty($dbname)) { $sql_query = 'SELECT * FROM `db` WHERE `Host` = "' . $hostname . '" AND `User` = "' . PMA_sqlAddslashes($username) . '" ORDER BY `Db` ASC;'; } else { - $sql_query = 'SELECT `Table_name`, `Table_priv`, IF(`Column_priv` = "", 0, 1) AS "Column_priv" FROM `tables_priv` WHERE `Host` = "' . $hostname . '" AND `User` = "' . PMA_sqlAddslashes($username) . '" AND `Db` = "' . $dbname . '" ORDER BY `Table_name` ASC;'; + $sql_query = 'SELECT `Table_name`, `Table_priv`, IF(`Column_priv` = ' . (PMA_MYSQL_INT_VERSION >= 40100 ? '_latin1 ' : '') . ' "", 0, 1) AS "Column_priv" FROM `tables_priv` WHERE `Host` = "' . $hostname . '" AND `User` = "' . PMA_sqlAddslashes($username) . '" AND `Db` = "' . $dbname . '" ORDER BY `Table_name` ASC;'; } $res = PMA_DBI_query($sql_query, NULL, PMA_DBI_QUERY_STORE); if (PMA_DBI_affected_rows() == 0) { |