ANSI mode not supported

[pma-import]

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

---

- Original URL: https://sourceforge.net/p/phpmyadmin/bugs/1013/
- Original author: kirbinator
- Found in version: Latest_Git

[pma-import]

- assigned_to: rabus —> nobody

---

- Original author: lem9

[pma-import]

- summary: ANSI mode error when setting privledges —> ANSI mode not supported
- priority: 5 —> 2
- milestone: 333987 —> Latest_Git
- labels: 509098 —> Incompatibillity with new MySQL releases
- status: open —> open-later

---

- Original author: garvinhicking

[pma-import]

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. :-)

---

- Original author: garvinhicking

[pma-import]

server_privileges.php

---

- Original author: kirbinator
- Attachment: http://sourceforge.net/p/phpmyadmin/bugs/discuss/thread/425dc3b2/1579/attachment/serverprivileges.php

[pma-import]

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.

---

- Original author: kirbinator

[pma-import]

- assigned_to: nobody —> garvinhicking
- status: open-later —> open-remind

---

- Original author: kirbinator

[pma-import]

- assigned_to: garvinhicking —> nobody

---

- Original author: garvinhicking

[pma-import]

- assigned_to: nobody —> nijel

---

- Original author: nijel

[pma-import]

- status: open-remind —> open-fixed

---

- Original author: nijel

[pma-import]

- summary: ANSI mode not supported —> (in 2.6.1) ANSI mode not supported
- priority: 2 —> 1

---

- Original author: nijel

[pma-import]

Logged In: YES
user_id=192186

I converted all problematic places I found to use ’, if you
find any further errors, please report.

---

- Original author: nijel

[pma-import]

- status: open-fixed —> closed-fixed

---

- Original author: nijel

[pma-import]

• Status: closed-fixed --> fixed

---

• Original author: nijel