2021121418_registerInfo.php.log 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192
  1. 18:00:58 [error]: 发生异常:数据库执行异常:Data too long for column 'profile_photo' at row 1
  2. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;update biz_worker SET `updatetime`=:nowtime,remark=concat(:remark,ifnull(remark,'')) ,`true_name` = :true_name , `idcard` = :idcard , `profile_photo` = :profile_photo , `gender` = :gender , `birthday` = :birthday , `edulevel_name` = :edulevel_name , `nation_name` = :nation_name , `birthaddr` = :birthaddr , `nowaddr` = :nowaddr , `body_height` = :body_height , `body_weight` = :body_weight , `work_skills` = :work_skills , `self_evaluation` = :self_evaluation , `work_history` = :work_history where id=:id;commit;
  3. ["22001",1406,"Data too long for column 'profile_photo' at row 1"]
  4. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/registerInfo.php]的[59]行 code[0] !
  5. 异常堆栈上下文:
  6. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  7. #1 {main}
  8. 数据库执行异常:Data too long for column 'profile_photo' at row 1
  9. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;update biz_worker SET `updatetime`=:nowtime,remark=concat(:remark,ifnull(remark,'')) ,`true_name` = :true_name , `idcard` = :idcard , `profile_photo` = :profile_photo , `gender` = :gender , `birthday` = :birthday , `edulevel_name` = :edulevel_name , `nation_name` = :nation_name , `birthaddr` = :birthaddr , `nowaddr` = :nowaddr , `body_height` = :body_height , `body_weight` = :body_weight , `work_skills` = :work_skills , `self_evaluation` = :self_evaluation , `work_history` = :work_history where id=:id;commit;
  10. ["22001",1406,"Data too long for column 'profile_photo' 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/bizcenter/Worker/registerInfo.php(54): pdo_query3()
  17. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  18. #5 {main}
  19. [上下文相关信息]:
  20. [WsAjaxPrj]=KLY
  21. [WsAjaxBiz]=Worker
  22. [WsAjaxAction]=registerInfo
  23. [USER]=nginxphp
  24. [HOME]=/home/nginxphp
  25. [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
  26. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  27. [HTTP_REFERER]=http://192.168.0.168:8081/
  28. [HTTP_SEC_FETCH_DEST]=empty
  29. [HTTP_SEC_FETCH_MODE]=cors
  30. [HTTP_SEC_FETCH_SITE]=cross-site
  31. [HTTP_ORIGIN]=http://192.168.0.168:8081
  32. [HTTP_ACCEPT]=*/*
  33. [HTTP_CONTENT_TYPE]=application/json
  34. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 10_3_1 like Mac OS X) AppleWebKit/603.1.30 (KHTML, like Gecko) Version/10.0 Mobile/14E304 Safari/602.1
  35. [HTTP_CONTENT_LENGTH]=1103
  36. [HTTP_CONNECTION]=keep-alive
  37. [HTTP_HOST]=api.kuailaiyou.top
  38. [REDIRECT_STATUS]=200
  39. [SERVER_NAME]=api.kuailaiyou.top
  40. [SERVER_PORT]=443
  41. [SERVER_ADDR]=172.18.217.149
  42. [REMOTE_PORT]=60481
  43. [REMOTE_ADDR]=60.24.227.178
  44. [SERVER_SOFTWARE]=nginx/1.20.1
  45. [GATEWAY_INTERFACE]=CGI/1.1
  46. [HTTPS]=on
  47. [REQUEST_SCHEME]=https
  48. [SERVER_PROTOCOL]=HTTP/1.1
  49. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  50. [DOCUMENT_URI]=/ajaxEntryCenter.php
  51. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=registerInfo
  52. [SCRIPT_NAME]=/ajaxEntryCenter.php
  53. [CONTENT_LENGTH]=1103
  54. [CONTENT_TYPE]=application/json
  55. [REQUEST_METHOD]=POST
  56. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=registerInfo
  57. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  58. [FCGI_ROLE]=RESPONDER
  59. [PHP_SELF]=/ajaxEntryCenter.php
  60. [REQUEST_TIME_FLOAT]=1639476058.3041
  61. [REQUEST_TIME]=1639476058
  62. 18:05:17 [error]: 发生异常:数据库执行异常:Data too long for column 'profile_photo' at row 1
  63. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;update biz_trader SET `updatetime`=:nowtime,remark=concat(:remark,ifnull(remark,'')) ,`catalog` = :catalog , `company_name` = :company_name , `company_idcard` = :company_idcard , `bizlicense_pic` = :bizlicense_pic , `lawer_idcard_mixpic` = :lawer_idcard_mixpic , `profile_photo` = :profile_photo , `linker_name` = :linker_name , `linker_gender` = :linker_gender , `company_addr` = :company_addr , `company_desc` = :company_desc where id=:id;commit;
  64. ["22001",1406,"Data too long for column 'profile_photo' at row 1"]
  65. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/registerInfo.php]的[64]行 code[0] !
  66. 异常堆栈上下文:
  67. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  68. #1 {main}
  69. 数据库执行异常:Data too long for column 'profile_photo' at row 1
  70. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;update biz_trader SET `updatetime`=:nowtime,remark=concat(:remark,ifnull(remark,'')) ,`catalog` = :catalog , `company_name` = :company_name , `company_idcard` = :company_idcard , `bizlicense_pic` = :bizlicense_pic , `lawer_idcard_mixpic` = :lawer_idcard_mixpic , `profile_photo` = :profile_photo , `linker_name` = :linker_name , `linker_gender` = :linker_gender , `company_addr` = :company_addr , `company_desc` = :company_desc where id=:id;commit;
  71. ["22001",1406,"Data too long for column 'profile_photo' at row 1"]
  72. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  73. 异常堆栈上下文:
  74. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  75. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  76. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  77. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/registerInfo.php(59): pdo_query3()
  78. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  79. #5 {main}
  80. [上下文相关信息]:
  81. [WsAjaxPrj]=KLY
  82. [WsAjaxBiz]=Trader
  83. [WsAjaxAction]=registerInfo
  84. [USER]=nginxphp
  85. [HOME]=/home/nginxphp
  86. [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
  87. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  88. [HTTP_REFERER]=http://192.168.0.168:8082/
  89. [HTTP_SEC_FETCH_DEST]=empty
  90. [HTTP_SEC_FETCH_MODE]=cors
  91. [HTTP_SEC_FETCH_SITE]=cross-site
  92. [HTTP_ORIGIN]=http://192.168.0.168:8082
  93. [HTTP_ACCEPT]=*/*
  94. [HTTP_CONTENT_TYPE]=application/json
  95. [HTTP_SEC_CH_UA_PLATFORM]="Android"
  96. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 8.0; Pixel 2 Build/OPD3.170816.012) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Mobile Safari/537.36
  97. [HTTP_SEC_CH_UA_MOBILE]=?1
  98. [HTTP_SEC_CH_UA]="Google Chrome";v="95", "Chromium";v="95", ";Not A Brand";v="99"
  99. [HTTP_CONTENT_LENGTH]=3488
  100. [HTTP_CONNECTION]=keep-alive
  101. [HTTP_HOST]=api.kuailaiyou.top
  102. [REDIRECT_STATUS]=200
  103. [SERVER_NAME]=api.kuailaiyou.top
  104. [SERVER_PORT]=443
  105. [SERVER_ADDR]=172.18.217.149
  106. [REMOTE_PORT]=23105
  107. [REMOTE_ADDR]=60.24.227.178
  108. [SERVER_SOFTWARE]=nginx/1.20.1
  109. [GATEWAY_INTERFACE]=CGI/1.1
  110. [HTTPS]=on
  111. [REQUEST_SCHEME]=https
  112. [SERVER_PROTOCOL]=HTTP/1.1
  113. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  114. [DOCUMENT_URI]=/ajaxEntryCenter.php
  115. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=registerInfo
  116. [SCRIPT_NAME]=/ajaxEntryCenter.php
  117. [CONTENT_LENGTH]=3488
  118. [CONTENT_TYPE]=application/json
  119. [REQUEST_METHOD]=POST
  120. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=registerInfo
  121. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  122. [FCGI_ROLE]=RESPONDER
  123. [PHP_SELF]=/ajaxEntryCenter.php
  124. [REQUEST_TIME_FLOAT]=1639476317.7566
  125. [REQUEST_TIME]=1639476317
  126. 18:05:42 [error]: 发生异常:数据库执行异常:Data too long for column 'profile_photo' at row 1
  127. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;update biz_trader SET `updatetime`=:nowtime,remark=concat(:remark,ifnull(remark,'')) ,`catalog` = :catalog , `company_name` = :company_name , `company_idcard` = :company_idcard , `bizlicense_pic` = :bizlicense_pic , `lawer_idcard_mixpic` = :lawer_idcard_mixpic , `profile_photo` = :profile_photo , `linker_name` = :linker_name , `linker_gender` = :linker_gender , `company_addr` = :company_addr , `company_desc` = :company_desc where id=:id;commit;
  128. ["22001",1406,"Data too long for column 'profile_photo' at row 1"]
  129. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/registerInfo.php]的[64]行 code[0] !
  130. 异常堆栈上下文:
  131. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  132. #1 {main}
  133. 数据库执行异常:Data too long for column 'profile_photo' at row 1
  134. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;update biz_trader SET `updatetime`=:nowtime,remark=concat(:remark,ifnull(remark,'')) ,`catalog` = :catalog , `company_name` = :company_name , `company_idcard` = :company_idcard , `bizlicense_pic` = :bizlicense_pic , `lawer_idcard_mixpic` = :lawer_idcard_mixpic , `profile_photo` = :profile_photo , `linker_name` = :linker_name , `linker_gender` = :linker_gender , `company_addr` = :company_addr , `company_desc` = :company_desc where id=:id;commit;
  135. ["22001",1406,"Data too long for column 'profile_photo' at row 1"]
  136. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  137. 异常堆栈上下文:
  138. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  139. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  140. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  141. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/registerInfo.php(59): pdo_query3()
  142. #4 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  143. #5 {main}
  144. [上下文相关信息]:
  145. [WsAjaxPrj]=KLY
  146. [WsAjaxBiz]=Trader
  147. [WsAjaxAction]=registerInfo
  148. [USER]=nginxphp
  149. [HOME]=/home/nginxphp
  150. [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
  151. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  152. [HTTP_REFERER]=http://192.168.0.168:8082/
  153. [HTTP_SEC_FETCH_DEST]=empty
  154. [HTTP_SEC_FETCH_MODE]=cors
  155. [HTTP_SEC_FETCH_SITE]=cross-site
  156. [HTTP_ORIGIN]=http://192.168.0.168:8082
  157. [HTTP_ACCEPT]=*/*
  158. [HTTP_CONTENT_TYPE]=application/json
  159. [HTTP_SEC_CH_UA_PLATFORM]="Android"
  160. [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 8.0; Pixel 2 Build/OPD3.170816.012) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Mobile Safari/537.36
  161. [HTTP_SEC_CH_UA_MOBILE]=?1
  162. [HTTP_SEC_CH_UA]="Google Chrome";v="95", "Chromium";v="95", ";Not A Brand";v="99"
  163. [HTTP_CONTENT_LENGTH]=3559
  164. [HTTP_CONNECTION]=keep-alive
  165. [HTTP_HOST]=api.kuailaiyou.top
  166. [REDIRECT_STATUS]=200
  167. [SERVER_NAME]=api.kuailaiyou.top
  168. [SERVER_PORT]=443
  169. [SERVER_ADDR]=172.18.217.149
  170. [REMOTE_PORT]=28449
  171. [REMOTE_ADDR]=60.24.227.178
  172. [SERVER_SOFTWARE]=nginx/1.20.1
  173. [GATEWAY_INTERFACE]=CGI/1.1
  174. [HTTPS]=on
  175. [REQUEST_SCHEME]=https
  176. [SERVER_PROTOCOL]=HTTP/1.1
  177. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  178. [DOCUMENT_URI]=/ajaxEntryCenter.php
  179. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=registerInfo
  180. [SCRIPT_NAME]=/ajaxEntryCenter.php
  181. [CONTENT_LENGTH]=3559
  182. [CONTENT_TYPE]=application/json
  183. [REQUEST_METHOD]=POST
  184. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=registerInfo
  185. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  186. [FCGI_ROLE]=RESPONDER
  187. [PHP_SELF]=/ajaxEntryCenter.php
  188. [REQUEST_TIME_FLOAT]=1639476342.8668
  189. [REQUEST_TIME]=1639476342