变量"sql_mode"不能设置为"REPLACE"的值 [英] Variable 'sql_mode' can't be set to the value of 'REPLACE

问题描述

我不知道为什么，但是突然出现以下错误.

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

当我对本地服务器进行测试时，它工作正常，但是当我将其上传到000webhost服务器时，它将产生错误

it is working fine when I test to the local server but when I uploaded to 000webhost server it will produce an error

变量'sql_mode'不能设置为的值 'REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@@ sql_mode' 在configurations中从eStatus ='Active'和vName =>'PAGE_DATA_LIMIT'排序iSettingId DESC

Variable 'sql_mode' can't be set to the value of 'REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( @@sql_mode' SELECT vValue FROM configurations WHERE eStatus = 'Active' AND vName = > 'PAGE_DATA_LIMIT' ORDER BY iSettingId DESC

在Filename: core/MY_Model.php处，所有代码都可以正常工作，显示的Line Number: 94上没有错误

At Filename: core/MY_Model.php all code is working fine there is no error on Line Number: 94 which is displayed

推荐答案

打开文件config/database.php 并将值的变量stricton更改为"TRUE"

Open file config/database.php and change value's variable stricton to be 'TRUE'

'stricton' => TRUE,

这篇关于变量"sql_mode"不能设置为"REPLACE"的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！