Page 1 of 1

database column doesn't have a default value

PostPosted: Wed Nov 23, 2016 6:34 pm
by seopanel_forum
It was due to the mysql setting - STRICT_TRANS_TABLES

Please do following setup in your server

=============================================================================
This is caused by the STRICT_TRANS_TABLES SQL mode defined in the %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini file. Removing that setting and restarting MySQL should fix the problem.
=======================================================================================

Also refer



This will fix all your issues.

Thanks for your support and also really sorry again for my late reply.

Re: database column doesn't have a default value

PostPosted: Mon Apr 24, 2017 7:29 pm
by seopanel_forum

Re: database column doesn't have a default value

PostPosted: Mon Dec 10, 2018 3:11 pm
by ATMDecor
Thank you for the help Seo Panel Team

Re: database column doesn't have a default value

PostPosted: Sat Jul 06, 2019 6:53 am
by andy123
Thanks for sharing the information about the database column.