2022071312_entityDataHandle.log 103 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504
  1. 12:08:07 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  2. sql语句:select btr.*
  3. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  4. ,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
  5. ,(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
  6. ,(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
  7. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  8. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  9. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  10. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  11. from biz_recruit_delegate brd
  12. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  13. left join base_user bu on bu.id=bt.base_userid
  14. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  15. limit 1) as delegate_info
  16. from biz_trader_recruit btr
  17. left join biz_trader bt on bt.id=btr.biz_traderid
  18. left join base_user bu on bu.id=bt.base_userid
  19. where btr.id=:recruitid
  20. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  21. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  22. 异常堆栈上下文:
  23. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  24. #1 {main}
  25. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  26. sql语句:select btr.*
  27. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  28. ,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
  29. ,(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
  30. ,(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
  31. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  32. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  33. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  34. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  35. from biz_recruit_delegate brd
  36. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  37. left join base_user bu on bu.id=bt.base_userid
  38. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  39. limit 1) as delegate_info
  40. from biz_trader_recruit btr
  41. left join biz_trader bt on bt.id=btr.biz_traderid
  42. left join base_user bu on bu.id=bt.base_userid
  43. where btr.id=:recruitid
  44. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  45. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  46. 异常堆栈上下文:
  47. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  48. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  49. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  50. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  51. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  52. #5 {main}
  53. [上下文相关信息]:
  54. [WsAjaxPrj]=KLY
  55. [WsAjaxBiz]=Trader
  56. [WsAjaxAction]=entityDataHandle
  57. [USER]=nginxphp
  58. [HOME]=/home/nginxphp
  59. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  60. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  61. [HTTP_SEC_FETCH_DEST]=empty
  62. [HTTP_SEC_FETCH_MODE]=cors
  63. [HTTP_SEC_FETCH_SITE]=cross-site
  64. [HTTP_ACCEPT]=*/*
  65. [HTTP_CONTENT_TYPE]=application/json
  66. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  67. [HTTP_CONTENT_LENGTH]=149
  68. [HTTP_CONNECTION]=keep-alive
  69. [HTTP_HOST]=api.kuailaiyou.top
  70. [REDIRECT_STATUS]=200
  71. [SERVER_NAME]=api.kuailaiyou.top
  72. [SERVER_PORT]=443
  73. [SERVER_ADDR]=172.18.217.149
  74. [REMOTE_PORT]=23933
  75. [REMOTE_ADDR]=180.212.68.100
  76. [SERVER_SOFTWARE]=nginx/1.20.1
  77. [GATEWAY_INTERFACE]=CGI/1.1
  78. [HTTPS]=on
  79. [REQUEST_SCHEME]=https
  80. [SERVER_PROTOCOL]=HTTP/1.1
  81. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  82. [DOCUMENT_URI]=/ajaxEntryCenter.php
  83. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  84. [SCRIPT_NAME]=/ajaxEntryCenter.php
  85. [CONTENT_LENGTH]=149
  86. [CONTENT_TYPE]=application/json
  87. [REQUEST_METHOD]=POST
  88. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  89. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  90. [FCGI_ROLE]=RESPONDER
  91. [PHP_SELF]=/ajaxEntryCenter.php
  92. [REQUEST_TIME_FLOAT]=1657685287.687
  93. [REQUEST_TIME]=1657685287
  94. 12:08:23 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  95. sql语句:select btr.*
  96. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  97. ,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
  98. ,(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
  99. ,(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
  100. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  101. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  102. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  103. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  104. from biz_recruit_delegate brd
  105. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  106. left join base_user bu on bu.id=bt.base_userid
  107. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  108. limit 1) as delegate_info
  109. from biz_trader_recruit btr
  110. left join biz_trader bt on bt.id=btr.biz_traderid
  111. left join base_user bu on bu.id=bt.base_userid
  112. where btr.id=:recruitid
  113. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  114. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  115. 异常堆栈上下文:
  116. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  117. #1 {main}
  118. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  119. sql语句:select btr.*
  120. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  121. ,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
  122. ,(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
  123. ,(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
  124. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  125. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  126. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  127. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  128. from biz_recruit_delegate brd
  129. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  130. left join base_user bu on bu.id=bt.base_userid
  131. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  132. limit 1) as delegate_info
  133. from biz_trader_recruit btr
  134. left join biz_trader bt on bt.id=btr.biz_traderid
  135. left join base_user bu on bu.id=bt.base_userid
  136. where btr.id=:recruitid
  137. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  138. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  139. 异常堆栈上下文:
  140. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  141. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  142. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  143. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  144. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  145. #5 {main}
  146. [上下文相关信息]:
  147. [WsAjaxPrj]=KLY
  148. [WsAjaxBiz]=Trader
  149. [WsAjaxAction]=entityDataHandle
  150. [USER]=nginxphp
  151. [HOME]=/home/nginxphp
  152. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  153. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  154. [HTTP_SEC_FETCH_DEST]=empty
  155. [HTTP_SEC_FETCH_MODE]=cors
  156. [HTTP_SEC_FETCH_SITE]=cross-site
  157. [HTTP_ACCEPT]=*/*
  158. [HTTP_CONTENT_TYPE]=application/json
  159. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  160. [HTTP_CONTENT_LENGTH]=149
  161. [HTTP_CONNECTION]=keep-alive
  162. [HTTP_HOST]=api.kuailaiyou.top
  163. [REDIRECT_STATUS]=200
  164. [SERVER_NAME]=api.kuailaiyou.top
  165. [SERVER_PORT]=443
  166. [SERVER_ADDR]=172.18.217.149
  167. [REMOTE_PORT]=23993
  168. [REMOTE_ADDR]=180.212.68.100
  169. [SERVER_SOFTWARE]=nginx/1.20.1
  170. [GATEWAY_INTERFACE]=CGI/1.1
  171. [HTTPS]=on
  172. [REQUEST_SCHEME]=https
  173. [SERVER_PROTOCOL]=HTTP/1.1
  174. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  175. [DOCUMENT_URI]=/ajaxEntryCenter.php
  176. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  177. [SCRIPT_NAME]=/ajaxEntryCenter.php
  178. [CONTENT_LENGTH]=149
  179. [CONTENT_TYPE]=application/json
  180. [REQUEST_METHOD]=POST
  181. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  182. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  183. [FCGI_ROLE]=RESPONDER
  184. [PHP_SELF]=/ajaxEntryCenter.php
  185. [REQUEST_TIME_FLOAT]=1657685303.7001
  186. [REQUEST_TIME]=1657685303
  187. 12:08:34 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  188. sql语句:select btr.*
  189. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  190. ,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
  191. ,(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
  192. ,(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
  193. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  194. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  195. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  196. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  197. from biz_recruit_delegate brd
  198. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  199. left join base_user bu on bu.id=bt.base_userid
  200. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  201. limit 1) as delegate_info
  202. from biz_trader_recruit btr
  203. left join biz_trader bt on bt.id=btr.biz_traderid
  204. left join base_user bu on bu.id=bt.base_userid
  205. where btr.id=:recruitid
  206. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  207. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  208. 异常堆栈上下文:
  209. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  210. #1 {main}
  211. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  212. sql语句:select btr.*
  213. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  214. ,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
  215. ,(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
  216. ,(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
  217. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  218. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  219. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  220. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  221. from biz_recruit_delegate brd
  222. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  223. left join base_user bu on bu.id=bt.base_userid
  224. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  225. limit 1) as delegate_info
  226. from biz_trader_recruit btr
  227. left join biz_trader bt on bt.id=btr.biz_traderid
  228. left join base_user bu on bu.id=bt.base_userid
  229. where btr.id=:recruitid
  230. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  231. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  232. 异常堆栈上下文:
  233. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  234. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  235. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  236. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  237. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  238. #5 {main}
  239. [上下文相关信息]:
  240. [WsAjaxPrj]=KLY
  241. [WsAjaxBiz]=Trader
  242. [WsAjaxAction]=entityDataHandle
  243. [USER]=nginxphp
  244. [HOME]=/home/nginxphp
  245. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  246. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  247. [HTTP_SEC_FETCH_DEST]=empty
  248. [HTTP_SEC_FETCH_MODE]=cors
  249. [HTTP_SEC_FETCH_SITE]=cross-site
  250. [HTTP_ACCEPT]=*/*
  251. [HTTP_CONTENT_TYPE]=application/json
  252. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  253. [HTTP_CONTENT_LENGTH]=149
  254. [HTTP_CONNECTION]=keep-alive
  255. [HTTP_HOST]=api.kuailaiyou.top
  256. [REDIRECT_STATUS]=200
  257. [SERVER_NAME]=api.kuailaiyou.top
  258. [SERVER_PORT]=443
  259. [SERVER_ADDR]=172.18.217.149
  260. [REMOTE_PORT]=24055
  261. [REMOTE_ADDR]=180.212.68.100
  262. [SERVER_SOFTWARE]=nginx/1.20.1
  263. [GATEWAY_INTERFACE]=CGI/1.1
  264. [HTTPS]=on
  265. [REQUEST_SCHEME]=https
  266. [SERVER_PROTOCOL]=HTTP/1.1
  267. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  268. [DOCUMENT_URI]=/ajaxEntryCenter.php
  269. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  270. [SCRIPT_NAME]=/ajaxEntryCenter.php
  271. [CONTENT_LENGTH]=149
  272. [CONTENT_TYPE]=application/json
  273. [REQUEST_METHOD]=POST
  274. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  275. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  276. [FCGI_ROLE]=RESPONDER
  277. [PHP_SELF]=/ajaxEntryCenter.php
  278. [REQUEST_TIME_FLOAT]=1657685314.1538
  279. [REQUEST_TIME]=1657685314
  280. 12:08:39 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  281. sql语句:select btr.*
  282. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  283. ,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
  284. ,(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
  285. ,(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
  286. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  287. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  288. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  289. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  290. from biz_recruit_delegate brd
  291. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  292. left join base_user bu on bu.id=bt.base_userid
  293. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  294. limit 1) as delegate_info
  295. from biz_trader_recruit btr
  296. left join biz_trader bt on bt.id=btr.biz_traderid
  297. left join base_user bu on bu.id=bt.base_userid
  298. where btr.id=:recruitid
  299. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  300. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  301. 异常堆栈上下文:
  302. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  303. #1 {main}
  304. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  305. sql语句:select btr.*
  306. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  307. ,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
  308. ,(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
  309. ,(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
  310. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  311. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  312. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  313. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  314. from biz_recruit_delegate brd
  315. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  316. left join base_user bu on bu.id=bt.base_userid
  317. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  318. limit 1) as delegate_info
  319. from biz_trader_recruit btr
  320. left join biz_trader bt on bt.id=btr.biz_traderid
  321. left join base_user bu on bu.id=bt.base_userid
  322. where btr.id=:recruitid
  323. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  324. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  325. 异常堆栈上下文:
  326. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  327. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  328. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  329. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  330. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  331. #5 {main}
  332. [上下文相关信息]:
  333. [WsAjaxPrj]=KLY
  334. [WsAjaxBiz]=Trader
  335. [WsAjaxAction]=entityDataHandle
  336. [USER]=nginxphp
  337. [HOME]=/home/nginxphp
  338. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  339. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  340. [HTTP_SEC_FETCH_DEST]=empty
  341. [HTTP_SEC_FETCH_MODE]=cors
  342. [HTTP_SEC_FETCH_SITE]=cross-site
  343. [HTTP_ACCEPT]=*/*
  344. [HTTP_CONTENT_TYPE]=application/json
  345. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  346. [HTTP_CONTENT_LENGTH]=149
  347. [HTTP_CONNECTION]=keep-alive
  348. [HTTP_HOST]=api.kuailaiyou.top
  349. [REDIRECT_STATUS]=200
  350. [SERVER_NAME]=api.kuailaiyou.top
  351. [SERVER_PORT]=443
  352. [SERVER_ADDR]=172.18.217.149
  353. [REMOTE_PORT]=24055
  354. [REMOTE_ADDR]=180.212.68.100
  355. [SERVER_SOFTWARE]=nginx/1.20.1
  356. [GATEWAY_INTERFACE]=CGI/1.1
  357. [HTTPS]=on
  358. [REQUEST_SCHEME]=https
  359. [SERVER_PROTOCOL]=HTTP/1.1
  360. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  361. [DOCUMENT_URI]=/ajaxEntryCenter.php
  362. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  363. [SCRIPT_NAME]=/ajaxEntryCenter.php
  364. [CONTENT_LENGTH]=149
  365. [CONTENT_TYPE]=application/json
  366. [REQUEST_METHOD]=POST
  367. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  368. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  369. [FCGI_ROLE]=RESPONDER
  370. [PHP_SELF]=/ajaxEntryCenter.php
  371. [REQUEST_TIME_FLOAT]=1657685319.9024
  372. [REQUEST_TIME]=1657685319
  373. 12:09:07 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  374. sql语句:select btr.*
  375. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  376. ,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
  377. ,(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
  378. ,(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
  379. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  380. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  381. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  382. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  383. from biz_recruit_delegate brd
  384. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  385. left join base_user bu on bu.id=bt.base_userid
  386. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  387. limit 1) as delegate_info
  388. from biz_trader_recruit btr
  389. left join biz_trader bt on bt.id=btr.biz_traderid
  390. left join base_user bu on bu.id=bt.base_userid
  391. where btr.id=:recruitid
  392. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  393. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  394. 异常堆栈上下文:
  395. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  396. #1 {main}
  397. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  398. sql语句:select btr.*
  399. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  400. ,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
  401. ,(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
  402. ,(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
  403. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  404. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  405. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  406. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  407. from biz_recruit_delegate brd
  408. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  409. left join base_user bu on bu.id=bt.base_userid
  410. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  411. limit 1) as delegate_info
  412. from biz_trader_recruit btr
  413. left join biz_trader bt on bt.id=btr.biz_traderid
  414. left join base_user bu on bu.id=bt.base_userid
  415. where btr.id=:recruitid
  416. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  417. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  418. 异常堆栈上下文:
  419. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  420. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  421. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  422. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  423. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  424. #5 {main}
  425. [上下文相关信息]:
  426. [WsAjaxPrj]=KLY
  427. [WsAjaxBiz]=Trader
  428. [WsAjaxAction]=entityDataHandle
  429. [USER]=nginxphp
  430. [HOME]=/home/nginxphp
  431. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  432. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  433. [HTTP_SEC_FETCH_DEST]=empty
  434. [HTTP_SEC_FETCH_MODE]=cors
  435. [HTTP_SEC_FETCH_SITE]=cross-site
  436. [HTTP_ACCEPT]=*/*
  437. [HTTP_CONTENT_TYPE]=application/json
  438. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  439. [HTTP_CONTENT_LENGTH]=149
  440. [HTTP_CONNECTION]=keep-alive
  441. [HTTP_HOST]=api.kuailaiyou.top
  442. [REDIRECT_STATUS]=200
  443. [SERVER_NAME]=api.kuailaiyou.top
  444. [SERVER_PORT]=443
  445. [SERVER_ADDR]=172.18.217.149
  446. [REMOTE_PORT]=24534
  447. [REMOTE_ADDR]=180.212.68.100
  448. [SERVER_SOFTWARE]=nginx/1.20.1
  449. [GATEWAY_INTERFACE]=CGI/1.1
  450. [HTTPS]=on
  451. [REQUEST_SCHEME]=https
  452. [SERVER_PROTOCOL]=HTTP/1.1
  453. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  454. [DOCUMENT_URI]=/ajaxEntryCenter.php
  455. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  456. [SCRIPT_NAME]=/ajaxEntryCenter.php
  457. [CONTENT_LENGTH]=149
  458. [CONTENT_TYPE]=application/json
  459. [REQUEST_METHOD]=POST
  460. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  461. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  462. [FCGI_ROLE]=RESPONDER
  463. [PHP_SELF]=/ajaxEntryCenter.php
  464. [REQUEST_TIME_FLOAT]=1657685347.5715
  465. [REQUEST_TIME]=1657685347
  466. 12:09:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  467. sql语句:select btr.*
  468. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  469. ,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
  470. ,(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
  471. ,(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
  472. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  473. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  474. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  475. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  476. from biz_recruit_delegate brd
  477. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  478. left join base_user bu on bu.id=bt.base_userid
  479. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  480. limit 1) as delegate_info
  481. from biz_trader_recruit btr
  482. left join biz_trader bt on bt.id=btr.biz_traderid
  483. left join base_user bu on bu.id=bt.base_userid
  484. where btr.id=:recruitid
  485. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  486. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  487. 异常堆栈上下文:
  488. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  489. #1 {main}
  490. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  491. sql语句:select btr.*
  492. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  493. ,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
  494. ,(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
  495. ,(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
  496. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  497. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  498. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  499. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  500. from biz_recruit_delegate brd
  501. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  502. left join base_user bu on bu.id=bt.base_userid
  503. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  504. limit 1) as delegate_info
  505. from biz_trader_recruit btr
  506. left join biz_trader bt on bt.id=btr.biz_traderid
  507. left join base_user bu on bu.id=bt.base_userid
  508. where btr.id=:recruitid
  509. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  510. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  511. 异常堆栈上下文:
  512. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  513. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  514. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  515. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  516. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  517. #5 {main}
  518. [上下文相关信息]:
  519. [WsAjaxPrj]=KLY
  520. [WsAjaxBiz]=Trader
  521. [WsAjaxAction]=entityDataHandle
  522. [USER]=nginxphp
  523. [HOME]=/home/nginxphp
  524. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  525. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  526. [HTTP_SEC_FETCH_DEST]=empty
  527. [HTTP_SEC_FETCH_MODE]=cors
  528. [HTTP_SEC_FETCH_SITE]=cross-site
  529. [HTTP_ACCEPT]=*/*
  530. [HTTP_CONTENT_TYPE]=application/json
  531. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  532. [HTTP_CONTENT_LENGTH]=149
  533. [HTTP_CONNECTION]=keep-alive
  534. [HTTP_HOST]=api.kuailaiyou.top
  535. [REDIRECT_STATUS]=200
  536. [SERVER_NAME]=api.kuailaiyou.top
  537. [SERVER_PORT]=443
  538. [SERVER_ADDR]=172.18.217.149
  539. [REMOTE_PORT]=24846
  540. [REMOTE_ADDR]=180.212.68.100
  541. [SERVER_SOFTWARE]=nginx/1.20.1
  542. [GATEWAY_INTERFACE]=CGI/1.1
  543. [HTTPS]=on
  544. [REQUEST_SCHEME]=https
  545. [SERVER_PROTOCOL]=HTTP/1.1
  546. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  547. [DOCUMENT_URI]=/ajaxEntryCenter.php
  548. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  549. [SCRIPT_NAME]=/ajaxEntryCenter.php
  550. [CONTENT_LENGTH]=149
  551. [CONTENT_TYPE]=application/json
  552. [REQUEST_METHOD]=POST
  553. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  554. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  555. [FCGI_ROLE]=RESPONDER
  556. [PHP_SELF]=/ajaxEntryCenter.php
  557. [REQUEST_TIME_FLOAT]=1657685387.0095
  558. [REQUEST_TIME]=1657685387
  559. 12:11:16 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  560. sql语句:select btr.*
  561. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  562. ,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
  563. ,(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
  564. ,(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
  565. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  566. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  567. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  568. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  569. from biz_recruit_delegate brd
  570. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  571. left join base_user bu on bu.id=bt.base_userid
  572. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  573. limit 1) as delegate_info
  574. from biz_trader_recruit btr
  575. left join biz_trader bt on bt.id=btr.biz_traderid
  576. left join base_user bu on bu.id=bt.base_userid
  577. where btr.id=:recruitid
  578. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  579. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  580. 异常堆栈上下文:
  581. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  582. #1 {main}
  583. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  584. sql语句:select btr.*
  585. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  586. ,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
  587. ,(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
  588. ,(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
  589. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  590. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  591. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  592. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  593. from biz_recruit_delegate brd
  594. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  595. left join base_user bu on bu.id=bt.base_userid
  596. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  597. limit 1) as delegate_info
  598. from biz_trader_recruit btr
  599. left join biz_trader bt on bt.id=btr.biz_traderid
  600. left join base_user bu on bu.id=bt.base_userid
  601. where btr.id=:recruitid
  602. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  603. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  604. 异常堆栈上下文:
  605. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  606. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  607. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  608. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  609. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  610. #5 {main}
  611. [上下文相关信息]:
  612. [WsAjaxPrj]=KLY
  613. [WsAjaxBiz]=Trader
  614. [WsAjaxAction]=entityDataHandle
  615. [USER]=nginxphp
  616. [HOME]=/home/nginxphp
  617. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  618. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  619. [HTTP_SEC_FETCH_DEST]=empty
  620. [HTTP_SEC_FETCH_MODE]=cors
  621. [HTTP_SEC_FETCH_SITE]=cross-site
  622. [HTTP_ACCEPT]=*/*
  623. [HTTP_CONTENT_TYPE]=application/json
  624. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  625. [HTTP_CONTENT_LENGTH]=149
  626. [HTTP_CONNECTION]=keep-alive
  627. [HTTP_HOST]=api.kuailaiyou.top
  628. [REDIRECT_STATUS]=200
  629. [SERVER_NAME]=api.kuailaiyou.top
  630. [SERVER_PORT]=443
  631. [SERVER_ADDR]=172.18.217.149
  632. [REMOTE_PORT]=21862
  633. [REMOTE_ADDR]=180.212.68.100
  634. [SERVER_SOFTWARE]=nginx/1.20.1
  635. [GATEWAY_INTERFACE]=CGI/1.1
  636. [HTTPS]=on
  637. [REQUEST_SCHEME]=https
  638. [SERVER_PROTOCOL]=HTTP/1.1
  639. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  640. [DOCUMENT_URI]=/ajaxEntryCenter.php
  641. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  642. [SCRIPT_NAME]=/ajaxEntryCenter.php
  643. [CONTENT_LENGTH]=149
  644. [CONTENT_TYPE]=application/json
  645. [REQUEST_METHOD]=POST
  646. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  647. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  648. [FCGI_ROLE]=RESPONDER
  649. [PHP_SELF]=/ajaxEntryCenter.php
  650. [REQUEST_TIME_FLOAT]=1657685476.6183
  651. [REQUEST_TIME]=1657685476
  652. 12:11:34 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  653. sql语句:select btr.*
  654. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  655. ,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
  656. ,(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
  657. ,(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
  658. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  659. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  660. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  661. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  662. from biz_recruit_delegate brd
  663. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  664. left join base_user bu on bu.id=bt.base_userid
  665. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  666. limit 1) as delegate_info
  667. from biz_trader_recruit btr
  668. left join biz_trader bt on bt.id=btr.biz_traderid
  669. left join base_user bu on bu.id=bt.base_userid
  670. where btr.id=:recruitid
  671. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  672. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  673. 异常堆栈上下文:
  674. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  675. #1 {main}
  676. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  677. sql语句:select btr.*
  678. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  679. ,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
  680. ,(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
  681. ,(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
  682. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  683. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  684. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  685. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  686. from biz_recruit_delegate brd
  687. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  688. left join base_user bu on bu.id=bt.base_userid
  689. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  690. limit 1) as delegate_info
  691. from biz_trader_recruit btr
  692. left join biz_trader bt on bt.id=btr.biz_traderid
  693. left join base_user bu on bu.id=bt.base_userid
  694. where btr.id=:recruitid
  695. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  696. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  697. 异常堆栈上下文:
  698. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  699. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  700. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  701. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  702. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  703. #5 {main}
  704. [上下文相关信息]:
  705. [WsAjaxPrj]=KLY
  706. [WsAjaxBiz]=Trader
  707. [WsAjaxAction]=entityDataHandle
  708. [USER]=nginxphp
  709. [HOME]=/home/nginxphp
  710. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  711. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  712. [HTTP_SEC_FETCH_DEST]=empty
  713. [HTTP_SEC_FETCH_MODE]=cors
  714. [HTTP_SEC_FETCH_SITE]=cross-site
  715. [HTTP_ACCEPT]=*/*
  716. [HTTP_CONTENT_TYPE]=application/json
  717. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  718. [HTTP_CONTENT_LENGTH]=149
  719. [HTTP_CONNECTION]=keep-alive
  720. [HTTP_HOST]=api.kuailaiyou.top
  721. [REDIRECT_STATUS]=200
  722. [SERVER_NAME]=api.kuailaiyou.top
  723. [SERVER_PORT]=443
  724. [SERVER_ADDR]=172.18.217.149
  725. [REMOTE_PORT]=22045
  726. [REMOTE_ADDR]=180.212.68.100
  727. [SERVER_SOFTWARE]=nginx/1.20.1
  728. [GATEWAY_INTERFACE]=CGI/1.1
  729. [HTTPS]=on
  730. [REQUEST_SCHEME]=https
  731. [SERVER_PROTOCOL]=HTTP/1.1
  732. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  733. [DOCUMENT_URI]=/ajaxEntryCenter.php
  734. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  735. [SCRIPT_NAME]=/ajaxEntryCenter.php
  736. [CONTENT_LENGTH]=149
  737. [CONTENT_TYPE]=application/json
  738. [REQUEST_METHOD]=POST
  739. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  740. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  741. [FCGI_ROLE]=RESPONDER
  742. [PHP_SELF]=/ajaxEntryCenter.php
  743. [REQUEST_TIME_FLOAT]=1657685494.8798
  744. [REQUEST_TIME]=1657685494
  745. 12:12:13 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  746. sql语句:select btr.*
  747. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  748. ,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
  749. ,(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
  750. ,(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
  751. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  752. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  753. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  754. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  755. from biz_recruit_delegate brd
  756. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  757. left join base_user bu on bu.id=bt.base_userid
  758. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  759. limit 1) as delegate_info
  760. from biz_trader_recruit btr
  761. left join biz_trader bt on bt.id=btr.biz_traderid
  762. left join base_user bu on bu.id=bt.base_userid
  763. where btr.id=:recruitid
  764. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  765. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  766. 异常堆栈上下文:
  767. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  768. #1 {main}
  769. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  770. sql语句:select btr.*
  771. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  772. ,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
  773. ,(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
  774. ,(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
  775. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  776. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  777. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  778. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  779. from biz_recruit_delegate brd
  780. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  781. left join base_user bu on bu.id=bt.base_userid
  782. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  783. limit 1) as delegate_info
  784. from biz_trader_recruit btr
  785. left join biz_trader bt on bt.id=btr.biz_traderid
  786. left join base_user bu on bu.id=bt.base_userid
  787. where btr.id=:recruitid
  788. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  789. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  790. 异常堆栈上下文:
  791. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  792. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  793. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  794. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  795. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  796. #5 {main}
  797. [上下文相关信息]:
  798. [WsAjaxPrj]=KLY
  799. [WsAjaxBiz]=Trader
  800. [WsAjaxAction]=entityDataHandle
  801. [USER]=nginxphp
  802. [HOME]=/home/nginxphp
  803. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  804. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  805. [HTTP_SEC_FETCH_DEST]=empty
  806. [HTTP_SEC_FETCH_MODE]=cors
  807. [HTTP_SEC_FETCH_SITE]=cross-site
  808. [HTTP_ACCEPT]=*/*
  809. [HTTP_CONTENT_TYPE]=application/json
  810. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  811. [HTTP_CONTENT_LENGTH]=149
  812. [HTTP_CONNECTION]=keep-alive
  813. [HTTP_HOST]=api.kuailaiyou.top
  814. [REDIRECT_STATUS]=200
  815. [SERVER_NAME]=api.kuailaiyou.top
  816. [SERVER_PORT]=443
  817. [SERVER_ADDR]=172.18.217.149
  818. [REMOTE_PORT]=22277
  819. [REMOTE_ADDR]=180.212.68.100
  820. [SERVER_SOFTWARE]=nginx/1.20.1
  821. [GATEWAY_INTERFACE]=CGI/1.1
  822. [HTTPS]=on
  823. [REQUEST_SCHEME]=https
  824. [SERVER_PROTOCOL]=HTTP/1.1
  825. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  826. [DOCUMENT_URI]=/ajaxEntryCenter.php
  827. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  828. [SCRIPT_NAME]=/ajaxEntryCenter.php
  829. [CONTENT_LENGTH]=149
  830. [CONTENT_TYPE]=application/json
  831. [REQUEST_METHOD]=POST
  832. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  833. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  834. [FCGI_ROLE]=RESPONDER
  835. [PHP_SELF]=/ajaxEntryCenter.php
  836. [REQUEST_TIME_FLOAT]=1657685533.4355
  837. [REQUEST_TIME]=1657685533
  838. 12:13:02 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  839. sql语句:select btr.*
  840. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  841. ,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
  842. ,(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
  843. ,(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
  844. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  845. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  846. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  847. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  848. from biz_recruit_delegate brd
  849. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  850. left join base_user bu on bu.id=bt.base_userid
  851. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  852. limit 1) as delegate_info
  853. from biz_trader_recruit btr
  854. left join biz_trader bt on bt.id=btr.biz_traderid
  855. left join base_user bu on bu.id=bt.base_userid
  856. where btr.id=:recruitid
  857. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  858. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  859. 异常堆栈上下文:
  860. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  861. #1 {main}
  862. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  863. sql语句:select btr.*
  864. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  865. ,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
  866. ,(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
  867. ,(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
  868. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  869. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  870. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  871. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  872. from biz_recruit_delegate brd
  873. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  874. left join base_user bu on bu.id=bt.base_userid
  875. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  876. limit 1) as delegate_info
  877. from biz_trader_recruit btr
  878. left join biz_trader bt on bt.id=btr.biz_traderid
  879. left join base_user bu on bu.id=bt.base_userid
  880. where btr.id=:recruitid
  881. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  882. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  883. 异常堆栈上下文:
  884. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  885. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  886. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  887. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  888. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  889. #5 {main}
  890. [上下文相关信息]:
  891. [WsAjaxPrj]=KLY
  892. [WsAjaxBiz]=Trader
  893. [WsAjaxAction]=entityDataHandle
  894. [USER]=nginxphp
  895. [HOME]=/home/nginxphp
  896. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  897. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  898. [HTTP_SEC_FETCH_DEST]=empty
  899. [HTTP_SEC_FETCH_MODE]=cors
  900. [HTTP_SEC_FETCH_SITE]=cross-site
  901. [HTTP_ACCEPT]=*/*
  902. [HTTP_CONTENT_TYPE]=application/json
  903. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  904. [HTTP_CONTENT_LENGTH]=149
  905. [HTTP_CONNECTION]=keep-alive
  906. [HTTP_HOST]=api.kuailaiyou.top
  907. [REDIRECT_STATUS]=200
  908. [SERVER_NAME]=api.kuailaiyou.top
  909. [SERVER_PORT]=443
  910. [SERVER_ADDR]=172.18.217.149
  911. [REMOTE_PORT]=22681
  912. [REMOTE_ADDR]=180.212.68.100
  913. [SERVER_SOFTWARE]=nginx/1.20.1
  914. [GATEWAY_INTERFACE]=CGI/1.1
  915. [HTTPS]=on
  916. [REQUEST_SCHEME]=https
  917. [SERVER_PROTOCOL]=HTTP/1.1
  918. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  919. [DOCUMENT_URI]=/ajaxEntryCenter.php
  920. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  921. [SCRIPT_NAME]=/ajaxEntryCenter.php
  922. [CONTENT_LENGTH]=149
  923. [CONTENT_TYPE]=application/json
  924. [REQUEST_METHOD]=POST
  925. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  926. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  927. [FCGI_ROLE]=RESPONDER
  928. [PHP_SELF]=/ajaxEntryCenter.php
  929. [REQUEST_TIME_FLOAT]=1657685582.968
  930. [REQUEST_TIME]=1657685582
  931. 12:13:24 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  932. sql语句:select btr.*
  933. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  934. ,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
  935. ,(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
  936. ,(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
  937. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  938. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  939. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  940. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  941. from biz_recruit_delegate brd
  942. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  943. left join base_user bu on bu.id=bt.base_userid
  944. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  945. limit 1) as delegate_info
  946. from biz_trader_recruit btr
  947. left join biz_trader bt on bt.id=btr.biz_traderid
  948. left join base_user bu on bu.id=bt.base_userid
  949. where btr.id=:recruitid
  950. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  951. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  952. 异常堆栈上下文:
  953. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  954. #1 {main}
  955. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  956. sql语句:select btr.*
  957. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  958. ,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
  959. ,(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
  960. ,(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
  961. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  962. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  963. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  964. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  965. from biz_recruit_delegate brd
  966. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  967. left join base_user bu on bu.id=bt.base_userid
  968. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  969. limit 1) as delegate_info
  970. from biz_trader_recruit btr
  971. left join biz_trader bt on bt.id=btr.biz_traderid
  972. left join base_user bu on bu.id=bt.base_userid
  973. where btr.id=:recruitid
  974. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  975. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  976. 异常堆栈上下文:
  977. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  978. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  979. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  980. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  981. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  982. #5 {main}
  983. [上下文相关信息]:
  984. [WsAjaxPrj]=KLY
  985. [WsAjaxBiz]=Trader
  986. [WsAjaxAction]=entityDataHandle
  987. [USER]=nginxphp
  988. [HOME]=/home/nginxphp
  989. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  990. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  991. [HTTP_SEC_FETCH_DEST]=empty
  992. [HTTP_SEC_FETCH_MODE]=cors
  993. [HTTP_SEC_FETCH_SITE]=cross-site
  994. [HTTP_ACCEPT]=*/*
  995. [HTTP_CONTENT_TYPE]=application/json
  996. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  997. [HTTP_CONTENT_LENGTH]=149
  998. [HTTP_CONNECTION]=keep-alive
  999. [HTTP_HOST]=api.kuailaiyou.top
  1000. [REDIRECT_STATUS]=200
  1001. [SERVER_NAME]=api.kuailaiyou.top
  1002. [SERVER_PORT]=443
  1003. [SERVER_ADDR]=172.18.217.149
  1004. [REMOTE_PORT]=22975
  1005. [REMOTE_ADDR]=180.212.68.100
  1006. [SERVER_SOFTWARE]=nginx/1.20.1
  1007. [GATEWAY_INTERFACE]=CGI/1.1
  1008. [HTTPS]=on
  1009. [REQUEST_SCHEME]=https
  1010. [SERVER_PROTOCOL]=HTTP/1.1
  1011. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  1012. [DOCUMENT_URI]=/ajaxEntryCenter.php
  1013. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1014. [SCRIPT_NAME]=/ajaxEntryCenter.php
  1015. [CONTENT_LENGTH]=149
  1016. [CONTENT_TYPE]=application/json
  1017. [REQUEST_METHOD]=POST
  1018. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1019. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  1020. [FCGI_ROLE]=RESPONDER
  1021. [PHP_SELF]=/ajaxEntryCenter.php
  1022. [REQUEST_TIME_FLOAT]=1657685604.6141
  1023. [REQUEST_TIME]=1657685604
  1024. 12:13:34 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1025. sql语句:select btr.*
  1026. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1027. ,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
  1028. ,(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
  1029. ,(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
  1030. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1031. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1032. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1033. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1034. from biz_recruit_delegate brd
  1035. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1036. left join base_user bu on bu.id=bt.base_userid
  1037. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1038. limit 1) as delegate_info
  1039. from biz_trader_recruit btr
  1040. left join biz_trader bt on bt.id=btr.biz_traderid
  1041. left join base_user bu on bu.id=bt.base_userid
  1042. where btr.id=:recruitid
  1043. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1044. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  1045. 异常堆栈上下文:
  1046. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  1047. #1 {main}
  1048. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1049. sql语句:select btr.*
  1050. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1051. ,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
  1052. ,(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
  1053. ,(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
  1054. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1055. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1056. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1057. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1058. from biz_recruit_delegate brd
  1059. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1060. left join base_user bu on bu.id=bt.base_userid
  1061. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1062. limit 1) as delegate_info
  1063. from biz_trader_recruit btr
  1064. left join biz_trader bt on bt.id=btr.biz_traderid
  1065. left join base_user bu on bu.id=bt.base_userid
  1066. where btr.id=:recruitid
  1067. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1068. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  1069. 异常堆栈上下文:
  1070. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  1071. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  1072. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  1073. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  1074. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  1075. #5 {main}
  1076. [上下文相关信息]:
  1077. [WsAjaxPrj]=KLY
  1078. [WsAjaxBiz]=Trader
  1079. [WsAjaxAction]=entityDataHandle
  1080. [USER]=nginxphp
  1081. [HOME]=/home/nginxphp
  1082. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  1083. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  1084. [HTTP_SEC_FETCH_DEST]=empty
  1085. [HTTP_SEC_FETCH_MODE]=cors
  1086. [HTTP_SEC_FETCH_SITE]=cross-site
  1087. [HTTP_ACCEPT]=*/*
  1088. [HTTP_CONTENT_TYPE]=application/json
  1089. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  1090. [HTTP_CONTENT_LENGTH]=149
  1091. [HTTP_CONNECTION]=keep-alive
  1092. [HTTP_HOST]=api.kuailaiyou.top
  1093. [REDIRECT_STATUS]=200
  1094. [SERVER_NAME]=api.kuailaiyou.top
  1095. [SERVER_PORT]=443
  1096. [SERVER_ADDR]=172.18.217.149
  1097. [REMOTE_PORT]=23044
  1098. [REMOTE_ADDR]=180.212.68.100
  1099. [SERVER_SOFTWARE]=nginx/1.20.1
  1100. [GATEWAY_INTERFACE]=CGI/1.1
  1101. [HTTPS]=on
  1102. [REQUEST_SCHEME]=https
  1103. [SERVER_PROTOCOL]=HTTP/1.1
  1104. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  1105. [DOCUMENT_URI]=/ajaxEntryCenter.php
  1106. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1107. [SCRIPT_NAME]=/ajaxEntryCenter.php
  1108. [CONTENT_LENGTH]=149
  1109. [CONTENT_TYPE]=application/json
  1110. [REQUEST_METHOD]=POST
  1111. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1112. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  1113. [FCGI_ROLE]=RESPONDER
  1114. [PHP_SELF]=/ajaxEntryCenter.php
  1115. [REQUEST_TIME_FLOAT]=1657685614.3712
  1116. [REQUEST_TIME]=1657685614
  1117. 12:15:08 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1118. sql语句:select btr.*
  1119. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1120. ,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
  1121. ,(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
  1122. ,(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
  1123. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1124. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1125. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1126. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1127. from biz_recruit_delegate brd
  1128. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1129. left join base_user bu on bu.id=bt.base_userid
  1130. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1131. limit 1) as delegate_info
  1132. from biz_trader_recruit btr
  1133. left join biz_trader bt on bt.id=btr.biz_traderid
  1134. left join base_user bu on bu.id=bt.base_userid
  1135. where btr.id=:recruitid
  1136. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1137. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  1138. 异常堆栈上下文:
  1139. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  1140. #1 {main}
  1141. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1142. sql语句:select btr.*
  1143. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1144. ,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
  1145. ,(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
  1146. ,(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
  1147. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1148. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1149. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1150. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1151. from biz_recruit_delegate brd
  1152. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1153. left join base_user bu on bu.id=bt.base_userid
  1154. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1155. limit 1) as delegate_info
  1156. from biz_trader_recruit btr
  1157. left join biz_trader bt on bt.id=btr.biz_traderid
  1158. left join base_user bu on bu.id=bt.base_userid
  1159. where btr.id=:recruitid
  1160. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1161. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  1162. 异常堆栈上下文:
  1163. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  1164. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  1165. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  1166. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  1167. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  1168. #5 {main}
  1169. [上下文相关信息]:
  1170. [WsAjaxPrj]=KLY
  1171. [WsAjaxBiz]=Trader
  1172. [WsAjaxAction]=entityDataHandle
  1173. [USER]=nginxphp
  1174. [HOME]=/home/nginxphp
  1175. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  1176. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  1177. [HTTP_SEC_FETCH_DEST]=empty
  1178. [HTTP_SEC_FETCH_MODE]=cors
  1179. [HTTP_SEC_FETCH_SITE]=cross-site
  1180. [HTTP_ACCEPT]=*/*
  1181. [HTTP_CONTENT_TYPE]=application/json
  1182. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  1183. [HTTP_CONTENT_LENGTH]=149
  1184. [HTTP_CONNECTION]=keep-alive
  1185. [HTTP_HOST]=api.kuailaiyou.top
  1186. [REDIRECT_STATUS]=200
  1187. [SERVER_NAME]=api.kuailaiyou.top
  1188. [SERVER_PORT]=443
  1189. [SERVER_ADDR]=172.18.217.149
  1190. [REMOTE_PORT]=23539
  1191. [REMOTE_ADDR]=180.212.68.100
  1192. [SERVER_SOFTWARE]=nginx/1.20.1
  1193. [GATEWAY_INTERFACE]=CGI/1.1
  1194. [HTTPS]=on
  1195. [REQUEST_SCHEME]=https
  1196. [SERVER_PROTOCOL]=HTTP/1.1
  1197. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  1198. [DOCUMENT_URI]=/ajaxEntryCenter.php
  1199. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1200. [SCRIPT_NAME]=/ajaxEntryCenter.php
  1201. [CONTENT_LENGTH]=149
  1202. [CONTENT_TYPE]=application/json
  1203. [REQUEST_METHOD]=POST
  1204. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1205. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  1206. [FCGI_ROLE]=RESPONDER
  1207. [PHP_SELF]=/ajaxEntryCenter.php
  1208. [REQUEST_TIME_FLOAT]=1657685708.4097
  1209. [REQUEST_TIME]=1657685708
  1210. 12:16:20 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1211. sql语句:select btr.*
  1212. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1213. ,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
  1214. ,(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
  1215. ,(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
  1216. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1217. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1218. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1219. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1220. from biz_recruit_delegate brd
  1221. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1222. left join base_user bu on bu.id=bt.base_userid
  1223. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1224. limit 1) as delegate_info
  1225. from biz_trader_recruit btr
  1226. left join biz_trader bt on bt.id=btr.biz_traderid
  1227. left join base_user bu on bu.id=bt.base_userid
  1228. where btr.id=:recruitid
  1229. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1230. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  1231. 异常堆栈上下文:
  1232. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  1233. #1 {main}
  1234. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1235. sql语句:select btr.*
  1236. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1237. ,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
  1238. ,(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
  1239. ,(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
  1240. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1241. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1242. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1243. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1244. from biz_recruit_delegate brd
  1245. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1246. left join base_user bu on bu.id=bt.base_userid
  1247. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1248. limit 1) as delegate_info
  1249. from biz_trader_recruit btr
  1250. left join biz_trader bt on bt.id=btr.biz_traderid
  1251. left join base_user bu on bu.id=bt.base_userid
  1252. where btr.id=:recruitid
  1253. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1254. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  1255. 异常堆栈上下文:
  1256. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  1257. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  1258. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  1259. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  1260. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  1261. #5 {main}
  1262. [上下文相关信息]:
  1263. [WsAjaxPrj]=KLY
  1264. [WsAjaxBiz]=Trader
  1265. [WsAjaxAction]=entityDataHandle
  1266. [USER]=nginxphp
  1267. [HOME]=/home/nginxphp
  1268. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  1269. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  1270. [HTTP_SEC_FETCH_DEST]=empty
  1271. [HTTP_SEC_FETCH_MODE]=cors
  1272. [HTTP_SEC_FETCH_SITE]=cross-site
  1273. [HTTP_ACCEPT]=*/*
  1274. [HTTP_CONTENT_TYPE]=application/json
  1275. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  1276. [HTTP_CONTENT_LENGTH]=149
  1277. [HTTP_CONNECTION]=keep-alive
  1278. [HTTP_HOST]=api.kuailaiyou.top
  1279. [REDIRECT_STATUS]=200
  1280. [SERVER_NAME]=api.kuailaiyou.top
  1281. [SERVER_PORT]=443
  1282. [SERVER_ADDR]=172.18.217.149
  1283. [REMOTE_PORT]=24032
  1284. [REMOTE_ADDR]=180.212.68.100
  1285. [SERVER_SOFTWARE]=nginx/1.20.1
  1286. [GATEWAY_INTERFACE]=CGI/1.1
  1287. [HTTPS]=on
  1288. [REQUEST_SCHEME]=https
  1289. [SERVER_PROTOCOL]=HTTP/1.1
  1290. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  1291. [DOCUMENT_URI]=/ajaxEntryCenter.php
  1292. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1293. [SCRIPT_NAME]=/ajaxEntryCenter.php
  1294. [CONTENT_LENGTH]=149
  1295. [CONTENT_TYPE]=application/json
  1296. [REQUEST_METHOD]=POST
  1297. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1298. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  1299. [FCGI_ROLE]=RESPONDER
  1300. [PHP_SELF]=/ajaxEntryCenter.php
  1301. [REQUEST_TIME_FLOAT]=1657685780.0706
  1302. [REQUEST_TIME]=1657685780
  1303. 12:17:21 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1304. sql语句:select btr.*
  1305. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1306. ,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
  1307. ,(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
  1308. ,(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
  1309. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1310. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1311. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1312. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1313. from biz_recruit_delegate brd
  1314. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1315. left join base_user bu on bu.id=bt.base_userid
  1316. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1317. limit 1) as delegate_info
  1318. from biz_trader_recruit btr
  1319. left join biz_trader bt on bt.id=btr.biz_traderid
  1320. left join base_user bu on bu.id=bt.base_userid
  1321. where btr.id=:recruitid
  1322. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1323. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  1324. 异常堆栈上下文:
  1325. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  1326. #1 {main}
  1327. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1328. sql语句:select btr.*
  1329. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1330. ,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
  1331. ,(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
  1332. ,(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
  1333. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1334. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1335. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1336. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1337. from biz_recruit_delegate brd
  1338. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1339. left join base_user bu on bu.id=bt.base_userid
  1340. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1341. limit 1) as delegate_info
  1342. from biz_trader_recruit btr
  1343. left join biz_trader bt on bt.id=btr.biz_traderid
  1344. left join base_user bu on bu.id=bt.base_userid
  1345. where btr.id=:recruitid
  1346. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1347. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  1348. 异常堆栈上下文:
  1349. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  1350. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  1351. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  1352. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  1353. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  1354. #5 {main}
  1355. [上下文相关信息]:
  1356. [WsAjaxPrj]=KLY
  1357. [WsAjaxBiz]=Trader
  1358. [WsAjaxAction]=entityDataHandle
  1359. [USER]=nginxphp
  1360. [HOME]=/home/nginxphp
  1361. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  1362. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  1363. [HTTP_SEC_FETCH_DEST]=empty
  1364. [HTTP_SEC_FETCH_MODE]=cors
  1365. [HTTP_SEC_FETCH_SITE]=cross-site
  1366. [HTTP_ACCEPT]=*/*
  1367. [HTTP_CONTENT_TYPE]=application/json
  1368. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  1369. [HTTP_CONTENT_LENGTH]=149
  1370. [HTTP_CONNECTION]=keep-alive
  1371. [HTTP_HOST]=api.kuailaiyou.top
  1372. [REDIRECT_STATUS]=200
  1373. [SERVER_NAME]=api.kuailaiyou.top
  1374. [SERVER_PORT]=443
  1375. [SERVER_ADDR]=172.18.217.149
  1376. [REMOTE_PORT]=24481
  1377. [REMOTE_ADDR]=180.212.68.100
  1378. [SERVER_SOFTWARE]=nginx/1.20.1
  1379. [GATEWAY_INTERFACE]=CGI/1.1
  1380. [HTTPS]=on
  1381. [REQUEST_SCHEME]=https
  1382. [SERVER_PROTOCOL]=HTTP/1.1
  1383. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  1384. [DOCUMENT_URI]=/ajaxEntryCenter.php
  1385. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1386. [SCRIPT_NAME]=/ajaxEntryCenter.php
  1387. [CONTENT_LENGTH]=149
  1388. [CONTENT_TYPE]=application/json
  1389. [REQUEST_METHOD]=POST
  1390. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1391. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  1392. [FCGI_ROLE]=RESPONDER
  1393. [PHP_SELF]=/ajaxEntryCenter.php
  1394. [REQUEST_TIME_FLOAT]=1657685841.5813
  1395. [REQUEST_TIME]=1657685841
  1396. 12:17:45 [error]: 通用的实体数据存取接口异常:数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1397. sql语句:select btr.*
  1398. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1399. ,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
  1400. ,(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
  1401. ,(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
  1402. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1403. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1404. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1405. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1406. from biz_recruit_delegate brd
  1407. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1408. left join base_user bu on bu.id=bt.base_userid
  1409. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1410. limit 1) as delegate_info
  1411. from biz_trader_recruit btr
  1412. left join biz_trader bt on bt.id=btr.biz_traderid
  1413. left join base_user bu on bu.id=bt.base_userid
  1414. where btr.id=:recruitid
  1415. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1416. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  1417. 异常堆栈上下文:
  1418. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  1419. #1 {main}
  1420. 数据库执行异常:Unknown column 'bt.linker_phone' in 'field list'
  1421. sql语句:select btr.*
  1422. ,bt.company_name bt_companyname,bu.mobile as bt_mobile,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed
  1423. ,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
  1424. ,(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
  1425. ,(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
  1426. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total
  1427. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000
  1428. ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total
  1429. ,(select concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt.id,'-',bu.id,'-',bu.mobile,'-',bt.true_name)
  1430. from biz_recruit_delegate brd
  1431. left join biz_trader2 bt on bt.id=brd.biz_trader2id
  1432. left join base_user bu on bu.id=bt.base_userid
  1433. where brd.biz_recruitid=:recruitid and brd.finish_datetime>:verify_datetime
  1434. limit 1) as delegate_info
  1435. from biz_trader_recruit btr
  1436. left join biz_trader bt on bt.id=btr.biz_traderid
  1437. left join base_user bu on bu.id=bt.base_userid
  1438. where btr.id=:recruitid
  1439. ["42S22",1054,"Unknown column 'bt.linker_phone' in 'field list'"]
  1440. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  1441. 异常堆栈上下文:
  1442. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  1443. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  1444. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(40): pdo_fetch()
  1445. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  1446. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  1447. #5 {main}
  1448. [上下文相关信息]:
  1449. [WsAjaxPrj]=KLY
  1450. [WsAjaxBiz]=Trader
  1451. [WsAjaxAction]=entityDataHandle
  1452. [USER]=nginxphp
  1453. [HOME]=/home/nginxphp
  1454. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  1455. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  1456. [HTTP_SEC_FETCH_DEST]=empty
  1457. [HTTP_SEC_FETCH_MODE]=cors
  1458. [HTTP_SEC_FETCH_SITE]=cross-site
  1459. [HTTP_ACCEPT]=*/*
  1460. [HTTP_CONTENT_TYPE]=application/json
  1461. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.05.2108130 MicroMessenger/8.0.5 Language/zh_CN webview/
  1462. [HTTP_CONTENT_LENGTH]=149
  1463. [HTTP_CONNECTION]=keep-alive
  1464. [HTTP_HOST]=api.kuailaiyou.top
  1465. [REDIRECT_STATUS]=200
  1466. [SERVER_NAME]=api.kuailaiyou.top
  1467. [SERVER_PORT]=443
  1468. [SERVER_ADDR]=172.18.217.149
  1469. [REMOTE_PORT]=24598
  1470. [REMOTE_ADDR]=180.212.68.100
  1471. [SERVER_SOFTWARE]=nginx/1.20.1
  1472. [GATEWAY_INTERFACE]=CGI/1.1
  1473. [HTTPS]=on
  1474. [REQUEST_SCHEME]=https
  1475. [SERVER_PROTOCOL]=HTTP/1.1
  1476. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  1477. [DOCUMENT_URI]=/ajaxEntryCenter.php
  1478. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1479. [SCRIPT_NAME]=/ajaxEntryCenter.php
  1480. [CONTENT_LENGTH]=149
  1481. [CONTENT_TYPE]=application/json
  1482. [REQUEST_METHOD]=POST
  1483. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  1484. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  1485. [FCGI_ROLE]=RESPONDER
  1486. [PHP_SELF]=/ajaxEntryCenter.php
  1487. [REQUEST_TIME_FLOAT]=1657685865.3714
  1488. [REQUEST_TIME]=1657685865