2022062912_entityDataHandle.log 53 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511
  1. 12:15:31 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  2. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  3. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  4. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  5. ,salary=:salary,feeper=:auto_feeper
  6. where id=@bizid; update biz_trader set updatetime=1656476131 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  7. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476131 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  8. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  9. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  10. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  11. 异常堆栈上下文:
  12. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  13. #1 {main}
  14. 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  15. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  16. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  17. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  18. ,salary=:salary,feeper=:auto_feeper
  19. where id=@bizid; update biz_trader set updatetime=1656476131 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  20. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476131 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  21. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  22. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  23. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  24. 异常堆栈上下文:
  25. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  26. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  27. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  28. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(530): pdo_query3()
  29. #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  30. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
  31. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader()
  32. #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  33. #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  34. #9 {main}
  35. [上下文相关信息]:
  36. [WsAjaxPrj]=KLY
  37. [WsAjaxBiz]=Trader
  38. [WsAjaxAction]=entityDataHandle
  39. [USER]=nginxphp
  40. [HOME]=/home/nginxphp
  41. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html
  42. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  43. [HTTP_CONTENT_TYPE]=application/json
  44. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android
  45. [HTTP_CHARSET]=utf-8
  46. [HTTP_CONTENT_LENGTH]=926
  47. [HTTP_CONNECTION]=keep-alive
  48. [HTTP_HOST]=api.kuailaiyou.top
  49. [REDIRECT_STATUS]=200
  50. [SERVER_NAME]=api.kuailaiyou.top
  51. [SERVER_PORT]=443
  52. [SERVER_ADDR]=172.18.217.149
  53. [REMOTE_PORT]=13356
  54. [REMOTE_ADDR]=218.69.51.169
  55. [SERVER_SOFTWARE]=nginx/1.20.1
  56. [GATEWAY_INTERFACE]=CGI/1.1
  57. [HTTPS]=on
  58. [REQUEST_SCHEME]=https
  59. [SERVER_PROTOCOL]=HTTP/1.1
  60. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  61. [DOCUMENT_URI]=/ajaxEntryCenter.php
  62. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  63. [SCRIPT_NAME]=/ajaxEntryCenter.php
  64. [CONTENT_LENGTH]=926
  65. [CONTENT_TYPE]=application/json
  66. [REQUEST_METHOD]=POST
  67. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  68. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  69. [FCGI_ROLE]=RESPONDER
  70. [PHP_SELF]=/ajaxEntryCenter.php
  71. [REQUEST_TIME_FLOAT]=1656476131.2855
  72. [REQUEST_TIME]=1656476131
  73. 12:15:43 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  74. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  75. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  76. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  77. ,salary=:salary,feeper=:auto_feeper
  78. where id=@bizid; update biz_trader set updatetime=1656476143 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  79. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476143 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  80. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  81. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  82. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  83. 异常堆栈上下文:
  84. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  85. #1 {main}
  86. 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  87. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  88. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  89. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  90. ,salary=:salary,feeper=:auto_feeper
  91. where id=@bizid; update biz_trader set updatetime=1656476143 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  92. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476143 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  93. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  94. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  95. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  96. 异常堆栈上下文:
  97. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  98. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  99. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  100. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(530): pdo_query3()
  101. #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  102. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
  103. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader()
  104. #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  105. #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  106. #9 {main}
  107. [上下文相关信息]:
  108. [WsAjaxPrj]=KLY
  109. [WsAjaxBiz]=Trader
  110. [WsAjaxAction]=entityDataHandle
  111. [USER]=nginxphp
  112. [HOME]=/home/nginxphp
  113. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html
  114. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  115. [HTTP_CONTENT_TYPE]=application/json
  116. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android
  117. [HTTP_CHARSET]=utf-8
  118. [HTTP_CONTENT_LENGTH]=926
  119. [HTTP_CONNECTION]=keep-alive
  120. [HTTP_HOST]=api.kuailaiyou.top
  121. [REDIRECT_STATUS]=200
  122. [SERVER_NAME]=api.kuailaiyou.top
  123. [SERVER_PORT]=443
  124. [SERVER_ADDR]=172.18.217.149
  125. [REMOTE_PORT]=13356
  126. [REMOTE_ADDR]=218.69.51.169
  127. [SERVER_SOFTWARE]=nginx/1.20.1
  128. [GATEWAY_INTERFACE]=CGI/1.1
  129. [HTTPS]=on
  130. [REQUEST_SCHEME]=https
  131. [SERVER_PROTOCOL]=HTTP/1.1
  132. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  133. [DOCUMENT_URI]=/ajaxEntryCenter.php
  134. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  135. [SCRIPT_NAME]=/ajaxEntryCenter.php
  136. [CONTENT_LENGTH]=926
  137. [CONTENT_TYPE]=application/json
  138. [REQUEST_METHOD]=POST
  139. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  140. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  141. [FCGI_ROLE]=RESPONDER
  142. [PHP_SELF]=/ajaxEntryCenter.php
  143. [REQUEST_TIME_FLOAT]=1656476143.4944
  144. [REQUEST_TIME]=1656476143
  145. 12:15:51 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  146. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  147. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  148. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  149. ,salary=:salary,feeper=:auto_feeper
  150. where id=@bizid; update biz_trader set updatetime=1656476151 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  151. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476151 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  152. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  153. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  154. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  155. 异常堆栈上下文:
  156. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  157. #1 {main}
  158. 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  159. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  160. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  161. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  162. ,salary=:salary,feeper=:auto_feeper
  163. where id=@bizid; update biz_trader set updatetime=1656476151 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  164. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476151 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  165. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  166. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  167. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  168. 异常堆栈上下文:
  169. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  170. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  171. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  172. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(530): pdo_query3()
  173. #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  174. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
  175. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader()
  176. #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  177. #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  178. #9 {main}
  179. [上下文相关信息]:
  180. [WsAjaxPrj]=KLY
  181. [WsAjaxBiz]=Trader
  182. [WsAjaxAction]=entityDataHandle
  183. [USER]=nginxphp
  184. [HOME]=/home/nginxphp
  185. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html
  186. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  187. [HTTP_CONTENT_TYPE]=application/json
  188. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android
  189. [HTTP_CHARSET]=utf-8
  190. [HTTP_CONTENT_LENGTH]=926
  191. [HTTP_CONNECTION]=keep-alive
  192. [HTTP_HOST]=api.kuailaiyou.top
  193. [REDIRECT_STATUS]=200
  194. [SERVER_NAME]=api.kuailaiyou.top
  195. [SERVER_PORT]=443
  196. [SERVER_ADDR]=172.18.217.149
  197. [REMOTE_PORT]=13356
  198. [REMOTE_ADDR]=218.69.51.169
  199. [SERVER_SOFTWARE]=nginx/1.20.1
  200. [GATEWAY_INTERFACE]=CGI/1.1
  201. [HTTPS]=on
  202. [REQUEST_SCHEME]=https
  203. [SERVER_PROTOCOL]=HTTP/1.1
  204. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  205. [DOCUMENT_URI]=/ajaxEntryCenter.php
  206. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  207. [SCRIPT_NAME]=/ajaxEntryCenter.php
  208. [CONTENT_LENGTH]=926
  209. [CONTENT_TYPE]=application/json
  210. [REQUEST_METHOD]=POST
  211. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  212. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  213. [FCGI_ROLE]=RESPONDER
  214. [PHP_SELF]=/ajaxEntryCenter.php
  215. [REQUEST_TIME_FLOAT]=1656476151.9822
  216. [REQUEST_TIME]=1656476151
  217. 12:16:22 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  218. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  219. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  220. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  221. ,salary=:salary,feeper=:auto_feeper
  222. where id=@bizid; update biz_trader set updatetime=1656476182 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  223. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476182 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  224. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  225. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  226. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  227. 异常堆栈上下文:
  228. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  229. #1 {main}
  230. 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  231. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  232. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  233. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  234. ,salary=:salary,feeper=:auto_feeper
  235. where id=@bizid; update biz_trader set updatetime=1656476182 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  236. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476182 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  237. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  238. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  239. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  240. 异常堆栈上下文:
  241. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  242. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  243. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  244. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(530): pdo_query3()
  245. #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  246. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
  247. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader()
  248. #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  249. #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  250. #9 {main}
  251. [上下文相关信息]:
  252. [WsAjaxPrj]=KLY
  253. [WsAjaxBiz]=Trader
  254. [WsAjaxAction]=entityDataHandle
  255. [USER]=nginxphp
  256. [HOME]=/home/nginxphp
  257. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html
  258. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  259. [HTTP_CONTENT_TYPE]=application/json
  260. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android
  261. [HTTP_CHARSET]=utf-8
  262. [HTTP_CONTENT_LENGTH]=934
  263. [HTTP_CONNECTION]=keep-alive
  264. [HTTP_HOST]=api.kuailaiyou.top
  265. [REDIRECT_STATUS]=200
  266. [SERVER_NAME]=api.kuailaiyou.top
  267. [SERVER_PORT]=443
  268. [SERVER_ADDR]=172.18.217.149
  269. [REMOTE_PORT]=13467
  270. [REMOTE_ADDR]=218.69.51.169
  271. [SERVER_SOFTWARE]=nginx/1.20.1
  272. [GATEWAY_INTERFACE]=CGI/1.1
  273. [HTTPS]=on
  274. [REQUEST_SCHEME]=https
  275. [SERVER_PROTOCOL]=HTTP/1.1
  276. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  277. [DOCUMENT_URI]=/ajaxEntryCenter.php
  278. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  279. [SCRIPT_NAME]=/ajaxEntryCenter.php
  280. [CONTENT_LENGTH]=934
  281. [CONTENT_TYPE]=application/json
  282. [REQUEST_METHOD]=POST
  283. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  284. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  285. [FCGI_ROLE]=RESPONDER
  286. [PHP_SELF]=/ajaxEntryCenter.php
  287. [REQUEST_TIME_FLOAT]=1656476182.7348
  288. [REQUEST_TIME]=1656476182
  289. 12:16:32 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  290. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  291. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  292. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  293. ,salary=:salary,feeper=:auto_feeper
  294. where id=@bizid; update biz_trader set updatetime=1656476192 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  295. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476192 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  296. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  297. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  298. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  299. 异常堆栈上下文:
  300. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  301. #1 {main}
  302. 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  303. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  304. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  305. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  306. ,salary=:salary,feeper=:auto_feeper
  307. where id=@bizid; update biz_trader set updatetime=1656476192 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  308. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476192 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  309. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  310. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  311. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  312. 异常堆栈上下文:
  313. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  314. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  315. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  316. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(530): pdo_query3()
  317. #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  318. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
  319. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader()
  320. #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  321. #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  322. #9 {main}
  323. [上下文相关信息]:
  324. [WsAjaxPrj]=KLY
  325. [WsAjaxBiz]=Trader
  326. [WsAjaxAction]=entityDataHandle
  327. [USER]=nginxphp
  328. [HOME]=/home/nginxphp
  329. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html
  330. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  331. [HTTP_CONTENT_TYPE]=application/json
  332. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android
  333. [HTTP_CHARSET]=utf-8
  334. [HTTP_CONTENT_LENGTH]=933
  335. [HTTP_CONNECTION]=keep-alive
  336. [HTTP_HOST]=api.kuailaiyou.top
  337. [REDIRECT_STATUS]=200
  338. [SERVER_NAME]=api.kuailaiyou.top
  339. [SERVER_PORT]=443
  340. [SERVER_ADDR]=172.18.217.149
  341. [REMOTE_PORT]=13467
  342. [REMOTE_ADDR]=218.69.51.169
  343. [SERVER_SOFTWARE]=nginx/1.20.1
  344. [GATEWAY_INTERFACE]=CGI/1.1
  345. [HTTPS]=on
  346. [REQUEST_SCHEME]=https
  347. [SERVER_PROTOCOL]=HTTP/1.1
  348. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  349. [DOCUMENT_URI]=/ajaxEntryCenter.php
  350. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  351. [SCRIPT_NAME]=/ajaxEntryCenter.php
  352. [CONTENT_LENGTH]=933
  353. [CONTENT_TYPE]=application/json
  354. [REQUEST_METHOD]=POST
  355. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  356. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  357. [FCGI_ROLE]=RESPONDER
  358. [PHP_SELF]=/ajaxEntryCenter.php
  359. [REQUEST_TIME_FLOAT]=1656476192.604
  360. [REQUEST_TIME]=1656476192
  361. 12:16:41 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  362. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  363. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  364. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  365. ,salary=:salary,feeper=:auto_feeper
  366. where id=@bizid; update biz_trader set updatetime=1656476201 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  367. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476201 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  368. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  369. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  370. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  371. 异常堆栈上下文:
  372. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  373. #1 {main}
  374. 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  375. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  376. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  377. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  378. ,salary=:salary,feeper=:auto_feeper
  379. where id=@bizid; update biz_trader set updatetime=1656476201 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  380. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476201 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  381. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  382. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  383. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  384. 异常堆栈上下文:
  385. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  386. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  387. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  388. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(530): pdo_query3()
  389. #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  390. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
  391. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader()
  392. #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  393. #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  394. #9 {main}
  395. [上下文相关信息]:
  396. [WsAjaxPrj]=KLY
  397. [WsAjaxBiz]=Trader
  398. [WsAjaxAction]=entityDataHandle
  399. [USER]=nginxphp
  400. [HOME]=/home/nginxphp
  401. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html
  402. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  403. [HTTP_CONTENT_TYPE]=application/json
  404. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android
  405. [HTTP_CHARSET]=utf-8
  406. [HTTP_CONTENT_LENGTH]=933
  407. [HTTP_CONNECTION]=keep-alive
  408. [HTTP_HOST]=api.kuailaiyou.top
  409. [REDIRECT_STATUS]=200
  410. [SERVER_NAME]=api.kuailaiyou.top
  411. [SERVER_PORT]=443
  412. [SERVER_ADDR]=172.18.217.149
  413. [REMOTE_PORT]=13467
  414. [REMOTE_ADDR]=218.69.51.169
  415. [SERVER_SOFTWARE]=nginx/1.20.1
  416. [GATEWAY_INTERFACE]=CGI/1.1
  417. [HTTPS]=on
  418. [REQUEST_SCHEME]=https
  419. [SERVER_PROTOCOL]=HTTP/1.1
  420. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  421. [DOCUMENT_URI]=/ajaxEntryCenter.php
  422. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  423. [SCRIPT_NAME]=/ajaxEntryCenter.php
  424. [CONTENT_LENGTH]=933
  425. [CONTENT_TYPE]=application/json
  426. [REQUEST_METHOD]=POST
  427. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  428. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  429. [FCGI_ROLE]=RESPONDER
  430. [PHP_SELF]=/ajaxEntryCenter.php
  431. [REQUEST_TIME_FLOAT]=1656476201.9687
  432. [REQUEST_TIME]=1656476201
  433. 12:20:17 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  434. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  435. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  436. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  437. ,salary=:salary,feeper=:auto_feeper
  438. where id=@bizid; update biz_trader set updatetime=1656476417 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  439. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476417 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  440. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  441. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  442. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  443. 异常堆栈上下文:
  444. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  445. #1 {main}
  446. 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1
  447. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,''))
  448. ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney
  449. ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney
  450. ,salary=:salary,feeper=:auto_feeper
  451. where id=@bizid; update biz_trader set updatetime=1656476417 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
  452. ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476417 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
  453. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
  454. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"]
  455. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  456. 异常堆栈上下文:
  457. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  458. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  459. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  460. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(530): pdo_query3()
  461. #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  462. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
  463. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader()
  464. #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle()
  465. #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  466. #9 {main}
  467. [上下文相关信息]:
  468. [WsAjaxPrj]=KLY
  469. [WsAjaxBiz]=Trader
  470. [WsAjaxAction]=entityDataHandle
  471. [USER]=nginxphp
  472. [HOME]=/home/nginxphp
  473. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html
  474. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  475. [HTTP_CONTENT_TYPE]=application/json
  476. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android
  477. [HTTP_CHARSET]=utf-8
  478. [HTTP_CONTENT_LENGTH]=933
  479. [HTTP_CONNECTION]=keep-alive
  480. [HTTP_HOST]=api.kuailaiyou.top
  481. [REDIRECT_STATUS]=200
  482. [SERVER_NAME]=api.kuailaiyou.top
  483. [SERVER_PORT]=443
  484. [SERVER_ADDR]=172.18.217.149
  485. [REMOTE_PORT]=14504
  486. [REMOTE_ADDR]=218.69.51.169
  487. [SERVER_SOFTWARE]=nginx/1.20.1
  488. [GATEWAY_INTERFACE]=CGI/1.1
  489. [HTTPS]=on
  490. [REQUEST_SCHEME]=https
  491. [SERVER_PROTOCOL]=HTTP/1.1
  492. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  493. [DOCUMENT_URI]=/ajaxEntryCenter.php
  494. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  495. [SCRIPT_NAME]=/ajaxEntryCenter.php
  496. [CONTENT_LENGTH]=933
  497. [CONTENT_TYPE]=application/json
  498. [REQUEST_METHOD]=POST
  499. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  500. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  501. [FCGI_ROLE]=RESPONDER
  502. [PHP_SELF]=/ajaxEntryCenter.php
  503. [REQUEST_TIME_FLOAT]=1656476417.5404
  504. [REQUEST_TIME]=1656476417