ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

1.4.2 -> 1.6 upgrade MySQL Error Number: 1193

June 27, 2007 2:20am

Subscribe [0]
  • #1 / Jun 27, 2007 2:20am

    Holly Hill

    19 posts

    Followed upgrade instructions to the letter, but getting this error:

    “Error: The following error was encountered
    MySQL ERROR:

    Error Number: 1193

    Description: Unknown system variable ‘global.sql_mode’

    Query: SELECT CONCAT(@@global.sql_mode, @@session.sql_mode) AS sql_mode
    ExpressionEngine by EllisLab - © copyright 2003 - 2007 - EllisLab, Inc. - All Rights Reserved”

    We are hosted on mediatemple, mysql version 3.23.58

    any ideas?

  • #2 / Jun 27, 2007 2:50am

    Derek Jones

    7561 posts

    Hm, well the MySQL docs weren’t very clear that the select would not work in older versions of MySQL, but it looks like that is the case (3.23.58 is rather old, and I’d think that (mt) would offer a more current version, which you might request).  For a quick fix, you can comment out or remove the following from update.php:

    $mode_query = $DB->query("SELECT CONCAT(@@global.sql_mode, @@session.sql_mode) AS sql_mode");
    
    if (strpos(strtoupper($mode_query->row['sql_mode']), 'STRICT') !== FALSE)
    {
        Update::page_header();
        $DB->db_error("Database Error: ExpressionEngine will not run on a MySQL server operating in strict mode");
    }

    Should be just fine as (mt) doesn’t run MySQL in strict mode, or at least, we have not heard of such.

  • #3 / Jun 27, 2007 2:59am

    Holly Hill

    19 posts

    Perfect, that did solve the problem for now. I am putting in a request to get our MySQL updated.

  • #4 / Jun 27, 2007 4:22am

    Paul Burdick

    480 posts

    If they need any convincing, you might want to point out that that version is nearly four years old and MySQL ceased supporting it a year ago.

  • #5 / Jun 27, 2007 4:40am

    Holly Hill

    19 posts

    Thanks, I’ll give that a try and see what they say tomorrow.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases