Enable big selects error

[Jaanus]

I had "Enable big selects" on. After my host upgraded MySQL from 5.5 to 5.6, I saw an error message
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_BIG_SELECTS=1' at line 1 SQL=SET OPTION SQL_BIG_SELECTS=1
even in start page of admin. Had to turn it out using phpmyadmin in #__extensions table

 

[troester]

I think it must be
SET SQL_BIG_SELECTS=1

Older versions of MySQL employed SET OPTION, but this syntax is deprecated in favor of SET without OPTION.

http://dev.mysql.com/doc/refman/5.5/en/set-statement.html
It seems with OPTION is was ok until 5.5 but not longer in 5.6

And it is already deprecated in 5.1 (which is prerequisit for J!3).
http://dev.mysql.com/doc/refman/5.1/en/set-statement.html

 

[cheesegrits]

Should be fixed as of ...

https://github.com/Fabrik/fabrik/commit/24ea4ace436172760e8214879d8ef3b0ae980361

-- hugh

 

[Bauer]

Still throws a 500 error after any github update.
You added an "if" condition to compensate for different PHP versions in components/com_fabrik/helpers/parent.php and plugins/system/fabrik/fabrik.php - BUT you forgot about components/com_fabrik/models/list.php (line 792).