forum.bitel.ru http://forum.bitel.ru/ |
|
Ошибка при редактировании шаблона договоров http://forum.bitel.ru/viewtopic.php?f=22&t=13518 |
Страница 1 из 1 |
Автор: | zavndw [ 11 дек 2019, 01:17 ] |
Заголовок сообщения: | Ошибка при редактировании шаблона договоров |
При редактировании шаблона договора, выпадает ошибка Цитата: Сервер: вер. 7.1.1158 / 19.11.2019 23:33:04 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_221 bill: вер. 7.1.306 / 19.11.2019 23:33:35 card: вер. 7.1.201 / 12.09.2019 01:29:42 cerbercrypt: вер. 7.1.207 / 31.07.2019 19:46:34 dba: вер. 7.1.152 / 06.02.2019 19:12:00 email: вер. 7.1.166 / 06.02.2019 19:12:09 inet: вер. 7.1.745 / 26.11.2019 17:45:43 mps: вер. 7.1.189 / 13.08.2019 15:40:49 npay: вер. 7.1.178 / 11.07.2019 13:49:33 phone: вер. 7.1.260 / 30.10.2019 17:36:59 reports: вер. 7.1.207 / 03.10.2019 21:24:41 rscm: вер. 7.1.166 / 06.02.2019 19:13:32 ru.bitel.bgbilling.plugins.bonus: вер. 7.1.102 / 06.02.2019 19:11:27 ru.bitel.bgbilling.plugins.cashcheck: вер. 7.1.154 / 26.11.2019 20:57:38 ru.bitel.bgbilling.plugins.dispatch: вер. 7.1.40 / 18.03.2019 21:32:51 ru.bitel.bgbilling.plugins.documents: вер. 7.1.142 / 12.11.2019 19:09:07 ru.bitel.bgbilling.plugins.helpdesk: вер. 7.1.175 / 15.11.2019 04:26:44 sberbank: вер. 7.1.56 / 31.10.2019 18:00:22 trayinfo: вер. 7.1.160 / 06.02.2019 19:13:49 tv: вер. 7.1.240 / 25.11.2019 11:07:52 Код: 12-11/05:37:38 DEBUG [http-nio-0.0.0.0-8080-exec-30] ContractPatternManager - com.mysql.cj.jdbc.ClientPreparedStatement: UPDATE contract_pattern SET title='СТС', closesumma=0.0, tpid='133', groups=16384, mode=0, pgid=1, fc=0, dtl=0, tgid='', scrid='', name_pattern='', data=x'3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E3C64617461207765624D656E7549643D222D31223E0A3C6D6F64756C65732F3E0A3C706C7567696E733E0A3C68656C704465736B206D6F64653D226F6666222073656C65637447726F757049643D2231222F3E0A3C2F706C7567696E733E3C67656E6572616C2064746C3D223022207374617475733D2230222F3E3C2F646174613E', patid=1, domainId=0 WHERE id=53
12-11/05:37:38 ERROR [http-nio-0.0.0.0-8080-exec-30] ContractPatternManager - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups=16384, mode=0, pgid=1, fc=0, dtl=0, tgid='', scrid='', name_pattern='', d' at line 1 java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups=16384, mode=0, pgid=1, fc=0, dtl=0, tgid='', scrid='', name_pattern='', d' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1340) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at bitel.billing.server.contract.bean.ContractPatternManager.updateContaractPattern(ContractPatternManager.java:219) at bitel.billing.server.contract.action.ActionUpdateContractPattern.doAction(ActionUpdateContractPattern.java:92) at bitel.billing.server.Executer.doModule(SourceFile:613) at bitel.billing.server.Executer$1.run(SourceFile:211) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at bitel.billing.server.Executer.doPost(SourceFile:205) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 12-11/05:37:38 ERROR [http-nio-0.0.0.0-8080-exec-30] CommonExecutor - java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups=16384, mode=0, pgid=1, fc=0, dtl=0, tgid='', scrid='', name_pattern='', d' at line 1 java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups=16384, mode=0, pgid=1, fc=0, dtl=0, tgid='', scrid='', name_pattern='', d' at line 1 at bitel.billing.server.contract.bean.ContractPatternManager.updateContaractPattern(ContractPatternManager.java:242) at bitel.billing.server.contract.action.ActionUpdateContractPattern.doAction(ActionUpdateContractPattern.java:92) at bitel.billing.server.Executer.doModule(SourceFile:613) at bitel.billing.server.Executer$1.run(SourceFile:211) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at bitel.billing.server.Executer.doPost(SourceFile:205) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups=16384, mode=0, pgid=1, fc=0, dtl=0, tgid='', scrid='', name_pattern='', d' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1340) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at bitel.billing.server.contract.bean.ContractPatternManager.updateContaractPattern(ContractPatternManager.java:219) ... 30 more |
Автор: | skn [ 11 дек 2019, 05:34 ] |
Заголовок сообщения: | Re: Ошибка при редактировании шаблона договоров |
а вот этот запрос если в sql редакторе выполнить "UPDATE contract_pattern SET title='СТС', closesumma=0.0, tpid='133', groups=16384, mode=0, pgid=1, fc=0, dtl=0, tgid='', scrid='', name_pattern='', data=x'3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E3C64617461207765624D656E7549643D222D31223E0A3C6D6F64756C65732F3E0A3C706C7567696E733E0A3C68656C704465736B206D6F64653D226F6666222073656C65637447726F757049643D2231222F3E0A3C2F706C7567696E733E3C67656E6572616C2064746C3D223022207374617475733D2230222F3E3C2F646174613E', patid=1, domainId=0 WHERE id=53" я в нем ни чего криминального не вижу, и меня он отработал.... |
Автор: | zavndw [ 11 дек 2019, 11:27 ] |
Заголовок сообщения: | Re: Ошибка при редактировании шаблона договоров |
если выполнить выдает такую же ошибку, сразу проверил. Куда копать?) |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |