#4215 (ok 4.1.4) MariaDB 5.5: error in Drizzle detection

4.1.3
fixed
Marc Delisle
None
1
2014-08-26
2014-01-05
Ben
No

When I moved phpMyAdmin from an Alias/Location directive to just a Location directive in Apache, suddenly I got errors with Drizzle.

Error

SQL query: Edit Edit

SHOW VARIABLES LIKE "character_set_results"

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"character_set_results"' at line 1

I found a formatting error in libraries/DatabaseInterface.class.php at Lines 1442 - 1445:

$charset_result = $this->query(
    'SHOW VARIABLES LIKE "character_set_results"',
    $link
);

Correct syntax should be:

$charset_result = $this->query(
    "SHOW VARIABLES LIKE 'character_set_results'",
    $link
);

Discussion

  • Ben
    Ben
    2014-01-05

    Server version: 5.5.33-MariaDB-log - openSUSE package

    Database client version: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $

     
  • Marc Delisle
    Marc Delisle
    2014-01-05

    Ben,
    I don't understand: you are reporting an error with Drizzle but you show us that your server is running MariaDB.

     
  • Marc Delisle
    Marc Delisle
    2014-01-05

    • status: open --> pending
     
  • Ben
    Ben
    2014-01-06

    I've given you the error and the fix.

    The additional comment was further information.

     
  • Marc Delisle
    Marc Delisle
    2014-01-06

    Ben,
    which Drizzle version are you running?

     
  • Ben
    Ben
    2014-01-07

    I'm not...the error is in the call to get the parameter to check if Drizzle is installed....

                    /* Detect Drizzle - it does not support charsets */
                    $charset_result = $this->query(
                        "SHOW VARIABLES LIKE 'character_set_results'",
                        $link
                    );
                    if ($this->numRows($charset_result) == 0) {
                        define('PMA_DRIZZLE', true);
                    } else {
                        define('PMA_DRIZZLE', false);
                    }
                    $this->freeResult($charset_result);
    
                    PMA_Util::cacheSet(
                        'PMA_DRIZZLE',
                        PMA_DRIZZLE,
                        true
                    );
    
     
  • Marc Delisle
    Marc Delisle
    2014-01-07

    • status: pending --> open
    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2014-01-07

    • summary: Drizzle Formatting Error --> MariaDB 5.5: error in Drizzle detection
     
  • Marc Delisle
    Marc Delisle
    2014-01-07

    • summary: MariaDB 5.5: error in Drizzle detection --> (ok 4.1.4) MariaDB 5.5: error in Drizzle detection
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2014-01-07

    Fixed for 4.1.4, thanks.

     
  • Marc Delisle
    Marc Delisle
    2014-01-07

    • Status: resolved --> fixed