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/