#1013 (in 2.6.1) ANSI mode not supported
The error below is received when I am in ANSI mode. If
I turn ANSI mode off I do NOT receive the error. It
appears as though the queries in server_privileges.php
do not take into account the fact that you are using
MySQL in ANSI mode.
Warning: Your privilege table structure seem to be older
than this MySQL version!
Please run the script mysql_fix_privilege_tables that
should be included in your MySQL server distribution to
solve this problem!
Notice: Undefined index: Password in C:\phpMyAdmin-
2.5.3\server_privileges.php on line 997
Notice: Undefined index: Password in C:\phpMyAdmin-
2.5.3\server_privileges.php on line 997
Notice: Undefined index: Password in C:\phpMyAdmin-
2.5.3\server_privileges.php on line 997
Notice: Undefined index: Password in C:\phpMyAdmin-
2.5.3\server_privileges.php on line 997
Logged In: YES
user_id=473563
When you use sql_mode=ANSI, all quote-characters ('"') can
no longer be used for string identification. See
https://sourceforge.net/tracker/index.php?func=detail&aid=816858&group_id=23067&atid=377408
That means, phpMyAdmin is in many, many occasions not
compatible with ANSI mode.
Reading through that, I can't find a replacement for '"' in
ANSI-mode, so we can't just switch to that.
I will add this as a known limitation to phpMyAdmin and
suppose this won't be fixed any time soon. Or, maybe one is
volunteering to put some effort into this compatibility
issue. :-)
server_privileges.php
Logged In: YES
user_id=879201
Dear phpMyAdmin staff,
I took you up on the offer of volunteering to put some effort
into this compatiability issue. I have attached
server_privileges.php with my changes... which by the way is
to change all double quotes in SQL statements (") with a
backslash single quote (\'). This works in any SQL mode.
This is a relatively easy fix and probably should be applied to
the rest of the code base for phpMyAdmin. If you have any
questions, please feel free to ask.
Sincerely,
Jeffrey Kirby
P.S. Kevin Grittner also contributed to this code fix.
Logged In: YES
user_id=192186
I converted all problematic places I found to use ', if you
find any further errors, please report.