:(

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as `ts_sme_timenode1`' at line 1 [ SQL语句 ] : SELECT count(id) as count FROM (SELECT a.id, a.title, a.createtime,a.level,a.istop, a.titlefontcolor, a.titlefonttype, b.maxtimenode, b.zjtimenode, b.timenodearr FROM `ts_sme_notice` a left join ( SELECT noticeid,max(timenode) as maxtimenode,min(timenode) as zjtimenode,GROUP_CONCAT(CONCAT(timenode,"/",timenodedescribe) order by timenode ASC) as timenodearr FROM `ts_sme_timenode` where timenode >= curdate() group by noticeid) b on a.id=b.noticeid where (level like '%%' and artstatus = 'release' and (perennialdeclare 1 or perennialdeclare is null)) ORDER BY ) as `ts_sme_timenode1`

错误位置

FILE: D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Lib\Driver\Db\DbMysql.class.php  LINE: 320

TRACE

[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Lib\Driver\Db\DbMysql.class.php (320) trace(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as `ts_sme_timenode1`' at line 1
[ SQL语句 ] : SELECT count(id) as count FROM (SELECT a.id, a.title, a.createtime,a.level,a.istop, a.titlefontcolor, a.titlefonttype, b.maxtimenode, b.zjtimenode, b.timenodearr FROM `ts_sme_notice` a left join ( SELECT noticeid,max(timenode) as maxtimenode,min(timenode) as zjtimenode,GROUP_CONCAT(CONCAT(timenode,"/",timenodedescribe) order by timenode ASC) as timenodearr FROM `ts_sme_timenode` where timenode >= curdate() group by noticeid) b on a.id=b.noticeid where (level like '%%' and artstatus = 'release' and (perennialdeclare <> 1 or perennialdeclare is null)) ORDER BY ) as `ts_sme_timenode1`, , ERR)
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Lib\Driver\Db\DbMysql.class.php (107) DbMysql->error()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Lib\Core\Model.class.php (0) DbMysql->query()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Extend\Library\ORG\Util\ModelTools.class.php (297) Model->query(SELECT count(id) as count FROM (SELECT a.id, a.title, a.createtime,a.level,a.istop, a.titlefontcolor, a.titlefonttype, b.maxtimenode, b.zjtimenode, b.timenodearr FROM `ts_sme_notice` a left join ( SELECT noticeid,max(timenode) as maxtimenode,min(timenode) as zjtimenode,GROUP_CONCAT(CONCAT(timenode,"/",timenodedescribe) order by timenode ASC) as timenodearr FROM `ts_sme_timenode` where timenode >= curdate() group by noticeid) b on a.id=b.noticeid where (level like '%%' and artstatus = 'release' and (perennialdeclare <> 1 or perennialdeclare is null)) ORDER BY ) as `ts_sme_timenode1`)
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Extend\Model\BaseModel.class.php (0) ModelTools::queryRecordBySql()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Apps\sme\Lib\Model\Notice\NoticeModel.class.php (148) BaseModel->queryRecordBySql(SELECT a.id, a.title, a.createtime,a.level,a.istop, a.titlefontcolor, a.titlefonttype, b.maxtimenode, b.zjtimenode, b.timenodearr FROM `ts_sme_notice` a left join ( SELECT noticeid,max(timenode) as maxtimenode,min(timenode) as zjtimenode,GROUP_CONCAT(CONCAT(timenode,"/",timenodedescribe) order by timenode ASC) as timenodearr FROM `ts_sme_timenode` where timenode >= curdate() group by noticeid) b on a.id=b.noticeid where (level like '%%' and artstatus = 'release' and (perennialdeclare <> 1 or perennialdeclare is null)) ORDER BY , SELECT count(id) as count FROM (SELECT a.id, a.title, a.createtime,a.level,a.istop, a.titlefontcolor, a.titlefonttype, b.maxtimenode, b.zjtimenode, b.timenodearr FROM `ts_sme_notice` a left join ( SELECT noticeid,max(timenode) as maxtimenode,min(timenode) as zjtimenode,GROUP_CONCAT(CONCAT(timenode,"/",timenodedescribe) order by timenode ASC) as timenodearr FROM `ts_sme_timenode` where timenode >= curdate() group by noticeid) b on a.id=b.noticeid where (level like '%%' and artstatus = 'release' and (perennialdeclare <> 1 or perennialdeclare is null)) ORDER BY ) as `ts_sme_timenode1`, Array)
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Apps\sme\Lib\Action\Home\NoticeAction.class.php (76) NoticeModel->queryRecordForShow(, i)
[20-06-02 08:37:06] () NoticeAction->index()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Lib\Core\App.class.php (186) ReflectionMethod->invoke()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Lib\Core\App.class.php (222) App::exec()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Lib\Core\Think.class.php (39) App::run()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Common\runtime.php (243) Think::start()
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\ThinkPHP.php (30) require(D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\Common\runtime.php)
[20-06-02 08:37:06] D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Apps\sme\index.php (38) require(D:\UPUPW_ANK_W64\WebRoot\Vhosts\product\jyetsc\Core\ThinkPHP.php)