KLAMP Posted May 25, 2016 Share Posted May 25, 2016 (edited) Hi, I am getting the following warning in the installation whmcs can you help me how can I solve it Strict SQL Mode Detected Please disable strict SQL mode before continuing. - Removed - Edited May 26, 2016 by Infopro Please Attach Images to Your Posts. 0 Quote Link to comment Share on other sites More sharing options...
servetas Posted May 26, 2016 Share Posted May 26, 2016 Make the following changes in the "my.ini/my.cnf": -Look for the following line: sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" -Change it to: sql-mode="" (Blank) -Restart the MySQL service. 0 Quote Link to comment Share on other sites More sharing options...
KLAMP Posted May 26, 2016 Author Share Posted May 26, 2016 "my.ini/my.cnf typing the command out nano /etc/my.cnf used the CNF command the content of the command below but it didn't change anything sql-mode="" innodb_file_per_table=1 default-storage-engine=MyISAM performance-schema=0 max_allowed_packet=268435456 open_files_limit=10000 Make the following changes in the "my.ini/my.cnf":-Look for the following line: sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" -Change it to: sql-mode="" (Blank) -Restart the MySQL service. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.