Home Explore Help
Register Sign In
php_group
/
kly_api
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: dad56fe50d
Branches Tags
kly_api
/
logfiles
/
2021120317_entityDataHandle.log

2021120317_entityDataHandle.log 6.2 KB
History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 
  1. 17:34:04 [error]: 通用的实体数据存取接口异常：数据库执行异常:Data too long for column 'profile_photo' at row 1
    2. 

  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 , `begin_datetime` =  :begin_datetime , `finish_datetime` =  :finish_datetime , `settle_catalog` =  :settle_catalog , `begin_hour` =  :begin_hour , `finish_hour` =  :finish_hour , `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; set @bizid=LAST_INSERT_ID(); update biz_trader set updatetime=1638524044        ,freecount_used=ifnull(freecount_used,0)+20        ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
    3. 

  3. ',ifnull(freecount_used_remark,''))  where id=2; insert into biz_trader_numaccount set createtime=1638524044        ,biz_traderid=2        ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=20       ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
    4. 

  4. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
    5. 

  5. ["22001",1406,"Data too long for column 'profile_photo' at row 1"]
    6. 

  6. 	异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[133]行 code[0] ！
    7. 

  7. 	异常堆栈上下文：
    8. 

  8. 		#0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
    9. 

  9. 		#1 {main}
    10. 

  10. 数据库执行异常:Data too long for column 'profile_photo' at row 1
    11. 

  11.  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 , `begin_datetime` =  :begin_datetime , `finish_datetime` =  :finish_datetime , `settle_catalog` =  :settle_catalog , `begin_hour` =  :begin_hour , `finish_hour` =  :finish_hour , `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; set @bizid=LAST_INSERT_ID(); update biz_trader set updatetime=1638524044        ,freecount_used=ifnull(freecount_used,0)+20        ,freecount_used_remark=concat(:freecount_used_remark,@bizid,'
    12. 

  12. ',ifnull(freecount_used_remark,''))  where id=2; insert into biz_trader_numaccount set createtime=1638524044        ,biz_traderid=2        ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=20       ,`status`=1,remark=concat(:numaccount_remark,@bizid,'
    13. 

  13. ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit;
    14. 

  14. ["22001",1406,"Data too long for column 'profile_photo' at row 1"]
    15. 

  15. 	异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ！
    16. 

  16. 	异常堆栈上下文：
    17. 

  17. 		#0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
    18. 

  18. 		#1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
    19. 

  19. 		#2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
    20. 

  20. 		#3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(342): pdo_query3()
    21. 

  21. 		#4 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
    22. 

  22. 		#5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle()
    23. 

  23. 		#6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(345): biz_flkForTrader()
    24. 

  24. 		#7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(34): bizbase_recruitEntityHandle()
    25. 

  25. 		#8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
    26. 

  26. 		#9 {main}
    27. 

  27. [上下文相关信息]：
    28. 

  28. 	[WsAjaxPrj]=KLY
    29. 

  29. 	[WsAjaxBiz]=Trader
    30. 

  30. 	[WsAjaxAction]=entityDataHandle
    31. 

  31. 	[USER]=nginxphp
    32. 

  32. 	[HOME]=/home/nginxphp
    33. 

  33. 	[HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
    34. 

  34. 	[HTTP_ACCEPT_ENCODING]=gzip, deflate, br
    35. 

  35. 	[HTTP_REFERER]=http://192.168.0.168:8081/
    36. 

  36. 	[HTTP_SEC_FETCH_DEST]=empty
    37. 

  37. 	[HTTP_SEC_FETCH_MODE]=cors
    38. 

  38. 	[HTTP_SEC_FETCH_SITE]=cross-site
    39. 

  39. 	[HTTP_ORIGIN]=http://192.168.0.168:8081
    40. 

  40. 	[HTTP_ACCEPT]=*/*
    41. 

  41. 	[HTTP_CONTENT_TYPE]=application/json
    42. 

  42. 	[HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1
    43. 

  43. 	[HTTP_CONTENT_LENGTH]=828
    44. 

  44. 	[HTTP_CONNECTION]=keep-alive
    45. 

  45. 	[HTTP_HOST]=api.kuailaiyou.top
    46. 

  46. 	[REDIRECT_STATUS]=200
    47. 

  47. 	[SERVER_NAME]=api.kuailaiyou.top
    48. 

  48. 	[SERVER_PORT]=443
    49. 

  49. 	[SERVER_ADDR]=172.18.217.149
    50. 

  50. 	[REMOTE_PORT]=50241
    51. 

  51. 	[REMOTE_ADDR]=117.14.216.207
    52. 

  52. 	[SERVER_SOFTWARE]=nginx/1.20.1
    53. 

  53. 	[GATEWAY_INTERFACE]=CGI/1.1
    54. 

  54. 	[HTTPS]=on
    55. 

  55. 	[REQUEST_SCHEME]=https
    56. 

  56. 	[SERVER_PROTOCOL]=HTTP/1.1
    57. 

  57. 	[DOCUMENT_ROOT]=/bizroot/approot/klywebapi
    58. 

  58. 	[DOCUMENT_URI]=/ajaxEntryCenter.php
    59. 

  59. 	[REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
    60. 

  60. 	[SCRIPT_NAME]=/ajaxEntryCenter.php
    61. 

  61. 	[CONTENT_LENGTH]=828
    62. 

  62. 	[CONTENT_TYPE]=application/json
    63. 

  63. 	[REQUEST_METHOD]=POST
    64. 

  64. 	[QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
    65. 

  65. 	[SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
    66. 

  66. 	[FCGI_ROLE]=RESPONDER
    67. 

  67. 	[PHP_SELF]=/ajaxEntryCenter.php
    68. 

  68. 	[REQUEST_TIME_FLOAT]=1638524044.8411
    69. 

  69. 	[REQUEST_TIME]=1638524044 
    70. 

  70.