:(

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 'AND o.END_DATE > '2018-09-23'' at line 1 [ SQL语句 ] : SELECT o.ID as O_ID,o.NAME as O_NAME,ac.NAME as C_NAME,a.NAME as D_NAME,w.WAGE_RANGE,o.COUNT,e.NAME as E_NAME,o.START_DATE,o.END_DATE,o.FLAG,o.UPDATE_TIME FROM `offer` as o LEFT JOIN `company` as c ON o.COMPANY_ID = c.ID LEFT JOIN `user` as u ON c.USER_ID = u.ID LEFT JOIN `jobposition` as j ON o.JOB_POSITION_ID = j.ID LEFT JOIN `area` as a ON o.WORK_ADDRESS = a.CODE LEFT JOIN `area` as ac ON a.PARENT = ac.CODE LEFT JOIN `wage` as w ON o.WAGE_RANGE = w.ID LEFT JOIN `educationbackground` as e ON o.EDUCATION_BACKGROUND = e.ID WHERE o.COMPANY_ID = AND o.END_DATE > '2018-09-23'

错误位置

FILE: E:\WebRoot\mmejob\ThinkPHP\Lib\Driver\Db\DbMysql.class.php  LINE: 320

TRACE

[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\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 'AND o.END_DATE > '2018-09-23'' at line 1
[ SQL语句 ] : SELECT o.ID as O_ID,o.NAME as O_NAME,ac.NAME as C_NAME,a.NAME as D_NAME,w.WAGE_RANGE,o.COUNT,e.NAME as E_NAME,o.START_DATE,o.END_DATE,o.FLAG,o.UPDATE_TIME FROM `offer` as o LEFT JOIN `company` as c ON o.COMPANY_ID = c.ID LEFT JOIN `user` as u ON c.USER_ID = u.ID LEFT JOIN `jobposition` as j ON o.JOB_POSITION_ID = j.ID LEFT JOIN `area` as a ON o.WORK_ADDRESS = a.CODE LEFT JOIN `area` as ac ON a.PARENT = ac.CODE LEFT JOIN `wage` as w ON o.WAGE_RANGE = w.ID LEFT JOIN `educationbackground` as e ON o.EDUCATION_BACKGROUND = e.ID WHERE o.COMPANY_ID = AND o.END_DATE > '2018-09-23', , ERR)
[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\Lib\Driver\Db\DbMysql.class.php (107) DbMysql->error()
[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\Lib\Core\Model.class.php (1078) DbMysql->query(SELECT o.ID as O_ID,o.NAME as O_NAME,ac.NAME as C_NAME,a.NAME as D_NAME,w.WAGE_RANGE,o.COUNT,e.NAME as E_NAME,o.START_DATE,o.END_DATE,o.FLAG,o.UPDATE_TIME FROM `offer` as o LEFT JOIN `company` as c ON o.COMPANY_ID = c.ID LEFT JOIN `user` as u ON c.USER_ID = u.ID LEFT JOIN `jobposition` as j ON o.JOB_POSITION_ID = j.ID LEFT JOIN `area` as a ON o.WORK_ADDRESS = a.CODE LEFT JOIN `area` as ac ON a.PARENT = ac.CODE LEFT JOIN `wage` as w ON o.WAGE_RANGE = w.ID LEFT JOIN `educationbackground` as e ON o.EDUCATION_BACKGROUND = e.ID WHERE o.COMPANY_ID = AND o.END_DATE > '2018-09-23')
[18-09-23 02:33:09] E:\WebRoot\mmejob\WebRoot\Lib\DAO\OfferDao.class.php (73) Model->query(SELECT o.ID as O_ID,o.NAME as O_NAME,ac.NAME as C_NAME,a.NAME as D_NAME,w.WAGE_RANGE,o.COUNT,e.NAME as E_NAME,o.START_DATE,o.END_DATE,o.FLAG,o.UPDATE_TIME FROM `offer` as o LEFT JOIN `company` as c ON o.COMPANY_ID = c.ID LEFT JOIN `user` as u ON c.USER_ID = u.ID LEFT JOIN `jobposition` as j ON o.JOB_POSITION_ID = j.ID LEFT JOIN `area` as a ON o.WORK_ADDRESS = a.CODE LEFT JOIN `area` as ac ON a.PARENT = ac.CODE LEFT JOIN `wage` as w ON o.WAGE_RANGE = w.ID LEFT JOIN `educationbackground` as e ON o.EDUCATION_BACKGROUND = e.ID WHERE o.COMPANY_ID = AND o.END_DATE > '2018-09-23')
[18-09-23 02:33:09] E:\WebRoot\mmejob\WebRoot\Lib\Service\OfferService.class.php (52) OfferDao->getByCompanyIDAndValid()
[18-09-23 02:33:09] E:\WebRoot\mmejob\WebRoot\Lib\Action\WebAction.class.php (767) OfferService->getByCompanyIDAndValid()
[18-09-23 02:33:09] () WebAction->companyViewPage()
[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\Lib\Core\App.class.php (172) ReflectionMethod->invoke()
[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\Lib\Core\App.class.php (208) App::exec()
[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\Lib\Core\Think.class.php (39) App::run()
[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\Common\runtime.php (243) Think::start()
[18-09-23 02:33:09] E:\WebRoot\mmejob\ThinkPHP\ThinkPHP.php (30) require(E:\WebRoot\mmejob\ThinkPHP\Common\runtime.php)
[18-09-23 02:33:09] E:\WebRoot\mmejob\WebRoot\index.php (11) require(E:\WebRoot\mmejob\ThinkPHP\ThinkPHP.php)