AW: AW: [opencms-dev] OpenCms 6 beta 1 : BatchUpdateException in the importworkplace wizard
Xavier Ottolini
xavier.ottolini at adelis.com
Fri Feb 25 09:21:33 CET 2005
Hi,
After disabling the babkup history, the setup ran successfully. Thanks
Michael. I have got the feeling that I am not alone in the forum to get
the same problem with MySQL 3.23.
Could you update the "install.html" to avoid other OpenCms users to get
the same problem ?
Regards,
Xavier
Michael Emmerich a écrit :
>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