09:36:44 [error]: 通用分页查询排序接口异常:数据库执行异常:Unknown column 'wk.id' in 'on clause' sql语句: select bwa.*,tdwk.id as tdwk_id,btr.id as btr_id ,btr.title as btr_title ,bt.company_name,btbu.mobile as btbu_mobile ,swk.true_name as swk_true_name,sbu.mobile as sbu_mobile ,count(bwa.id) as work_total,sum(bwa.money) as money_total from biz_worker_account bwa inner join biz_trader_account bta on bta.id=bwa.biz_id inner join biz_todowork tdwk on tdwk.id=bta.biz_id left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid left join biz_worker swk on wk.id=tdwk.biz_workerid left join base_user sbu on bu.id=swk.base_userid left join biz_trader bt on bt.id=btr.biz_traderid left join base_user btbu on btbu.id=bt.base_userid where bwa.type=0 and bwa.`status`=1 and bwa.biz_catalog=1 and bwa.`deleted`=0 and 1=1 and bwa.biz_workerid=3 group by tdwk.id order by money_total desc limit 0,1000 ["42S22",1054,"Unknown column 'wk.id' in 'on clause'"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/fetchPageData.php]的[98]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Unknown column 'wk.id' in 'on clause' sql语句: select bwa.*,tdwk.id as tdwk_id,btr.id as btr_id ,btr.title as btr_title ,bt.company_name,btbu.mobile as btbu_mobile ,swk.true_name as swk_true_name,sbu.mobile as sbu_mobile ,count(bwa.id) as work_total,sum(bwa.money) as money_total from biz_worker_account bwa inner join biz_trader_account bta on bta.id=bwa.biz_id inner join biz_todowork tdwk on tdwk.id=bta.biz_id left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid left join biz_worker swk on wk.id=tdwk.biz_workerid left join base_user sbu on bu.id=swk.base_userid left join biz_trader bt on bt.id=btr.biz_traderid left join base_user btbu on btbu.id=bt.base_userid where bwa.type=0 and bwa.`status`=1 and bwa.biz_catalog=1 and bwa.`deleted`=0 and 1=1 and bwa.biz_workerid=3 group by tdwk.id order by money_total desc limit 0,1000 ["42S22",1054,"Unknown column 'wk.id' in 'on clause'"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(207): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(29): PdoUtil->fetchall() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(537): pdo_fetchall() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/fetchPageData.php(31): bizbase_workerAboutQuery() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=fetchPageData [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=http://localhost:8080/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=cross-site [HTTP_ORIGIN]=http://localhost:8080 [HTTP_ACCEPT]=*/* [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1 [HTTP_CACHE_CONTROL]=no-cache [HTTP_PRAGMA]=no-cache [HTTP_CONTENT_LENGTH]=226 [HTTP_CONNECTION]=keep-alive [HTTP_HOST]=api.kuailaiyou.top [REDIRECT_STATUS]=200 [SERVER_NAME]=api.kuailaiyou.top [SERVER_PORT]=443 [SERVER_ADDR]=172.18.217.149 [REMOTE_PORT]=19265 [REMOTE_ADDR]=60.24.227.178 [SERVER_SOFTWARE]=nginx/1.20.1 [GATEWAY_INTERFACE]=CGI/1.1 [HTTPS]=on [REQUEST_SCHEME]=https [SERVER_PROTOCOL]=HTTP/1.1 [DOCUMENT_ROOT]=/bizroot/approot/klywebapi [DOCUMENT_URI]=/ajaxEntryCenter.php [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=fetchPageData [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=226 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=fetchPageData [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1639445804.7484 [REQUEST_TIME]=1639445804 09:37:24 [error]: 通用分页查询排序接口异常:数据库执行异常:Unknown column 'bu.id' in 'on clause' sql语句: select bwa.*,tdwk.id as tdwk_id,btr.id as btr_id ,btr.title as btr_title ,bt.company_name,btbu.mobile as btbu_mobile ,swk.true_name as swk_true_name,sbu.mobile as sbu_mobile ,count(bwa.id) as work_total,sum(bwa.money) as money_total from biz_worker_account bwa inner join biz_trader_account bta on bta.id=bwa.biz_id inner join biz_todowork tdwk on tdwk.id=bta.biz_id left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid left join biz_worker swk on swk.id=tdwk.biz_workerid left join base_user sbu on bu.id=swk.base_userid left join biz_trader bt on bt.id=btr.biz_traderid left join base_user btbu on btbu.id=bt.base_userid where bwa.type=0 and bwa.`status`=1 and bwa.biz_catalog=1 and bwa.`deleted`=0 and 1=1 and bwa.biz_workerid=3 group by tdwk.id order by money_total desc limit 0,1000 ["42S22",1054,"Unknown column 'bu.id' in 'on clause'"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/fetchPageData.php]的[98]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Unknown column 'bu.id' in 'on clause' sql语句: select bwa.*,tdwk.id as tdwk_id,btr.id as btr_id ,btr.title as btr_title ,bt.company_name,btbu.mobile as btbu_mobile ,swk.true_name as swk_true_name,sbu.mobile as sbu_mobile ,count(bwa.id) as work_total,sum(bwa.money) as money_total from biz_worker_account bwa inner join biz_trader_account bta on bta.id=bwa.biz_id inner join biz_todowork tdwk on tdwk.id=bta.biz_id left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid left join biz_worker swk on swk.id=tdwk.biz_workerid left join base_user sbu on bu.id=swk.base_userid left join biz_trader bt on bt.id=btr.biz_traderid left join base_user btbu on btbu.id=bt.base_userid where bwa.type=0 and bwa.`status`=1 and bwa.biz_catalog=1 and bwa.`deleted`=0 and 1=1 and bwa.biz_workerid=3 group by tdwk.id order by money_total desc limit 0,1000 ["42S22",1054,"Unknown column 'bu.id' in 'on clause'"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(207): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(29): PdoUtil->fetchall() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(537): pdo_fetchall() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/fetchPageData.php(31): bizbase_workerAboutQuery() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=fetchPageData [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=http://localhost:8080/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=cross-site [HTTP_ORIGIN]=http://localhost:8080 [HTTP_ACCEPT]=*/* [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1 [HTTP_CACHE_CONTROL]=no-cache [HTTP_PRAGMA]=no-cache [HTTP_CONTENT_LENGTH]=226 [HTTP_CONNECTION]=keep-alive [HTTP_HOST]=api.kuailaiyou.top [REDIRECT_STATUS]=200 [SERVER_NAME]=api.kuailaiyou.top [SERVER_PORT]=443 [SERVER_ADDR]=172.18.217.149 [REMOTE_PORT]=23585 [REMOTE_ADDR]=60.24.227.178 [SERVER_SOFTWARE]=nginx/1.20.1 [GATEWAY_INTERFACE]=CGI/1.1 [HTTPS]=on [REQUEST_SCHEME]=https [SERVER_PROTOCOL]=HTTP/1.1 [DOCUMENT_ROOT]=/bizroot/approot/klywebapi [DOCUMENT_URI]=/ajaxEntryCenter.php [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=fetchPageData [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=226 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=fetchPageData [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1639445844.7681 [REQUEST_TIME]=1639445844