Sākums Izpētīt Palīdzība
Pierakstīties
liuchao
/
hoppe
Vērot 1
Pievienot zvaigznīti 0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Koks: 11186cc114
Atzari Tagi
hoppe
/
log
/
jfinal-club.log

jfinal-club.log 13 KB
Vēsture Neapstrādāts

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147 
  1. 

  2. 2021-03-26 12:51:56
    3. 

  3. [ERROR]-[Thread: XNIO-1 task-4]-[com.jfinal.core.ActionHandler.handle()]: com.jfinal.club._admin.data.wxuser.AdminWxUserController.export() : /admin/wxuser/export?all=0&ids=1000
    4. 

  4. com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'null id in (1000) order by create_t',expect IDENTIFIER, actual IDENTIFIER id : select * from wx_user where nickname is not null id in (1000) order by create_time desc
    5. 

  5. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:690)
    6. 

  6. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:703)
    7. 

  7. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:710)
    8. 

  8. 	at com.jfinal.club._admin.data.wxuser.AdminWxUserController.export(AdminWxUserController.java:93)
    9. 

  9. 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    10. 

  10. 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    11. 

  11. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    12. 

  12. 	at java.lang.reflect.Method.invoke(Method.java:498)
    13. 

  13. 	at com.jfinal.aop.Invocation.invoke(Invocation.java:97)
    14. 

  14. 	at com.jfinal.club._admin.admin_interface.ContentPathInterface.intercept(ContentPathInterface.java:20)
    15. 

  15. 	at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
    16. 

  16. 	at com.jfinal.club._admin.admin_interface.AdminSessionInterface.intercept(AdminSessionInterface.java:40)
    17. 

  17. 	at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
    18. 

  18. 	at com.jfinal.core.ActionHandler.handle(ActionHandler.java:89)
    19. 

  19. 	at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:90)
    20. 

  20. 	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
    21. 

  21. 	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
    22. 

  22. 	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
    23. 

  23. 	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
    24. 

  24. 	at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
    25. 

  25. 	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
    26. 

  26. 	at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
    27. 

  27. 	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
    28. 

  28. 	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
    29. 

  29. 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    30. 

  30. 	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
    31. 

  31. 	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
    32. 

  32. 	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
    33. 

  33. 	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
    34. 

  34. 	at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
    35. 

  35. 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    36. 

  36. 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    37. 

  37. 	at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
    38. 

  38. 	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
    39. 

  39. 	at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
    40. 

  40. 	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
    41. 

  41. 	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
    42. 

  42. 	at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
    43. 

  43. 	at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
    44. 

  44. 	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
    45. 

  45. 	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
    46. 

  46. 	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
    47. 

  47. 	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
    48. 

  48. 	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
    49. 

  49. 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    50. 

  50. 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    51. 

  51. 	at java.lang.Thread.run(Thread.java:748)
    52. 

  52. Caused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'null id in (1000) order by create_t',expect IDENTIFIER, actual IDENTIFIER id : select * from wx_user where nickname is not null id in (1000) order by create_time desc
    53. 

  53. 	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:725)
    54. 

  54. 	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:253)
    55. 

  55. 	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
    56. 

  56. 	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)
    57. 

  57. 	at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:346)
    58. 

  58. 	at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
    59. 

  59. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    60. 

  60. 	at java.lang.reflect.Method.invoke(Method.java:498)
    61. 

  61. 	at com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:58)
    62. 

  62. 	at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source)
    63. 

  63. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:676)
    64. 

  64. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:688)
    65. 

  65. 	... 46 more
    66. 

  66. Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'null id in (1000) order by create_t',expect IDENTIFIER, actual IDENTIFIER id
    67. 

  67. 	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:239)
    68. 

  68. 	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:362)
    69. 

  69. 	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:79)
    70. 

  70. 	at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620)
    71. 

  71. 	at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574)
    72. 

  72. 	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:712)
    73. 

  73. 	... 57 more
    74. 

  74. 

  75. 2021-03-26 12:52:02
    76. 

  76. [ERROR]-[Thread: XNIO-1 task-2]-[com.jfinal.core.ActionHandler.handle()]: com.jfinal.club._admin.data.wxuser.AdminWxUserController.export() : /admin/wxuser/export?all=0&ids=1000
    77. 

  77. com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'null id in (1000) order by create_t',expect IDENTIFIER, actual IDENTIFIER id : select * from wx_user where nickname is not null id in (1000) order by create_time desc
    78. 

  78. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:690)
    79. 

  79. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:703)
    80. 

  80. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:710)
    81. 

  81. 	at com.jfinal.club._admin.data.wxuser.AdminWxUserController.export(AdminWxUserController.java:93)
    82. 

  82. 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    83. 

  83. 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    84. 

  84. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    85. 

  85. 	at java.lang.reflect.Method.invoke(Method.java:498)
    86. 

  86. 	at com.jfinal.aop.Invocation.invoke(Invocation.java:97)
    87. 

  87. 	at com.jfinal.club._admin.admin_interface.ContentPathInterface.intercept(ContentPathInterface.java:20)
    88. 

  88. 	at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
    89. 

  89. 	at com.jfinal.club._admin.admin_interface.AdminSessionInterface.intercept(AdminSessionInterface.java:40)
    90. 

  90. 	at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
    91. 

  91. 	at com.jfinal.core.ActionHandler.handle(ActionHandler.java:89)
    92. 

  92. 	at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:90)
    93. 

  93. 	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
    94. 

  94. 	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
    95. 

  95. 	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
    96. 

  96. 	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
    97. 

  97. 	at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
    98. 

  98. 	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
    99. 

  99. 	at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
    100. 

  100. 	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
    101. 

  101. 	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
    102. 

  102. 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    103. 

  103. 	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
    104. 

  104. 	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
    105. 

  105. 	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
    106. 

  106. 	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
    107. 

  107. 	at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
    108. 

  108. 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    109. 

  109. 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    110. 

  110. 	at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
    111. 

  111. 	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
    112. 

  112. 	at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
    113. 

  113. 	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
    114. 

  114. 	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
    115. 

  115. 	at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
    116. 

  116. 	at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
    117. 

  117. 	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
    118. 

  118. 	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
    119. 

  119. 	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
    120. 

  120. 	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
    121. 

  121. 	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
    122. 

  122. 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    123. 

  123. 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    124. 

  124. 	at java.lang.Thread.run(Thread.java:748)
    125. 

  125. Caused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'null id in (1000) order by create_t',expect IDENTIFIER, actual IDENTIFIER id : select * from wx_user where nickname is not null id in (1000) order by create_time desc
    126. 

  126. 	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:725)
    127. 

  127. 	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:253)
    128. 

  128. 	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
    129. 

  129. 	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)
    130. 

  130. 	at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:346)
    131. 

  131. 	at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
    132. 

  132. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    133. 

  133. 	at java.lang.reflect.Method.invoke(Method.java:498)
    134. 

  134. 	at com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:58)
    135. 

  135. 	at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source)
    136. 

  136. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:676)
    137. 

  137. 	at com.jfinal.plugin.activerecord.Model.find(Model.java:688)
    138. 

  138. 	... 46 more
    139. 

  139. Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'null id in (1000) order by create_t',expect IDENTIFIER, actual IDENTIFIER id
    140. 

  140. 	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:239)
    141. 

  141. 	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:362)
    142. 

  142. 	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:79)
    143. 

  143. 	at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620)
    144. 

  144. 	at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574)
    145. 

  145. 	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:712)
    146. 

  146. 	... 57 more
    147. 

  147.