Steps to fix SQL error "Out of range value adjusted for column ..." in MySQL 5

[khoffman]

I deployed Kayako on MySQL 5 and soon found I could not insert new staff or create tickets via email piping. After some digging, I found out it was due to "Out of range value adjusted for column ..." errors coming back from mysql.

The "Out of range value adjusted for column ..." mysql errors are due to MySQL 5 running with a strict sql-mode.

You need to edit /etc/my.cnf and change sql-mode to something like:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

It cannot have any of the STRICT options or many of the "meta" modes like TRADITIONAL because that will also include STRICT semantics. See

http://dev.mysql.com/doc/refman/5.0/...-sql-mode.html

for more information.

[ozgurerdogan]

I set this value in my php.ini file but I wonder if I have any trouble in future.

[supportskins]

You do not need to set it in php.ini rather you need to edit the sql-mode setting in your my.ini file which can be found in the Windows directory. my.ini file is a MySQL config file.