2021123016_entityDataHandle.log 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174
  1. 16:11:07 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1
  2. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit;
  3. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"]
  4. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[133]行 code[0] !
  5. 异常堆栈上下文:
  6. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  7. #1 {main}
  8. 数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1
  9. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit;
  10. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"]
  11. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  12. 异常堆栈上下文:
  13. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  14. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  15. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  16. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2473): pdo_query3()
  17. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(68): bizbase_todoWorkEntityHandle()
  18. #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  19. #6 {main}
  20. [上下文相关信息]:
  21. [WsAjaxPrj]=KLY
  22. [WsAjaxBiz]=Worker
  23. [WsAjaxAction]=entityDataHandle
  24. [USER]=nginxphp
  25. [HOME]=/home/nginxphp
  26. [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html
  27. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  28. [HTTP_CONTENT_TYPE]=application/json
  29. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 10; AQM-AL10 Build/HONORAQM-AL10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/3171 MMWEBSDK/20211001 Mobile Safari/537.36 MMWEBID/8513 MicroMessenger/8.0.16.2040(0x2800105B) Process/appbrand0 WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android
  30. [HTTP_CHARSET]=utf-8
  31. [HTTP_CONTENT_LENGTH]=310
  32. [HTTP_CONNECTION]=keep-alive
  33. [HTTP_HOST]=api.kuailaiyou.top
  34. [REDIRECT_STATUS]=200
  35. [SERVER_NAME]=api.kuailaiyou.top
  36. [SERVER_PORT]=443
  37. [SERVER_ADDR]=172.18.217.149
  38. [REMOTE_PORT]=44260
  39. [REMOTE_ADDR]=218.69.52.90
  40. [SERVER_SOFTWARE]=nginx/1.20.1
  41. [GATEWAY_INTERFACE]=CGI/1.1
  42. [HTTPS]=on
  43. [REQUEST_SCHEME]=https
  44. [SERVER_PROTOCOL]=HTTP/1.1
  45. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  46. [DOCUMENT_URI]=/ajaxEntryCenter.php
  47. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  48. [SCRIPT_NAME]=/ajaxEntryCenter.php
  49. [CONTENT_LENGTH]=310
  50. [CONTENT_TYPE]=application/json
  51. [REQUEST_METHOD]=POST
  52. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  53. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  54. [FCGI_ROLE]=RESPONDER
  55. [PHP_SELF]=/ajaxEntryCenter.php
  56. [REQUEST_TIME_FLOAT]=1640851867.4375
  57. [REQUEST_TIME]=1640851867
  58. 16:12:02 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1
  59. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit;
  60. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"]
  61. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[133]行 code[0] !
  62. 异常堆栈上下文:
  63. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  64. #1 {main}
  65. 数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1
  66. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit;
  67. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"]
  68. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  69. 异常堆栈上下文:
  70. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  71. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  72. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  73. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2473): pdo_query3()
  74. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(68): bizbase_todoWorkEntityHandle()
  75. #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  76. #6 {main}
  77. [上下文相关信息]:
  78. [WsAjaxPrj]=KLY
  79. [WsAjaxBiz]=Worker
  80. [WsAjaxAction]=entityDataHandle
  81. [USER]=nginxphp
  82. [HOME]=/home/nginxphp
  83. [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html
  84. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  85. [HTTP_CONTENT_TYPE]=application/json
  86. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 10; AQM-AL10 Build/HONORAQM-AL10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/3171 MMWEBSDK/20211001 Mobile Safari/537.36 MMWEBID/8513 MicroMessenger/8.0.16.2040(0x2800105B) Process/appbrand0 WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android
  87. [HTTP_CHARSET]=utf-8
  88. [HTTP_CONTENT_LENGTH]=310
  89. [HTTP_CONNECTION]=keep-alive
  90. [HTTP_HOST]=api.kuailaiyou.top
  91. [REDIRECT_STATUS]=200
  92. [SERVER_NAME]=api.kuailaiyou.top
  93. [SERVER_PORT]=443
  94. [SERVER_ADDR]=172.18.217.149
  95. [REMOTE_PORT]=44260
  96. [REMOTE_ADDR]=218.69.52.90
  97. [SERVER_SOFTWARE]=nginx/1.20.1
  98. [GATEWAY_INTERFACE]=CGI/1.1
  99. [HTTPS]=on
  100. [REQUEST_SCHEME]=https
  101. [SERVER_PROTOCOL]=HTTP/1.1
  102. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  103. [DOCUMENT_URI]=/ajaxEntryCenter.php
  104. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  105. [SCRIPT_NAME]=/ajaxEntryCenter.php
  106. [CONTENT_LENGTH]=310
  107. [CONTENT_TYPE]=application/json
  108. [REQUEST_METHOD]=POST
  109. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  110. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  111. [FCGI_ROLE]=RESPONDER
  112. [PHP_SELF]=/ajaxEntryCenter.php
  113. [REQUEST_TIME_FLOAT]=1640851922.8884
  114. [REQUEST_TIME]=1640851922
  115. 16:12:28 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1
  116. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit;
  117. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"]
  118. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[133]行 code[0] !
  119. 异常堆栈上下文:
  120. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  121. #1 {main}
  122. 数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1
  123. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit;
  124. ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"]
  125. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  126. 异常堆栈上下文:
  127. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  128. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  129. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  130. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2473): pdo_query3()
  131. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(68): bizbase_todoWorkEntityHandle()
  132. #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  133. #6 {main}
  134. [上下文相关信息]:
  135. [WsAjaxPrj]=KLY
  136. [WsAjaxBiz]=Worker
  137. [WsAjaxAction]=entityDataHandle
  138. [USER]=nginxphp
  139. [HOME]=/home/nginxphp
  140. [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html
  141. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  142. [HTTP_CONTENT_TYPE]=application/json
  143. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 10; AQM-AL10 Build/HONORAQM-AL10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/3171 MMWEBSDK/20211001 Mobile Safari/537.36 MMWEBID/8513 MicroMessenger/8.0.16.2040(0x2800105B) Process/appbrand0 WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android
  144. [HTTP_CHARSET]=utf-8
  145. [HTTP_CONTENT_LENGTH]=310
  146. [HTTP_CONNECTION]=keep-alive
  147. [HTTP_HOST]=api.kuailaiyou.top
  148. [REDIRECT_STATUS]=200
  149. [SERVER_NAME]=api.kuailaiyou.top
  150. [SERVER_PORT]=443
  151. [SERVER_ADDR]=172.18.217.149
  152. [REMOTE_PORT]=44260
  153. [REMOTE_ADDR]=218.69.52.90
  154. [SERVER_SOFTWARE]=nginx/1.20.1
  155. [GATEWAY_INTERFACE]=CGI/1.1
  156. [HTTPS]=on
  157. [REQUEST_SCHEME]=https
  158. [SERVER_PROTOCOL]=HTTP/1.1
  159. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  160. [DOCUMENT_URI]=/ajaxEntryCenter.php
  161. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  162. [SCRIPT_NAME]=/ajaxEntryCenter.php
  163. [CONTENT_LENGTH]=310
  164. [CONTENT_TYPE]=application/json
  165. [REQUEST_METHOD]=POST
  166. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  167. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  168. [FCGI_ROLE]=RESPONDER
  169. [PHP_SELF]=/ajaxEntryCenter.php
  170. [REQUEST_TIME_FLOAT]=1640851948.3766
  171. [REQUEST_TIME]=1640851948