Thread

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?

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.

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

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.

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