Menu
I don't know why but suddenly I getting the following error.
Till now it is working fine but today it will produce the following error
it is working fine when I test to the local server but when I uploaded to 000webhost server it will produce an error
Variable 'sql_mode' can't be set to the value of 'REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( @@sql_mode' SELECT
vValueFROMconfigurationsWHEREeStatus= 'Active' ANDvName= > 'PAGE_DATA_LIMIT' ORDER BYiSettingIdDESC
At Filename: core/MY_Model.php all code is working fine there is no error on Line Number: 94 which is displayed
940
How would one fix this? if you have access to the sed utility, try this command: sed -i 's/NO_AUTO_CREATE_USER//' mysqldump. sql to remove the "NO_AUTO_CREATE_USER" text from your dump file, and replace it with nothing. @pbnelson you should grep for NO_AUTO_CREATE_USER before you do this.
SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”; happens when different version of mysql is being used. When you are transfering from one server to another you should keep in mind the versions of database use in a new environment especially the mysql.
In MySQL 4.0, a server SQL mode system variable named sql_mode was introduced to allow configuring certain aspects of how the server executes SQL statements. Initially, this variable could be set only by means of the --sql-mode startup option. As MySQL 4.1.
If you are using Windows Operating System, check your directory my. cnf or my. ini file. sql_mode="TRADITIONAL".
Open file config/database.php and change value's variable stricton to be 'TRUE'
'stricton' => TRUE,
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
