Please wait while loading...
Back sql-mode-caused-error

Sometimes we may got some sql error like belows:

- Field doesn't have a default values
- Incorrect integer value: '' for column

These because your MySQL server runing strict mode, if you don't want to change your sql statement, a simple solution is switch off the strict mode

find my.ini or my.cnf, add the following line to the end of the file and restart the service (for cPanel , the path may be /etc/ my.cnf)


comments powered by Disqus