#1013 (in 2.6.1) ANSI mode not supported

Latest_Git
fixed
1
2015-01-11
2003-10-02
No

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

Discussion

  • Marc Delisle

    Marc Delisle - 2003-10-31
    • assigned_to: rabus --> nobody
     
  • Garvin Hicking

    Garvin Hicking - 2003-11-04

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

     
  • Garvin Hicking

    Garvin Hicking - 2003-11-04
    • 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
     
  • Jeffrey A. Kirby

    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.

     
  • Jeffrey A. Kirby

    • assigned_to: nobody --> garvinhicking
    • status: open-later --> open-remind
     
  • Garvin Hicking

    Garvin Hicking - 2004-05-03
    • assigned_to: garvinhicking --> nobody
     
  • Michal Čihař

    Michal Čihař - 2004-10-19
    • assigned_to: nobody --> nijel
     
  • Michal Čihař

    Michal Čihař - 2004-10-19
    • status: open-remind --> open-fixed
     
  • Michal Čihař

    Michal Čihař - 2004-10-19
    • summary: ANSI mode not supported --> (in 2.6.1) ANSI mode not supported
    • priority: 2 --> 1
     
  • Michal Čihař

    Michal Čihař - 2004-10-19

    Logged In: YES
    user_id=192186

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

     
  • Michal Čihař

    Michal Čihař - 2005-01-24
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks