10:37:58 [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/Worker/entityDataHandle.php]的[158]行 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/Worker/entityDataHandle.php(28): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.25(0x18001924) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=149 [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]=2151 [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=Worker&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=149 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657679878.1956 [REQUEST_TIME]=1657679878 10:38:07 [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/Worker/entityDataHandle.php]的[158]行 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/Worker/entityDataHandle.php(28): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.25(0x18001924) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=149 [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]=2151 [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=Worker&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=149 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657679887.0452 [REQUEST_TIME]=1657679887 10:38:17 [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/Worker/entityDataHandle.php]的[158]行 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/Worker/entityDataHandle.php(28): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.25(0x18001924) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=149 [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]=2156 [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=Worker&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=149 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657679897.4609 [REQUEST_TIME]=1657679897 10:38:25 [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/Public/entityDataHandle.php]的[79]行 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/Public/entityDataHandle.php(21): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Public [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.25(0x18001924) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=149 [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]=2151 [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=Public&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=149 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657679905.9492 [REQUEST_TIME]=1657679905 10:38: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/Public/entityDataHandle.php]的[79]行 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/Public/entityDataHandle.php(21): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Public [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.25(0x18001924) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=149 [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]=2151 [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=Public&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=149 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657679918.0419 [REQUEST_TIME]=1657679918 10:38:42 [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/Public/entityDataHandle.php]的[79]行 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/Public/entityDataHandle.php(21): bizbase_recruitEntityHandle() #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #5 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Public [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.25(0x18001924) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=149 [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]=2151 [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=Public&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=149 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1657679922.9469 [REQUEST_TIME]=1657679922