Wedge

Public area => The Pub => Importing into Wedge => Topic started by: Harz-FEAR on February 4th, 2014, 01:18 AM

Title: importer MySQL bug
Post by: Harz-FEAR on February 4th, 2014, 01:18 AM
The importer throws an error:
Code: [Select]
This query:
SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE;
Caused the error:
Unknown system variable 'SQL_MAX_JOIN_SIZE'

I changed line 366 in importer.php to
Code: [Select]
$results = $db->query("SELECT @@SQL_BIG_SELECTS, @@MAX_JOIN_SIZE");
and now it works fine.

MySQL version is 5.6.12
Title: Re: importer MySQL bug
Post by: live627 on February 4th, 2014, 06:52 AM
Moved. Even though this was in bug reports, I think it is better suited here and might grab @TE's attention faster.
Title: Re: importer MySQL bug
Post by: Nao on February 4th, 2014, 10:19 AM
It caught mine anyway ;)

SQL_ seems to have been removed somewhere before the release of v5.0 (since it can be seen in the 5.0 constant list in both spellings), and deprecated on 5.6... I guess.

So I should safely be able to commit the proposed fix. Once I'm done with breakfast, car duty, Himym, Brooklyn 99 and Uncle. In that order. :P
Posted: February 4th, 2014, 07:35 AM

Fixed in the repo. Thanks for the report! I can confirm that it's a MySQL 5.6 change, and that MySQL 5.0 should be fine with this change -- I tracked down the rename to MySQL 4.0!!