登录Ecshop出现MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO ecshop
.ecs_stats
( ip_address, visit_times, browser, system,language, area, referer_domain, referer_path, access_url, access_time) VALUES (‘0.0.0.0’, ‘6’, ‘Safari 537.36’, ‘Windows NT’, ‘zh-CN,zh’, ‘广东省广州市’, ‘’, ‘’, ‘/ecshop/index.php’, ‘1588043370’) ) [2] => Array ( [error] => Table ‘ec2677.ecs_stats’ doesn’t exist ) [3] => Array ( [errno] => 1064 ) )
106就是Mysql版本导致的语句出错
实际语句应该是
INSERT INTO ecshop
.ecs_stats
( ip_address
, visit_times
, browser
, system
,language
, area
, referer_domain
, referer_path
, access_url
, access_time
) VALUES (‘0.0.0.0’, ‘6’, ‘Safari 537.36’, ‘Windows NT’, ‘zh-CN,zh’, ‘广东省广州市’, ‘’, ‘’, ‘/ecshop/index.php’, ‘1588043370’)
但是没办法去修改插入是语句。所以就像另一个办法找到插入stats的源文件的语句删掉就行了,应为stats删掉没有什么影响。
打开ecshop/includes/init.php找到代码
if (!defined(‘INGORE_VISIT_STATS’))
{
visit_stats();
}
(在230行左右,也可以直接查找)把代码注释掉或者删掉就行了。
那这个问题就解决啦!!