Некоторые договора, даже недавно удаленные, не восстанавливаются. Проблема при восстановлении абонплаты:
Цитата:
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.