AW: AW: [opencms-dev] OpenCms 6 beta 1 : BatchUpdateException in the importworkplace wizard
Michael Emmerich
m.emmerich at alkacon.com
Tue Feb 22 15:54:51 CET 2005
Xavier,
>Thanks for your answer. I cannot upgrade the database to mysql 4.1
>because the server is shared by another applications.My network
>administrator is not agree to update MySQL to the version 4.
>
>Why did the setup run successfully with OpenCms 6 alpha 3 ?
The reason why this did not take place in alpha 3 is quite simple:
Each time a resource is published, a backup version of it is written in the
backup tables. When the maximum number of backup version for each file (the
default for it is 10 versions) is reached, older versions are deleted.
In OpenCms 6 beta 1, there are several additional modules installed during
setup, much more then in alpha 3. After the installation of each module, the
new or updated files are published - and some resources are published more
than 10 times, so the backup table cleanup starts which will cause the
error.
A possible solution is: (in the opencms-system.xml)
1) Increase the number of backup versions:
<versionhistory enabled="true" count="10000"/>
(but then the problem would occur after one resource is published more than
10000 times)
or
2) Disable the backup versions completely:
<versionhistory enabled="false" count="10"/>
>I read in the forum that the import could work with MySQL 3.23.58 (see
>link below). Do you confirm this information?
>http://mail.opencms.org/pipermail/opencms-dev/2004q2/011735.html
As far as I know the statements for cleaning up the backup tables do not
work with MySql 3.x, but I have not tested all the 3.x versions of it.
So disabling the backup would be the only solution for MySql 3.x right now.
Or of course to modify the SQL-Statements which are responsible for the
cleanup.
Michael Emmerich
Alkacon Software - The OpenCms Experts
http://www.alkacon.com
>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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9377: >> at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9373: >> at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9372: >> at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9367: >> at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9366: >> at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9365: >> at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>8)
>9364: >> at
>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.
j
>ava:1068)
>9363: >> at
>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:2
9
>0)
>9362: >> at
>org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatemen
t
>.java:294)
>9361: >> at
>org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatemen
t
>.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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9349: > at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9345: > at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9344: > at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9339: > at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9338: > at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9337: > at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>8)
>9336: > at
>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.
j
>ava:1068)
>9335: > at
>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:2
9
>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:2
9
>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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9323: at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9319: at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9318: at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9313: at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9312: at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9311: at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>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:2
9
>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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9288: >> at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9284: >> at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9283: >> at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9278: >> at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9277: >> at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9276: >> at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>8)
>9275: >> at
>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.
j
>ava:1068)
>9274: >> at
>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:2
9
>0)
>9273: >> at
>org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatemen
t
>.java:294)
>9272: >> at
>org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatemen
t
>.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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9260: > at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9256: > at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9255: > at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9250: > at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9249: > at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9248: > at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>8)
>9247: > at
>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.
j
>ava:1068)
>9246: > at
>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:2
9
>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:2
9
>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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9234: at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9230: at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9229: at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9224: at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9223: at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9222: at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>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:2
9
>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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9207: >> at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9203: >> at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9202: >> at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9197: >> at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9196: >> at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9195: >> at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>8)
>9194: >> at
>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.
j
>ava:1068)
>9193: >> at
>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:2
9
>0)
>9192: >> at
>org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatemen
t
>.java:294)
>9191: >> at
>org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatemen
t
>.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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9179: > at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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:12
8
>4)
>9175: > at
>org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportM
a
>nager.java:401)
>9174: > at
>org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportE
x
>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:25
3
>9)
>9169: > at
>org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
>9168: > at
>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.jav
a
>:1368)
>9167: > at
>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:8
8
>8)
>9166: > at
>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.
j
>ava:1068)
>9165: > at
>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:2
9
>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:2
9
>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(CmsSetupWorkplaceImport
T
>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(DelegatingMethodAccessorImp
l
>.java:25)
>9153: at
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9
>)
>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 ?
>
>
>
More information about the opencms-dev
mailing list