⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

[SOLVED] mySQL v5.7.24 Not Compatible

Started by Mugs321, 18 November 2018 - 19:23 PM

Single Page

Mugs321

Member

Posted 18 November 2018 - 19:23 PM

HI all,

Updated to mySQL v5.7.24 and this seems to have broken GC. I now get this error when saving an N2N record:

al error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: '63,1' in F:\Programming\Web\GroceryCrud\libraries\zendframework\zend-db\src\Adapter\Driver\Pdo\Statement.php on line 244

Looked at the SQL logs and this is the failing statement, specifically NOT IN ('63,1'):

DELETE FROM `game_uses_item` WHERE `ItemID` = '440' AND `GameID` NOT IN ('63,1')

This worked fine in mySQL v5.7.14.

Thx,

Dave

Mugs321

Member

Posted 18 November 2018 - 22:51 PM

Disregard. STRICT mode was turn on on my local mySQL.