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

Michael Emmerich m.emmerich at alkacon.com
Tue Feb 22 14:49:35 CET 2005


Xavier,

the problem is caused by MySql 3.x when removing entries of the backup
tables during publishing.

You should upgrade to MySql 4 or disable the use of the resource history in
the opencms-system.xml

Michael Emmerich
Alkacon Software - The OpenCms Experts
http://www.alkacon.com


-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Xavier Ottolini
Gesendet: Dienstag, 22. Februar 2005 14:16
An: opencms-dev
Betreff: [opencms-dev] OpenCms 6 beta 1 : BatchUpdateException in the
importworkplace wizard

Hi all,

I just tried so setup OpenCms 6 alpha 1. I already set up OpenCms 6 apha 
3 on the same server sucessfully.

I use :
Tomcat 4.10
JRE 1.4.2_05
MySql 3.23
Apache 1.3 (to avoid the 8080)


**In the step 5 of the installation intructions, I launched the setup 
wizard.
On the screen 4, I selected the database MySQL 3.2-4.0
Setup Connection : user root
OpenCms Connection : user root
Connection String : jdbc:mysql://myhost.mydomain:3306/
Database : myproject
Create database

On the screen 5, I got the message : OpenCms Setup Wizard - Create 
database & tables
Creating database ...
           Database has been successfully created.

Creating tables ...
           Tables have been successfully created.
On the screen 6, all the modules were selected


I began to read exception in the status window between the line 5000 and 
6000 (unfortunately, I could not copy them).

Then
I got the following messages during the setup.

Regards


9393:    ( 3 ) Indexing file simpleexample.xsd ... o.k.
9392:    ( 2 ) Indexing file simplecontentdetails.jsp ... skipped
9391:    ( 1 ) Indexing file simplecontent.html ... o.k.
9390:    Indexing folder 
/sites/default/alkacon-documentation/documentation-xmlcontent/simpleexample/
9389:    ------ Indexing ------ Online project (VFS)------  ...
9388:    Admin at Offline>updateIndex
9387:    Admin at Offline># Build search indexes
9386:    Admin at Offline>
9389:    ------ Indexing ------ Online project (VFS)------  ...
9388:    Admin at Offline>updateIndex
9387:    Admin at Offline># Build search indexes
9386:    Admin at Offline>
9385:   
9384:    >>    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9383:    >>    at org.opencms.main.CmsShell.start(CmsShell.java:491)
9382:    >>    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9381:    >>    at 
org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9380:    >>    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9379:    >>    at java.lang.reflect.Method.invoke(Method.java:324)
9378:    >>    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9377:    >>    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9376:    >>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method)
9375:    >>    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9374:    >>    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9373:    >>    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9372:    >>    at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9371:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9370:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9369:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9368:    >>    at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9367:    >>    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9366:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9365:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9364:    >>    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9363:    >>    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0)
9362:    >>    at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement
.java:294)
9361:    >>    at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement
.java:294)
9360:    >>    at 
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
9359:    >>java.sql.BatchUpdateException: Syntax error or access 
violation message from server: "You have an error in your SQL syntax 
near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9358:    >>Root cause:
9357:    >>-----------
9356:    >    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9355:    >    at org.opencms.main.CmsShell.start(CmsShell.java:491)
9354:    >    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9353:    >    at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9352:    >    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9351:    >    at java.lang.reflect.Method.invoke(Method.java:324)
9350:    >    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9349:    >    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9348:    >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9347:    >    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9346:    >    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9345:    >    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9344:    >    at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9343:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9342:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9341:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9340:    >    at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9339:    >    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9338:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9337:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9336:    >    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9335:    >    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
5)
9334:    >Root cause was: java.sql.BatchUpdateException: Syntax error or 
access violation message from server: "You have an error in your SQL 
syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9333:    >org.opencms.db.CmsSqlException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0), 
why: java.sql.BatchUpdateException: Syntax error or access violation 
message from server: "You have an error in your SQL syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9332:    >Root cause:
9331:    >-----------
9330:        at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9329:        at org.opencms.main.CmsShell.start(CmsShell.java:491)
9328:        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9327:        at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9326:        at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9325:        at java.lang.reflect.Method.invoke(Method.java:324)
9324:        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9323:        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9322:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9321:        at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9320:        at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9319:        at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9318:        at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9317:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9316:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9315:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9314:        at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9313:        at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9312:        at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9311:        at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9310:        at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1074)
9309:    Root cause was: java.sql.BatchUpdateException: Syntax error or 
access violation message from server: "You have an error in your SQL 
syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9308:    Root cause was: org.opencms.db.CmsSqlException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0), 
why: java.sql.BatchUpdateException: Syntax error or access violation 
message from server: "You have an error in your SQL syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9307:    org.opencms.db.CmsDataAccessException: CmsException ID: 300 
[Code 300 - Data Access Exception]
9306:    ------ ... finished writing the export points
9305:    Writing export point 
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/
opencms/frontend/templateone/xmlcontentdemo/ 
...  o.k.
9304:    Writing export point 
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/
opencms/frontend/templateone/ 
...  o.k.
9303:    Writing export point 
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/
opencms/frontend/ 
...  o.k.
9302:    Writing export point 
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/
opencms/ 
...  o.k.
9301:    Writing export point 
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/org/

...  o.k.
9300:    Writing export point 
/system/modules/org.opencms.frontend.templateone.xmlcontentdemo/classes/ 
...  o.k.
9299:    Writing export point /system/workplace/resources/filetypes/ 
...  o.k.
9298:    ------ Writing export points ...
9297:    Statistics: published files: 1, published folders: 19, deleted 
folders: 0, duration: 00:00:17
9296:   
9295:    >>    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9294:    >>    at org.opencms.main.CmsShell.start(CmsShell.java:491)
9293:    >>    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9292:    >>    at 
org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9291:    >>    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9290:    >>    at java.lang.reflect.Method.invoke(Method.java:324)
9289:    >>    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9288:    >>    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9287:    >>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method)
9286:    >>    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9285:    >>    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9284:    >>    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9283:    >>    at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9282:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9281:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9280:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9279:    >>    at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9278:    >>    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9277:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9276:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9275:    >>    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9274:    >>    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0)
9273:    >>    at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement
.java:294)
9272:    >>    at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement
.java:294)
9271:    >>    at 
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
9270:    >>java.sql.BatchUpdateException: Syntax error or access 
violation message from server: "You have an error in your SQL syntax 
near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9269:    >>Root cause:
9268:    >>-----------
9267:    >    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9266:    >    at org.opencms.main.CmsShell.start(CmsShell.java:491)
9265:    >    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9264:    >    at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9263:    >    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9262:    >    at java.lang.reflect.Method.invoke(Method.java:324)
9261:    >    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9260:    >    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9259:    >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9258:    >    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9257:    >    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9256:    >    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9255:    >    at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9254:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9253:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9252:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9251:    >    at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9250:    >    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9249:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9248:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9247:    >    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9246:    >    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
5)
9245:    >Root cause was: java.sql.BatchUpdateException: Syntax error or 
access violation message from server: "You have an error in your SQL 
syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9244:    >org.opencms.db.CmsSqlException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0), 
why: java.sql.BatchUpdateException: Syntax error or access violation 
message from server: "You have an error in your SQL syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9243:    >Root cause:
9242:    >-----------
9241:        at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9240:        at org.opencms.main.CmsShell.start(CmsShell.java:491)
9239:        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9238:        at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9237:        at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9236:        at java.lang.reflect.Method.invoke(Method.java:324)
9235:        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9234:        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9233:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9232:        at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9231:        at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9230:        at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9229:        at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9228:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9227:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9226:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9225:        at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9224:        at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9223:        at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9222:        at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9221:        at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1074)
9220:    Root cause was: java.sql.BatchUpdateException: Syntax error or 
access violation message from server: "You have an error in your SQL 
syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9219:    Root cause was: org.opencms.db.CmsSqlException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0), 
why: java.sql.BatchUpdateException: Syntax error or access violation 
message from server: "You have an error in your SQL syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9218:    org.opencms.db.CmsDataAccessException: CmsException ID: 300 
[Code 300 - Data Access Exception]
9217:       !!! Exception org.opencms.db.CmsDataAccessException: 
CmsException ID: 300
9216:    Error publishing file 
/sites/default/alkacon-documentation/documentation-xmlcontent/index.html
9215:   
9214:    >>    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9213:    >>    at org.opencms.main.CmsShell.start(CmsShell.java:491)
9212:    >>    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9211:    >>    at 
org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9210:    >>    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9209:    >>    at java.lang.reflect.Method.invoke(Method.java:324)
9208:    >>    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9207:    >>    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9206:    >>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method)
9205:    >>    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9204:    >>    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9203:    >>    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9202:    >>    at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9201:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9200:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9199:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9198:    >>    at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9197:    >>    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9196:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9195:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9194:    >>    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9193:    >>    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0)
9192:    >>    at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement
.java:294)
9191:    >>    at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement
.java:294)
9190:    >>    at 
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
9189:    >>java.sql.BatchUpdateException: Syntax error or access 
violation message from server: "You have an error in your SQL syntax 
near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9188:    >>Root cause:
9187:    >>-----------
9186:    >    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9185:    >    at org.opencms.main.CmsShell.start(CmsShell.java:491)
9184:    >    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9183:    >    at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9182:    >    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9181:    >    at java.lang.reflect.Method.invoke(Method.java:324)
9180:    >    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9179:    >    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9178:    >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9177:    >    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9176:    >    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:128
4)
9175:    >    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:401)
9174:    >    at 
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:308)
9173:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1870)
9172:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1914)
9171:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
9170:    >    at 
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:253
9)
9169:    >    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
9168:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java
:1368)
9167:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:88
8)
9166:    >    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.j
ava:1068)
9165:    >    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
5)
9164:    >Root cause was: java.sql.BatchUpdateException: Syntax error or 
access violation message from server: "You have an error in your SQL 
syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1"
9163:    >org.opencms.db.CmsSqlException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:29
0), 
why: java.sql.BatchUpdateException: Syntax error or access violation 
message from server: "You have an error in your SQL syntax near 
'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_CONTENTS.* 
FROM CMS_BAC' at line 1" [Code 301 - SQL Exception]
9162:    >Root cause:
9161:    >-----------
9160:        at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:148)
9159:        at org.opencms.main.CmsShell.start(CmsShell.java:491)
9158:        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
9157:        at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
9156:        at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
9155:        at java.lang.reflect.Method.invoke(Method.java:324)
9154:        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
9153:        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
9152:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
9151:        at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
749)
9150:        at org.opencms.setup.CmsSetupBean.import

Can someone help me ?

-- 
Xavier Ottolini
Développeur multimédia

Adelis
37, rue d'Engwiller
67350 La Walck
Téléphone : +33 (0) 3 88 72 29 10
Télécopie : +33 (0) 3 88 72 29 19
http://www.adelis.com




_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev




More information about the opencms-dev mailing list