AW: [opencms-dev] OpenCms 6 beta 1 : BatchUpdateException in the importworkplace wizard
Michael Emmerich
m.emmerich at alkacon.com
Tue Feb 22 14:49:35 CET 2005
Xavier,
the problem is caused by MySql 3.x when removing entries of the backup
tables during publishing.
You should upgrade to MySql 4 or disable the use of the resource history in
the opencms-system.xml
Michael Emmerich
Alkacon Software - The OpenCms Experts
http://www.alkacon.com
-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Xavier Ottolini
Gesendet: Dienstag, 22. Februar 2005 14:16
An: opencms-dev
Betreff: [opencms-dev] OpenCms 6 beta 1 : BatchUpdateException in the
importworkplace wizard
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9373: >> at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9372: >> at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9364: >> at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9363: >> at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0)
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9345: > at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9344: > at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9336: > at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9335: > at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
5)
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:29
0),
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9319: at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9318: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9310: at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava: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:29
0),
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9284: >> at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9283: >> at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9275: >> at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9274: >> at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0)
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9256: > at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9255: > at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9247: > at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9246: > at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
5)
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:29
0),
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9230: at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9229: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9221: at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava: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:29
0),
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9203: >> at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9202: >> at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9194: >> at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9193: >> at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0)
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(CmsSetupWorkplaceImportT
hread.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:128
4)
9175: > at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9174: > at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.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:253
9)
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:88
8)
9166: > at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9165: > at
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
5)
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:29
0),
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(CmsSetupWorkplaceImportT
hread.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
_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev
More information about the opencms-dev
mailing list