Jump to content


Photo

MySQL Strict Mode


  • Please log in to reply
2 replies to this topic

#1 lastday

lastday

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 12 October 2011 - 05:51 PM

Hello guys,

I just want to notify you about the issue we've found today.

If you have errors like '#1292 - Incorrect datetime value: '' for column 'completeddatetime' at row 1' while running tests you should simply turn off strict mode of your mysql. That would help.

Regards,
Egor.

#2 Jason

Jason

    Administrator

  • Administrators
  • 722 posts
  • LocationChicago

Posted 13 October 2011 - 08:48 PM

Thanks Egor. We will be adding this as a test for sql_mode and also as part of the installation system check.

Jason Green
Zurmo Team
Need support? Upgrade now


#3 Ivica

Ivica

    Advanced Member

  • Moderators
  • 479 posts

Posted 16 October 2011 - 05:15 AM

We are adding tests for checking if mysql is in strict mode or not, during installation process.
This was good catch, because on all our testing/development servers, MySql was not in strict mode.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users