:(

Unknown column 'date' in 'where clause' [ SQL语句 ] : SELECT id,ssbh,ssmc,sfsj,zt,type,sfd,datatype FROM sp_race_info where id!='' AND type=date order by sfsj desc limit 0,20

错误位置

FILE: /www/wwwroot/086019.com/ThinkPHP/Lib/Driver/Db/DbMysql.class.php 　LINE: 320

TRACE

[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/Lib/Driver/Db/DbMysql.class.php (320) trace(Unknown column 'date' in 'where clause'
[ SQL语句 ] : SELECT id,ssbh,ssmc,sfsj,zt,type,sfd,datatype FROM sp_race_info where id!='' AND type=date order by sfsj desc limit 0,20, , ERR)
[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/Lib/Driver/Db/DbMysql.class.php (107) DbMysql->error()
[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/Lib/Core/Model.class.php (1078) DbMysql->query(SELECT id,ssbh,ssmc,sfsj,zt,type,sfd,datatype FROM sp_race_info where id!='' AND type=date order by sfsj desc limit 0,20)
[24-04-27 00:41:04] /www/wwwroot/086019.com/Application/Lib/Action/Home/liveAction.class.php (2846) Model->query(SELECT id,ssbh,ssmc,sfsj,zt,type,sfd,datatype FROM sp_race_info where id!='' AND type=date order by sfsj desc limit 0,20)
[24-04-27 00:41:04] () liveAction->index(20)
[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/Lib/Core/App.class.php (181) ReflectionMethod->invokeArgs(, Array)
[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/Lib/Core/App.class.php (219) App::exec()
[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/Lib/Core/Think.class.php (39) App::run()
[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/Common/runtime.php (243) Think::start()
[24-04-27 00:41:04] /www/wwwroot/086019.com/ThinkPHP/ThinkPHP.php (34) require(/www/wwwroot/086019.com/ThinkPHP/Common/runtime.php)
[24-04-27 00:41:04] /www/wwwroot/086019.com/index.php (32) require(/www/wwwroot/086019.com/ThinkPHP/ThinkPHP.php)

ThinkPHP3.1 { Fast & Simple OOP PHP Framework } -- [ WE CAN DO IT JUST THINK ]