[opencms-dev] SQL errors during module import

[Stefan Moises]

Hi there,

I am trying to install OpenCMS 5.3.5. and I'm getting SQL errors when 
trying to import/install some of the modules (I also get those errors if 
I try to install the modules manually later). Modules that fail to 
install are the JSP base documentation or the JSP template documentation...
I am running a pretty old MySQL version on the server, may this be the 
cause?
The software used is:

Suse Linux 7.2
Tomcat 4.1.24
Apache 1.3x
MySQL  3.23.37
JDK 1.4.1 (Blackdown-1.4.1-01)
OpenCMS 5.3.5.

Here are some of the errors:

4806:    >>    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
4805:    >>    at org.opencms.main.CmsShell.start(CmsShell.java:491)
4804:    >>    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
4803:    >>    at 
org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
4802:    >>    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
4801:    >>    at java.lang.reflect.Method.invoke(Method.java:324)
4800:    >>    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
4799:    >>    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
4798:    >>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method)
4797:    >>    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:761)
4796:    >>    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1264)
4795:    >>    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:395)
4794:    >>    at 
org.opencms.importexport.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:183)
4793:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2331)
4792:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2346)
4791:    >>    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2364)
4790:    >>    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4856)
4789:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1284)
4788:    >>    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:997)
4787:    >>    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1145)
4786:    >>    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:204)
4785:    >>    at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeBatch(DelegatingPreparedStatement.java:231)
4784:    >>    at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeBatch(DelegatingPreparedStatement.java:231)
4783:    >>    at 
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1404)
4782:    >>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_FILES.* 
FROM CMS_BACKUP' at line 1"
4781:    >>Root cause:
4780:    >>-----------
4779:    >    at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
4778:    >    at org.opencms.main.CmsShell.start(CmsShell.java:491)
4777:    >    at 
org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
4776:    >    at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
4775:    >    at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
4774:    >    at java.lang.reflect.Method.invoke(Method.java:324)
4773:    >    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
4772:    >    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
4771:    >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
4770:    >    at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:761)
4769:    >    at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1264)
4768:    >    at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:395)
4767:    >    at 
org.opencms.importexport.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:183)
4766:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2331)
4765:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2346)
4764:    >    at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2364)
4763:    >    at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4856)
4762:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1284)
4761:    >    at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:997)
4760:    >    at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1145)
4759:    >    at 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:209)
4758:    >    at 
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:386)
4757:    >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_FILES.* FROM 
CMS_BACKUP' at line 1"
4756:    >org.opencms.main.CmsException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:204), 
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_FILES.* FROM 
CMS_BACKUP' at line 1" [Code 4 - Sql exception]
4755:    >Root cause:
4754:    >-----------
4753:        at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
4752:        at org.opencms.main.CmsShell.start(CmsShell.java:491)
4751:        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
4750:        at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
4749:        at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
4748:        at java.lang.reflect.Method.invoke(Method.java:324)
4747:        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
4746:        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
4745:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
4744:        at 
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:761)
4743:        at 
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:1264)
4742:        at 
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:395)
4741:        at 
org.opencms.importexport.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:183)
4740:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2331)
4739:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2346)
4738:        at 
org.opencms.file.CmsObject.publishProject(CmsObject.java:2364)
4737:        at 
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4856)
4736:        at 
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1284)
4735:        at 
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:997)
4734:        at 
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1151)
4733:        at 
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:386)
4732:    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_FILES.* FROM 
CMS_BACKUP' at line 1"
4731:    Root cause was: org.opencms.main.CmsException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:204), 
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_FILES.* FROM 
CMS_BACKUP' at line 1" [Code 4 - Sql exception]
4730:    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_FILES.* FROM 
CMS_BACKUP' at line 1" [Code 0 - Unknown exception]
4729:    org.opencms.main.CmsException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:386), 
why: org.opencms.main.CmsException: 
[org.opencms.db.mysql.CmsBackupDriver] where: 
org.opencms.db.generic.CmsBackupDriver.deleteBackups(CmsBackupDriver.java:204), 
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_FILES.* FROM 
CMS_BACKUP' at line 1" [Code 4 - Sql exception]
4728:    Exception while calling method 'importModulesFromSetupBean'
4727:    ------ ... finished writing the export points
4726:    Writing export point 
/system/modules/com.alkacon.documentation.examples-jstl/lib/ ...  o.k.
4725:    ------ Writing export points ...
4724:    ------ ... finished writing the export points


-- 
-------------------------------------
-------------------------------------
Stefan Moises
www.beffy.de
www.rent-a-hero.de
beffy at gmx.de
-------------------------------------
-------------------------------------