Jump to content


[SOLVED] mySQL v5.7.24 Not Compatible

N2N Truncated incorrect DOUBLE va

  • Please log in to reply
1 reply to this topic

#1 Mugs321

Mugs321

    Member

  • Members
  • PipPip
  • 16 posts
  • LocationCanada

Posted 18 November 2018 - 07: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



#2 Mugs321

Mugs321

    Member

  • Members
  • PipPip
  • 16 posts
  • LocationCanada

Posted 18 November 2018 - 10:51 PM

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







Also tagged with one or more of these keywords: N2N, Truncated incorrect DOUBLE va

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users