forum.bitel.ru
http://forum.bitel.ru/

Ошибка при восстановлении договора из архива.
http://forum.bitel.ru/viewtopic.php?f=22&t=4203		 Страница 1 из 1
Автор:  Cromeshnic [ 24 июн 2010, 09:49 ]
Заголовок сообщения:  Ошибка при восстановлении договора из архива.
Некоторые договора, даже недавно удаленные, не восстанавливаются. Проблема при восстановлении абонплаты:

Цитата:
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 ') VALUES('106991' ,'1' ,'auto' ,'0' ,'2010-04-01' ,'0' ,'0' ,'782684' ,'0' ,'17' at line 1
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1313)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1232)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at bitel.billing.server.contract.ContractRemover.insertElementToBase(ContractRemover.java:526)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at bitel.billing.server.contract.ContractRemover.restoreContract(ContractRemover.java:425)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at bitel.billing.server.contract.action.ActionArchiveRestore.doAction(ActionArchiveRestore.java:18)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at bitel.billing.server.Executer.doModule(Unknown Source)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at bitel.billing.server.Executer.doPost(Unknown Source)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
server 06-24/12:36:34 ERROR [http-8080-7] LoggingPrintStream - at java.lang.Thread.run(Thread.java:619)
server 06-24/12:36:34 ERROR [http-8080-7] server - Exception in Executer (ActionArchiveRestore)


Строка из xml архива:
Код:
   <npay_service_object_16 cid="106991" col="1" comment="auto" csid="0"
        date1="2010-04-01" eid="0" emid="0" id="782684" oid="0"
        sid="178" title="Некая услуга"/>


My guess is: в таблице нет поля title, которое есть в xml.
Автор:  Cromeshnic [ 24 июн 2010, 10:21 ]
Заголовок сообщения:  Re: Ошибка при восстановлении договора из архива.
Также при вставке следующего тега:

Код:
    <user_login_4 cid="106760"
        comment="Региональное агентство 'xxxxxx xxxxxx', ООО"
        date1="2006-01-01" id="99550" login="554" object_id="0"
        pswd="pswd" realm_group="" rp_mode="0" session="2" status="0"/>


получаем:

Цитата:
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'xxxxxx xxxxxx', ÎÎÎ' ,'2006-01-01' ,'99550' ,'554' ,'0' ,'pswd' ,'' ,'0' ,'' at line 1
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1313)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1232)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at bitel.billing.server.contract.ContractRemover.insertElementToBase(ContractRemover.java:526)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at bitel.billing.server.contract.ContractRemover.restoreContract(ContractRemover.java:425)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at bitel.billing.server.contract.action.ActionArchiveRestore.doAction(ActionArchiveRestore.java:18)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at bitel.billing.server.Executer.doModule(Unknown Source)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at bitel.billing.server.Executer.doPost(Unknown Source)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
server 06-24/13:16:20 ERROR [http-8080-3] LoggingPrintStream - at java.lang.Thread.run(Thread.java:619)


Очевидно, в методе insertElementToBase не экранируются спецсимволы при обработке значений xml-атрибутов.
Автор:  stark [ 24 июн 2010, 12:48 ]
Заголовок сообщения:  Re: Ошибка при восстановлении договора из архива.
версия биллинга какая ?
Автор:  Cromeshnic [ 24 июн 2010, 13:15 ]
Заголовок сообщения:  Re: Ошибка при восстановлении договора из архива.
v5.0 сборка 748
Автор:  skyb [ 24 июн 2010, 14:39 ]
Заголовок сообщения:  Re: Ошибка при восстановлении договора из архива.
а у меня посих пор при восстановлении из архива не восстанавливается абонплата :(
Автор:  stark [ 30 июн 2010, 10:17 ]
Заголовок сообщения:  Re: Ошибка при восстановлении договора из архива.
исправлено . обновление выложено для версий >=4.6
Автор:  skyb [ 30 июн 2010, 10:18 ]
Заголовок сообщения:  Re: Ошибка при восстановлении договора из архива.
клева, обновляюсь :)
Автор:  Cromeshnic [ 30 июн 2010, 11:27 ]
Заголовок сообщения:  Re: Ошибка при восстановлении договора из архива.
:D
Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/