2021121016_KLY_Test.log 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226
  1. 16:53:53 [info]: 测试一下
  2. [上下文相关信息]:
  3. [WsAjaxPrj]=KLY
  4. [WsAjaxBiz]=ZTest
  5. [WsAjaxAction]=action1
  6. [USER]=nginxphp
  7. [HOME]=/home/nginxphp
  8. [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
  9. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  10. [HTTP_REFERER]=https://zpwebapi.kaidekuai.com/
  11. [HTTP_SEC_FETCH_DEST]=empty
  12. [HTTP_SEC_FETCH_MODE]=cors
  13. [HTTP_SEC_FETCH_SITE]=cross-site
  14. [HTTP_ORIGIN]=https://zpwebapi.kaidekuai.com
  15. [HTTP_SEC_CH_UA_PLATFORM]="Windows"
  16. [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36
  17. [HTTP_SEC_CH_UA_MOBILE]=?0
  18. [HTTP_CONTENT_TYPE]=text/json,charset=utf-8
  19. [HTTP_ACCEPT]=application/json, text/javascript, */*; q=0.01
  20. [HTTP_SEC_CH_UA]="Chromium";v="94", "Google Chrome";v="94", ";Not A Brand";v="99"
  21. [HTTP_CACHE_CONTROL]=no-cache
  22. [HTTP_PRAGMA]=no-cache
  23. [HTTP_CONTENT_LENGTH]=38
  24. [HTTP_CONNECTION]=keep-alive
  25. [HTTP_HOST]=api.kuailaiyou.top
  26. [REDIRECT_STATUS]=200
  27. [SERVER_NAME]=api.kuailaiyou.top
  28. [SERVER_PORT]=443
  29. [SERVER_ADDR]=172.18.217.149
  30. [REMOTE_PORT]=37089
  31. [REMOTE_ADDR]=60.24.227.178
  32. [SERVER_SOFTWARE]=nginx/1.20.1
  33. [GATEWAY_INTERFACE]=CGI/1.1
  34. [HTTPS]=on
  35. [REQUEST_SCHEME]=https
  36. [SERVER_PROTOCOL]=HTTP/1.1
  37. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  38. [DOCUMENT_URI]=/ajaxEntryCenter.php
  39. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  40. [SCRIPT_NAME]=/ajaxEntryCenter.php
  41. [CONTENT_LENGTH]=38
  42. [CONTENT_TYPE]=text/json,charset=utf-8
  43. [REQUEST_METHOD]=POST
  44. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  45. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  46. [FCGI_ROLE]=RESPONDER
  47. [PHP_SELF]=/ajaxEntryCenter.php
  48. [REQUEST_TIME_FLOAT]=1639126433.8128
  49. [REQUEST_TIME]=1639126433
  50. 16:53:53 [error]: 非常抱歉,处理业务时发生错误数据库执行异常:Unknown column 'td2.td2_true_name' in 'field list'
  51. sql语句:select bu.*,wk.true_name,td.company_name,td2.td2_true_name
  52. from base_user bu
  53. left join biz_worker wk on wk.id=bu.biz_userid and bu.subsystem=1
  54. left join biz_trader td on td.id=bu.biz_userid and bu.subsystem=2
  55. left join biz_trader2 td2 on td.id=bu.biz_userid and bu.subsystem=3
  56. where bu.id=12
  57. ["42S22",1054,"Unknown column 'td2.td2_true_name' in 'field list'"]
  58. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/ZTest/action1.php]的[36]行 code[0] !
  59. 异常堆栈上下文:
  60. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  61. #1 {main}
  62. 数据库执行异常:Unknown column 'td2.td2_true_name' in 'field list'
  63. sql语句:select bu.*,wk.true_name,td.company_name,td2.td2_true_name
  64. from base_user bu
  65. left join biz_worker wk on wk.id=bu.biz_userid and bu.subsystem=1
  66. left join biz_trader td on td.id=bu.biz_userid and bu.subsystem=2
  67. left join biz_trader2 td2 on td.id=bu.biz_userid and bu.subsystem=3
  68. where bu.id=12
  69. ["42S22",1054,"Unknown column 'td2.td2_true_name' in 'field list'"]
  70. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  71. 异常堆栈上下文:
  72. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  73. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  74. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/ZTest/action1.php(20): pdo_fetch()
  75. #3 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  76. #4 {main}
  77. [上下文相关信息]:
  78. [WsAjaxPrj]=KLY
  79. [WsAjaxBiz]=ZTest
  80. [WsAjaxAction]=action1
  81. [USER]=nginxphp
  82. [HOME]=/home/nginxphp
  83. [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
  84. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  85. [HTTP_REFERER]=https://zpwebapi.kaidekuai.com/
  86. [HTTP_SEC_FETCH_DEST]=empty
  87. [HTTP_SEC_FETCH_MODE]=cors
  88. [HTTP_SEC_FETCH_SITE]=cross-site
  89. [HTTP_ORIGIN]=https://zpwebapi.kaidekuai.com
  90. [HTTP_SEC_CH_UA_PLATFORM]="Windows"
  91. [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36
  92. [HTTP_SEC_CH_UA_MOBILE]=?0
  93. [HTTP_CONTENT_TYPE]=text/json,charset=utf-8
  94. [HTTP_ACCEPT]=application/json, text/javascript, */*; q=0.01
  95. [HTTP_SEC_CH_UA]="Chromium";v="94", "Google Chrome";v="94", ";Not A Brand";v="99"
  96. [HTTP_CACHE_CONTROL]=no-cache
  97. [HTTP_PRAGMA]=no-cache
  98. [HTTP_CONTENT_LENGTH]=38
  99. [HTTP_CONNECTION]=keep-alive
  100. [HTTP_HOST]=api.kuailaiyou.top
  101. [REDIRECT_STATUS]=200
  102. [SERVER_NAME]=api.kuailaiyou.top
  103. [SERVER_PORT]=443
  104. [SERVER_ADDR]=172.18.217.149
  105. [REMOTE_PORT]=37089
  106. [REMOTE_ADDR]=60.24.227.178
  107. [SERVER_SOFTWARE]=nginx/1.20.1
  108. [GATEWAY_INTERFACE]=CGI/1.1
  109. [HTTPS]=on
  110. [REQUEST_SCHEME]=https
  111. [SERVER_PROTOCOL]=HTTP/1.1
  112. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  113. [DOCUMENT_URI]=/ajaxEntryCenter.php
  114. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  115. [SCRIPT_NAME]=/ajaxEntryCenter.php
  116. [CONTENT_LENGTH]=38
  117. [CONTENT_TYPE]=text/json,charset=utf-8
  118. [REQUEST_METHOD]=POST
  119. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  120. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  121. [FCGI_ROLE]=RESPONDER
  122. [PHP_SELF]=/ajaxEntryCenter.php
  123. [REQUEST_TIME_FLOAT]=1639126433.8128
  124. [REQUEST_TIME]=1639126433
  125. 16:54:22 [info]: 测试一下
  126. [上下文相关信息]:
  127. [WsAjaxPrj]=KLY
  128. [WsAjaxBiz]=ZTest
  129. [WsAjaxAction]=action1
  130. [USER]=nginxphp
  131. [HOME]=/home/nginxphp
  132. [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
  133. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  134. [HTTP_REFERER]=https://zpwebapi.kaidekuai.com/
  135. [HTTP_SEC_FETCH_DEST]=empty
  136. [HTTP_SEC_FETCH_MODE]=cors
  137. [HTTP_SEC_FETCH_SITE]=cross-site
  138. [HTTP_ORIGIN]=https://zpwebapi.kaidekuai.com
  139. [HTTP_SEC_CH_UA_PLATFORM]="Windows"
  140. [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36
  141. [HTTP_SEC_CH_UA_MOBILE]=?0
  142. [HTTP_CONTENT_TYPE]=text/json,charset=utf-8
  143. [HTTP_ACCEPT]=application/json, text/javascript, */*; q=0.01
  144. [HTTP_SEC_CH_UA]="Chromium";v="94", "Google Chrome";v="94", ";Not A Brand";v="99"
  145. [HTTP_CACHE_CONTROL]=no-cache
  146. [HTTP_PRAGMA]=no-cache
  147. [HTTP_CONTENT_LENGTH]=38
  148. [HTTP_CONNECTION]=keep-alive
  149. [HTTP_HOST]=api.kuailaiyou.top
  150. [REDIRECT_STATUS]=200
  151. [SERVER_NAME]=api.kuailaiyou.top
  152. [SERVER_PORT]=443
  153. [SERVER_ADDR]=172.18.217.149
  154. [REMOTE_PORT]=37089
  155. [REMOTE_ADDR]=60.24.227.178
  156. [SERVER_SOFTWARE]=nginx/1.20.1
  157. [GATEWAY_INTERFACE]=CGI/1.1
  158. [HTTPS]=on
  159. [REQUEST_SCHEME]=https
  160. [SERVER_PROTOCOL]=HTTP/1.1
  161. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  162. [DOCUMENT_URI]=/ajaxEntryCenter.php
  163. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  164. [SCRIPT_NAME]=/ajaxEntryCenter.php
  165. [CONTENT_LENGTH]=38
  166. [CONTENT_TYPE]=text/json,charset=utf-8
  167. [REQUEST_METHOD]=POST
  168. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  169. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  170. [FCGI_ROLE]=RESPONDER
  171. [PHP_SELF]=/ajaxEntryCenter.php
  172. [REQUEST_TIME_FLOAT]=1639126462.5393
  173. [REQUEST_TIME]=1639126462
  174. 16:55:39 [info]: 测试一下
  175. [上下文相关信息]:
  176. [WsAjaxPrj]=KLY
  177. [WsAjaxBiz]=ZTest
  178. [WsAjaxAction]=action1
  179. [USER]=nginxphp
  180. [HOME]=/home/nginxphp
  181. [HTTP_ACCEPT_LANGUAGE]=zh-CN,zh;q=0.9
  182. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  183. [HTTP_REFERER]=https://zpwebapi.kaidekuai.com/
  184. [HTTP_SEC_FETCH_DEST]=empty
  185. [HTTP_SEC_FETCH_MODE]=cors
  186. [HTTP_SEC_FETCH_SITE]=cross-site
  187. [HTTP_ORIGIN]=https://zpwebapi.kaidekuai.com
  188. [HTTP_SEC_CH_UA_PLATFORM]="Windows"
  189. [HTTP_USER_AGENT]=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36
  190. [HTTP_SEC_CH_UA_MOBILE]=?0
  191. [HTTP_CONTENT_TYPE]=text/json,charset=utf-8
  192. [HTTP_ACCEPT]=application/json, text/javascript, */*; q=0.01
  193. [HTTP_SEC_CH_UA]="Chromium";v="94", "Google Chrome";v="94", ";Not A Brand";v="99"
  194. [HTTP_CACHE_CONTROL]=no-cache
  195. [HTTP_PRAGMA]=no-cache
  196. [HTTP_CONTENT_LENGTH]=38
  197. [HTTP_CONNECTION]=keep-alive
  198. [HTTP_HOST]=api.kuailaiyou.top
  199. [REDIRECT_STATUS]=200
  200. [SERVER_NAME]=api.kuailaiyou.top
  201. [SERVER_PORT]=443
  202. [SERVER_ADDR]=172.18.217.149
  203. [REMOTE_PORT]=54465
  204. [REMOTE_ADDR]=60.24.227.178
  205. [SERVER_SOFTWARE]=nginx/1.20.1
  206. [GATEWAY_INTERFACE]=CGI/1.1
  207. [HTTPS]=on
  208. [REQUEST_SCHEME]=https
  209. [SERVER_PROTOCOL]=HTTP/1.1
  210. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  211. [DOCUMENT_URI]=/ajaxEntryCenter.php
  212. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  213. [SCRIPT_NAME]=/ajaxEntryCenter.php
  214. [CONTENT_LENGTH]=38
  215. [CONTENT_TYPE]=text/json,charset=utf-8
  216. [REQUEST_METHOD]=POST
  217. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=ZTest&WsAjaxAction=action1
  218. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  219. [FCGI_ROLE]=RESPONDER
  220. [PHP_SELF]=/ajaxEntryCenter.php
  221. [REQUEST_TIME_FLOAT]=1639126539.8721
  222. [REQUEST_TIME]=1639126539