[opencms-dev] OpenCms 6 beta 1 : BatchUpdateException in the import workplace wizard
Xavier Ottolini
xavier.ottolini at adelis.com
Tue Feb 22 14:16:21 CET 2005
Hi all,
I just tried so setup OpenCms 6 alpha 1. I already set up OpenCms 6 apha
3 on the same server sucessfully.
I use :
Tomcat 4.10
JRE 1.4.2_05
MySql 3.23
Apache 1.3 (to avoid the 8080)
**In the step 5 of the installation intructions, I launched the setup
wizard.
On the screen 4, I selected the database MySQL 3.2-4.0
Setup Connection : user root
OpenCms Connection : user root
Connection String : jdbc:mysql://myhost.mydomain:3306/
Database : myproject
Create database
On the screen 5, I got the message : OpenCms Setup Wizard - Create
database & tables
Creating database ...
Database has been successfully created.
Creating tables ...
Tables have been successfully created.
On the screen 6, all the modules were selected
I began to read exception in the status window between the line 5000 and
6000 (unfortunately, I could not copy them).
Then
I got the following messages during the setup.
Regards
9393: ( 3 ) Indexing file simpleexample.xsd ... o.k.
9392: ( 2 ) Indexing file simplecontentdetails.jsp ... skipped
9391: ( 1 ) Indexing file simplecontent.html ... o.k.
9390: Indexing folder
/sites/default/alkacon-documentation/documentation-xmlcontent/simpleexample/
9389: ------ Indexing ------ Online project (VFS)------ ...
9388: Admin at Offline>updateIndex
9387: Admin at Offline># Build search indexes
9386: Admin at Offline>
9389: ------ Indexing ------ Online project (VFS)------ ...
9388: Admin at Offline>updateIndex
9387: Admin at Offline># Build search indexes
9386: Admin at Offline>
9385:
9384: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9383: >> at org.opencms.main.CmsShell.start(CmsShell.java:491)
9382: >> at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9381: >> at
org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9380: >> at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9379: >> at java.lang.reflect.Method.invoke(Method.java:324)
9378: >> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9377: >> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9376: >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
9375: >> at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9374: >> at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9373: >> at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9372: >> at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9371: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9370: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9369: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9368: >> at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9367: >> at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9366: >> at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9365: >> at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9364: >> at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1068)
9363: >> at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290)
9362: >> at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
9361: >> at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
9360: >> at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
9359: >>java.sql.BatchUpdateException: Syntax error or access
violation message from server: "You have an error in your SQL syntax
near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9358: >>Root cause:
9357: >>-----------
9356: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9355: > at org.opencms.main.CmsShell.start(CmsShell.java:491)
9354: > at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9353: > at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9352: > at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9351: > at java.lang.reflect.Method.invoke(Method.java:324)
9350: > at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9349: > at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9348: > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9347: > at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9346: > at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9345: > at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9344: > at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9343: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9342: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9341: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9340: > at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9339: > at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9338: > at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9337: > at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9336: > at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1068)
9335: > at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:295)
9334: >Root cause was: java.sql.BatchUpdateException: Syntax error or
access violation message from server: "You have an error in your SQL
syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9333: >org.opencms.db.CmsSqlException:
[org.opencms.db.mysql.CmsBackupDriver] where:
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290),
why: java.sql.BatchUpdateException: Syntax error or access violation
message from server: "You have an error in your SQL syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9332: >Root cause:
9331: >-----------
9330: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9329: at org.opencms.main.CmsShell.start(CmsShell.java:491)
9328: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9327: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9326: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9325: at java.lang.reflect.Method.invoke(Method.java:324)
9324: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9323: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9322: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9321: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9320: at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9319: at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9318: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9317: at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9316: at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9315: at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9314: at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9313: at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9312: at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9311: at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9310: at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1074)
9309: Root cause was: java.sql.BatchUpdateException: Syntax error or
access violation message from server: "You have an error in your SQL
syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9308: Root cause was: org.opencms.db.CmsSqlException:
[org.opencms.db.mysql.CmsBackupDriver] where:
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290),
why: java.sql.BatchUpdateException: Syntax error or access violation
message from server: "You have an error in your SQL syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9307: org.opencms.db.CmsDataAccessException: CmsException ID: 300
[Code 300 - Data Access Exception]
9306: ------ ... finished writing the export points
9305: Writing export point
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/opencms/frontend/templateone/xmlcontentdemo/
... o.k.
9304: Writing export point
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/opencms/frontend/templateone/
... o.k.
9303: Writing export point
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/opencms/frontend/
... o.k.
9302: Writing export point
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/opencms/
... o.k.
9301: Writing export point
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/
... o.k.
9300: Writing export point
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/
... o.k.
9299: Writing export point /system/workplace/resources/filetypes/
... o.k.
9298: ------ Writing export points ...
9297: Statistics: published files: 1, published folders: 19, deleted
folders: 0, duration: 00:00:17
9296:
9295: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9294: >> at org.opencms.main.CmsShell.start(CmsShell.java:491)
9293: >> at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9292: >> at
org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9291: >> at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9290: >> at java.lang.reflect.Method.invoke(Method.java:324)
9289: >> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9288: >> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9287: >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
9286: >> at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9285: >> at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9284: >> at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9283: >> at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9282: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9281: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9280: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9279: >> at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9278: >> at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9277: >> at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9276: >> at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9275: >> at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1068)
9274: >> at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290)
9273: >> at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
9272: >> at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
9271: >> at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
9270: >>java.sql.BatchUpdateException: Syntax error or access
violation message from server: "You have an error in your SQL syntax
near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9269: >>Root cause:
9268: >>-----------
9267: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9266: > at org.opencms.main.CmsShell.start(CmsShell.java:491)
9265: > at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9264: > at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9263: > at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9262: > at java.lang.reflect.Method.invoke(Method.java:324)
9261: > at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9260: > at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9259: > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9258: > at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9257: > at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9256: > at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9255: > at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9254: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9253: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9252: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9251: > at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9250: > at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9249: > at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9248: > at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9247: > at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1068)
9246: > at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:295)
9245: >Root cause was: java.sql.BatchUpdateException: Syntax error or
access violation message from server: "You have an error in your SQL
syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9244: >org.opencms.db.CmsSqlException:
[org.opencms.db.mysql.CmsBackupDriver] where:
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290),
why: java.sql.BatchUpdateException: Syntax error or access violation
message from server: "You have an error in your SQL syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9243: >Root cause:
9242: >-----------
9241: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9240: at org.opencms.main.CmsShell.start(CmsShell.java:491)
9239: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9238: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9237: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9236: at java.lang.reflect.Method.invoke(Method.java:324)
9235: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9234: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9233: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9232: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9231: at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9230: at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9229: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9228: at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9227: at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9226: at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9225: at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9224: at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9223: at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9222: at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9221: at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1074)
9220: Root cause was: java.sql.BatchUpdateException: Syntax error or
access violation message from server: "You have an error in your SQL
syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9219: Root cause was: org.opencms.db.CmsSqlException:
[org.opencms.db.mysql.CmsBackupDriver] where:
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290),
why: java.sql.BatchUpdateException: Syntax error or access violation
message from server: "You have an error in your SQL syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9218: org.opencms.db.CmsDataAccessException: CmsException ID: 300
[Code 300 - Data Access Exception]
9217: !!! Exception org.opencms.db.CmsDataAccessException:
CmsException ID: 300
9216: Error publishing file
/sites/default/alkacon-documentation/documentation-xmlcontent/index.html
9215:
9214: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9213: >> at org.opencms.main.CmsShell.start(CmsShell.java:491)
9212: >> at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9211: >> at
org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9210: >> at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9209: >> at java.lang.reflect.Method.invoke(Method.java:324)
9208: >> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9207: >> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9206: >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
9205: >> at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9204: >> at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9203: >> at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9202: >> at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9201: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9200: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9199: >> at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9198: >> at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9197: >> at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9196: >> at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9195: >> at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9194: >> at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1068)
9193: >> at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290)
9192: >> at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
9191: >> at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
9190: >> at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
9189: >>java.sql.BatchUpdateException: Syntax error or access
violation message from server: "You have an error in your SQL syntax
near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9188: >>Root cause:
9187: >>-----------
9186: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9185: > at org.opencms.main.CmsShell.start(CmsShell.java:491)
9184: > at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9183: > at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9182: > at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9181: > at java.lang.reflect.Method.invoke(Method.java:324)
9180: > at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9179: > at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9178: > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9177: > at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9176: > at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1284)
9175: > at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:401)
9174: > at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:308)
9173: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9172: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9171: > at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9170: > at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2539)
9169: > at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9168: > at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1368)
9167: > at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:888)
9166: > at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1068)
9165: > at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:295)
9164: >Root cause was: java.sql.BatchUpdateException: Syntax error or
access violation message from server: "You have an error in your SQL
syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1"
9163: >org.opencms.db.CmsSqlException:
[org.opencms.db.mysql.CmsBackupDriver] where:
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:290),
why: java.sql.BatchUpdateException: Syntax error or access violation
message from server: "You have an error in your SQL syntax near
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.*
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9162: >Root cause:
9161: >-----------
9160: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
9159: at org.opencms.main.CmsShell.start(CmsShell.java:491)
9158: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9157: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9156: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9155: at java.lang.reflect.Method.invoke(Method.java:324)
9154: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
9153: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
9152: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9151: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:749)
9150: at org.opencms.setup.CmsSetupBean.import
Can someone help me ?
--
Xavier Ottolini
Développeur multimédia
Adelis
37, rue d'Engwiller
67350 La Walck
Téléphone : +33 (0) 3 88 72 29 10
Télécopie : +33 (0) 3 88 72 29 19
http://www.adelis.com
More information about the opencms-dev
mailing list