AW: AW: [opencms-dev] OpenCms 6 beta 1 : BatchUpdateExceptionin the importworkplace wizard

[Alexander Kandzior]

Actually we already did update the SQL statements (in the CVS HEAD) so the
history should now run on MySQL 3.2.x without problems again...

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Xavier Ottolini
> Sent: Friday, February 25, 2005 9:22 AM
> To: Michael Emmerich
> Cc: 'The OpenCms mailing list'
> Subject: Re: AW: AW: [opencms-dev] OpenCms 6 beta 1 : 
> BatchUpdateExceptionin the importworkplace wizard
> 
> 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-xmlconten
> t/simpleex
> >>ample
> >>    
> >>
> >/
> >  
> >
> >>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(CmsSetup
> WorkplaceI
> >>mport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9379:    >>    at java.lang.reflect.Method.invoke(Method.java:324)
> >>9378:    >>    at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccess
> >>orImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9377:    >>    at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.j
> >>ava:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9376:    >>    at 
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
> >>Method)
> >>9375:    >>    at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean
> >>.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9374:    >>    at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.ja
> >>va:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9373:    >>    at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportEx
> >>portM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9372:    >>    at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleIm
> >>portE
> >>    
> >>
> >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(CmsSecurity
> Manager.ja
> >>va:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9367:    >>    at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9366:    >>    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDrive
> >>r.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9365:    >>    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.j
> >>ava:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9364:    >>    at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >j
> >  
> >
> >>ava:1068)
> >>9363:    >>    at 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.j
> >>ava:2
> >>    
> >>
> >9
> >  
> >
> >>0)
> >>9362:    >>    at 
> >>org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del
> egatingSta
> >>temen
> >>    
> >>
> >t
> >  
> >
> >>.java:294)
> >>9361:    >>    at 
> >>org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del
> egatingSta
> >>temen
> >>    
> >>
> >t
> >  
> >
> >>.java:294)
> >>9360:    >>    at 
> >>com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatem
> ent.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(CmsSetup
> WorkplaceI
> >>mport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9351:    >    at java.lang.reflect.Method.invoke(Method.java:324)
> >>9350:    >    at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccess
> >>orImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9349:    >    at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.j
> >>ava:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9348:    >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> >>    
> >>
> >Method)
> >  
> >
> >>9347:    >    at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean
> >>.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9346:    >    at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.ja
> >>va:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9345:    >    at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportEx
> >>portM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9344:    >    at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleIm
> >>portE
> >>    
> >>
> >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(CmsSecurity
> Manager.ja
> >>va:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9339:    >    at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9338:    >    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDrive
> >>r.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9337:    >    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.j
> >>ava:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9336:    >    at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >j
> >  
> >
> >>ava:1068)
> >>9335:    >    at 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.j
> >>ava: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(CmsBack
> upDriver.j
> >>ava: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(CmsSetup
> WorkplaceImport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9325:        at java.lang.reflect.Method.invoke(Method.java:324)
> >>9324:        at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9323:        at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9322:        at 
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >>9321:        at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9320:        at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.java:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9319:        at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportExportM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9318:        at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleImportE
> >>    
> >>
> >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(CmsSecurity
> Manager.java:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9313:        at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9312:        at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDriver.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9311:        at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.java:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9310:        at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >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_CO
> NTENTS.* 
> >>    
> >>
> >>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(CmsBack
> upDriver.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_CO
> NTENTS.* 
> >>    
> >>
> >>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.xmlcontentd
> emo/classes/org
> >>    
> >>
> >/
> >  
> >
> >>opencms/frontend/templateone/xmlcontentdemo/ 
> >>...  o.k.
> >>9304:    Writing export point 
> >>/system/modules/org.opencms.frontend.templateone.xmlcontentd
> emo/classes/org
> >>    
> >>
> >/
> >  
> >
> >>opencms/frontend/templateone/ 
> >>...  o.k.
> >>9303:    Writing export point 
> >>/system/modules/org.opencms.frontend.templateone.xmlcontentd
> emo/classes/org
> >>    
> >>
> >/
> >  
> >
> >>opencms/frontend/ 
> >>...  o.k.
> >>9302:    Writing export point 
> >>/system/modules/org.opencms.frontend.templateone.xmlcontentd
> emo/classes/org
> >>    
> >>
> >/
> >  
> >
> >>opencms/ 
> >>...  o.k.
> >>9301:    Writing export point 
> >>/system/modules/org.opencms.frontend.templateone.xmlcontentd
> emo/classes/org
> >>    
> >>
> >/
> >  
> >
> >>...  o.k.
> >>9300:    Writing export point 
> >>/system/modules/org.opencms.frontend.templateone.xmlcontentd
> emo/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(CmsSetup
> WorkplaceImport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9290:    >>    at java.lang.reflect.Method.invoke(Method.java:324)
> >>9289:    >>    at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9288:    >>    at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9287:    >>    at 
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
> >>Method)
> >>9286:    >>    at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9285:    >>    at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.java:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9284:    >>    at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportExportM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9283:    >>    at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleImportE
> >>    
> >>
> >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(CmsSecurity
> Manager.java:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9278:    >>    at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9277:    >>    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDriver.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9276:    >>    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.java:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9275:    >>    at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >j
> >  
> >
> >>ava:1068)
> >>9274:    >>    at 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.java:2
> >>    
> >>
> >9
> >  
> >
> >>0)
> >>9273:    >>    at 
> >>org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del
> egatingStatemen
> >>    
> >>
> >t
> >  
> >
> >>.java:294)
> >>9272:    >>    at 
> >>org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del
> egatingStatemen
> >>    
> >>
> >t
> >  
> >
> >>.java:294)
> >>9271:    >>    at 
> >>com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatem
> ent.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_CO
> NTENTS.* 
> >>    
> >>
> >>FROM CMS_BAC' at line 1"
> >  
> >
> >>9269:    >>Root cause:
> >>9268:    >>-----------
> >>9267:    >    at 
> >>org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetup
> WorkplaceImport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9262:    >    at java.lang.reflect.Method.invoke(Method.java:324)
> >>9261:    >    at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9260:    >    at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9259:    >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> >>    
> >>
> >Method)
> >  
> >
> >>9258:    >    at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9257:    >    at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.java:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9256:    >    at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportExportM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9255:    >    at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleImportE
> >>    
> >>
> >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(CmsSecurity
> Manager.java:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9250:    >    at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9249:    >    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDriver.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9248:    >    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.java:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9247:    >    at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >j
> >  
> >
> >>ava:1068)
> >>9246:    >    at 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.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_CO
> NTENTS.* 
> >>    
> >>
> >>FROM CMS_BAC' at line 1"
> >  
> >
> >>9244:    >org.opencms.db.CmsSqlException: 
> >>[org.opencms.db.mysql.CmsBackupDriver] where: 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.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_CO
> NTENTS.* 
> >>    
> >>
> >>FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
> >  
> >
> >>9243:    >Root cause:
> >>9242:    >-----------
> >>9241:        at 
> >>org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetup
> WorkplaceImport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9236:        at java.lang.reflect.Method.invoke(Method.java:324)
> >>9235:        at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9234:        at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9233:        at 
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >>9232:        at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9231:        at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.java:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9230:        at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportExportM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9229:        at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleImportE
> >>    
> >>
> >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(CmsSecurity
> Manager.java:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9224:        at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9223:        at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDriver.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9222:        at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.java:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9221:        at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >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_CO
> NTENTS.* 
> >>    
> >>
> >>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(CmsBack
> upDriver.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_CO
> NTENTS.* 
> >>    
> >>
> >>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-xmlconten
> t/index.html
> >>9215:   
> >>9214:    >>    at 
> >>org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetup
> WorkplaceImport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9209:    >>    at java.lang.reflect.Method.invoke(Method.java:324)
> >>9208:    >>    at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9207:    >>    at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9206:    >>    at 
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
> >>Method)
> >>9205:    >>    at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9204:    >>    at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.java:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9203:    >>    at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportExportM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9202:    >>    at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleImportE
> >>    
> >>
> >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(CmsSecurity
> Manager.java:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9197:    >>    at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9196:    >>    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDriver.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9195:    >>    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.java:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9194:    >>    at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >j
> >  
> >
> >>ava:1068)
> >>9193:    >>    at 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.java:2
> >>    
> >>
> >9
> >  
> >
> >>0)
> >>9192:    >>    at 
> >>org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del
> egatingStatemen
> >>    
> >>
> >t
> >  
> >
> >>.java:294)
> >>9191:    >>    at 
> >>org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del
> egatingStatemen
> >>    
> >>
> >t
> >  
> >
> >>.java:294)
> >>9190:    >>    at 
> >>com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatem
> ent.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_CO
> NTENTS.* 
> >>    
> >>
> >>FROM CMS_BAC' at line 1"
> >  
> >
> >>9188:    >>Root cause:
> >>9187:    >>-----------
> >>9186:    >    at 
> >>org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetup
> WorkplaceImport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9181:    >    at java.lang.reflect.Method.invoke(Method.java:324)
> >>9180:    >    at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9179:    >    at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9178:    >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> >>    
> >>
> >Method)
> >  
> >
> >>9177:    >    at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9176:    >    at 
> >>org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSe
> tupBean.java:12
> >>    
> >>
> >8
> >  
> >
> >>4)
> >>9175:    >    at 
> >>org.opencms.importexport.CmsImportExportManager.importData(C
> msImportExportM
> >>    
> >>
> >a
> >  
> >
> >>nager.java:401)
> >>9174:    >    at 
> >>org.opencms.module.CmsModuleImportExportHandler.importData(C
> msModuleImportE
> >>    
> >>
> >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(CmsSecurity
> Manager.java:25
> >>    
> >>
> >3
> >  
> >
> >>9)
> >>9169:    >    at 
> >>org.opencms.db.CmsDriverManager.publishProject(CmsDriverMana
> ger.java:4665)
> >>9168:    >    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishProject(CmsPr
> ojectDriver.jav
> >>    
> >>
> >a
> >  
> >
> >>:1368)
> >>9167:    >    at 
> >>org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProje
> ctDriver.java:8
> >>    
> >>
> >8
> >  
> >
> >>8)
> >>9166:    >    at 
> >>org.opencms.db.generic.CmsBackupDriver.writeBackupResource(C
> msBackupDriver.
> >>    
> >>
> >j
> >  
> >
> >>ava:1068)
> >>9165:    >    at 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.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_CO
> NTENTS.* 
> >>    
> >>
> >>FROM CMS_BAC' at line 1"
> >  
> >
> >>9163:    >org.opencms.db.CmsSqlException: 
> >>[org.opencms.db.mysql.CmsBackupDriver] where: 
> >>org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBack
> upDriver.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_CO
> NTENTS.* 
> >>    
> >>
> >>FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
> >  
> >
> >>9162:    >Root cause:
> >>9161:    >-----------
> >>9160:        at 
> >>org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetup
> WorkplaceImport
> >>    
> >>
> >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(Cms
> Shell.java:237)
> >>9155:        at java.lang.reflect.Method.invoke(Method.java:324)
> >>9154:        at 
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImp
> >>    
> >>
> >l
> >  
> >
> >>.java:25)
> >>9153:        at 
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:3
> >>    
> >>
> >9
> >  
> >
> >>)
> >>9152:        at 
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >>9151:        at 
> >>org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(Cm
> sSetupBean.java
> >>    
> >>
> >:
> >  
> >
> >>749)
> >>9150:        at org.opencms.setup.CmsSetupBean.import
> >>
> >>Can someone help me ?
> >>
> >> 
> >>
> >>    
> >>
> >
> >  
> >
> 
> 
> _______________________________________________
> 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
> 
>