16:11:05 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php]的[232]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php(88): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Plater [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=https://admin.kuailaiyou.top/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=same-site [HTTP_ORIGIN]=https://admin.kuailaiyou.top [HTTP_CONTENT_TYPE]=application/json;charset=UTF-8 [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36 [HTTP_SEC_CH_UA_MOBILE]=?0 [HTTP_ACCEPT]=application/json, text/plain, */* [HTTP_SEC_CH_UA]=" Not A;Brand";v="99", "Chromium";v="90", "Google Chrome";v="90" [HTTP_CONTENT_LENGTH]=148 [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]=1778 [REMOTE_ADDR]=106.114.71.33 [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=Plater&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=148 [CONTENT_TYPE]=application/json;charset=UTF-8 [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Plater&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657699865.5096 [REQUEST_TIME]=1657699865 16:11:28 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php]的[232]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php(88): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Plater [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=https://admin.kuailaiyou.top/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=same-site [HTTP_ORIGIN]=https://admin.kuailaiyou.top [HTTP_CONTENT_TYPE]=application/json;charset=UTF-8 [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36 [HTTP_SEC_CH_UA_MOBILE]=?0 [HTTP_ACCEPT]=application/json, text/plain, */* [HTTP_SEC_CH_UA]=" Not A;Brand";v="99", "Chromium";v="90", "Google Chrome";v="90" [HTTP_CONTENT_LENGTH]=148 [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]=1776 [REMOTE_ADDR]=106.114.71.33 [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=Plater&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=148 [CONTENT_TYPE]=application/json;charset=UTF-8 [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Plater&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657699888.588 [REQUEST_TIME]=1657699888 16:11:38 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php]的[232]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php(88): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Plater [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=https://admin.kuailaiyou.top/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=same-site [HTTP_ORIGIN]=https://admin.kuailaiyou.top [HTTP_CONTENT_TYPE]=application/json;charset=UTF-8 [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36 [HTTP_SEC_CH_UA_MOBILE]=?0 [HTTP_ACCEPT]=application/json, text/plain, */* [HTTP_SEC_CH_UA]=" Not A;Brand";v="99", "Chromium";v="90", "Google Chrome";v="90" [HTTP_CONTENT_LENGTH]=148 [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]=1776 [REMOTE_ADDR]=106.114.71.33 [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=Plater&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=148 [CONTENT_TYPE]=application/json;charset=UTF-8 [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Plater&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657699898.7918 [REQUEST_TIME]=1657699898 16:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php]的[232]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list' sql语句:select btr.* ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed ,bt.profile_photo as bt_profile_photo , bt.linker_gender as bt_linker_gender ,bt.company_desc as bt_company_desc ,bt.linker_phone as bt_linker_phone ,bt.linker_name as bt_linker_name ,bt.company_addr as bt_company_addr ,(select concat(id,'-',workteam_mode,'-',workteamid,'-',teamstatus,'-',`status`) from biz_todowork tdwk where tdwk.biz_recruitid=btr.id and tdwk.biz_workerid=:biz_workerid order by id desc limit 1 ) as lasttodowork ,(select ifnull(avg(result_level),0) from biz_appraisal bapr where bapr.biz_catalog=1 and bapr.toerid=btr.biz_traderid ) as trader_appraisal_avg ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name) from biz_recruit_delegate brd left join biz_trader2 bt on bt.id=brd.biz_trader2id left join base_user bu on bu.id=bt.base_userid where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime limit 1) as delegate_info from biz_trader_recruit btr left join biz_trader bt on bt.id=btr.biz_traderid left join base_user bu on bu.id=bt.base_userid where btr.id=:recruitid ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php(88): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Plater [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=https://admin.kuailaiyou.top/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=same-site [HTTP_ORIGIN]=https://admin.kuailaiyou.top [HTTP_CONTENT_TYPE]=application/json;charset=UTF-8 [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36 [HTTP_SEC_CH_UA_MOBILE]=?0 [HTTP_ACCEPT]=application/json, text/plain, */* [HTTP_SEC_CH_UA]=" Not A;Brand";v="99", "Chromium";v="90", "Google Chrome";v="90" [HTTP_CONTENT_LENGTH]=148 [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]=1776 [REMOTE_ADDR]=106.114.71.33 [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=Plater&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=148 [CONTENT_TYPE]=application/json;charset=UTF-8 [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Plater&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657699907.8484 [REQUEST_TIME]=1657699907 16:40:15 [error]: 通用的实体数据存取接口异常:数据库执行异常:Column 'id' in where clause is ambiguous sql语句:select bt.*,bu.mobile as bu_mobile from biz_trader as bt left join base_user bu on bu.id=bt.base_userid where id = 87 ["23000",1052,"Column 'id' in where clause is ambiguous"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php]的[232]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Column 'id' in where clause is ambiguous sql语句:select bt.*,bu.mobile as bu_mobile from biz_trader as bt left join base_user bu on bu.id=bt.base_userid where id = 87 ["23000",1052,"Column 'id' in where clause is ambiguous"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(44): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php(88): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Plater [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=https://admin.kuailaiyou.top/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=same-site [HTTP_ORIGIN]=https://admin.kuailaiyou.top [HTTP_CONTENT_TYPE]=application/json;charset=UTF-8 [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36 [HTTP_SEC_CH_UA_MOBILE]=?0 [HTTP_ACCEPT]=application/json, text/plain, */* [HTTP_SEC_CH_UA]=" Not A;Brand";v="99", "Chromium";v="90", "Google Chrome";v="90" [HTTP_CONTENT_LENGTH]=148 [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]=1504 [REMOTE_ADDR]=106.114.71.33 [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=Plater&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=148 [CONTENT_TYPE]=application/json;charset=UTF-8 [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Plater&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657701615.7239 [REQUEST_TIME]=1657701615 16:40:23 [error]: 通用的实体数据存取接口异常:数据库执行异常:Column 'id' in where clause is ambiguous sql语句:select bt.*,bu.mobile as bu_mobile from biz_trader as bt left join base_user bu on bu.id=bt.base_userid where id = 87 ["23000",1052,"Column 'id' in where clause is ambiguous"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php]的[232]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Column 'id' in where clause is ambiguous sql语句:select bt.*,bu.mobile as bu_mobile from biz_trader as bt left join base_user bu on bu.id=bt.base_userid where id = 87 ["23000",1052,"Column 'id' in where clause is ambiguous"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(44): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Plater/entityDataHandle.php(88): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Plater [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9 [HTTP_ACCEPT_ENCODING]=gzip, deflate, br [HTTP_REFERER]=https://admin.kuailaiyou.top/ [HTTP_SEC_FETCH_DEST]=empty [HTTP_SEC_FETCH_MODE]=cors [HTTP_SEC_FETCH_SITE]=same-site [HTTP_ORIGIN]=https://admin.kuailaiyou.top [HTTP_CONTENT_TYPE]=application/json;charset=UTF-8 [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36 [HTTP_SEC_CH_UA_MOBILE]=?0 [HTTP_ACCEPT]=application/json, text/plain, */* [HTTP_SEC_CH_UA]=" Not A;Brand";v="99", "Chromium";v="90", "Google Chrome";v="90" [HTTP_CONTENT_LENGTH]=148 [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]=1498 [REMOTE_ADDR]=106.114.71.33 [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=Plater&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=148 [CONTENT_TYPE]=application/json;charset=UTF-8 [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Plater&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657701623.0376 [REQUEST_TIME]=1657701623