[opencms-dev] Table 'opencms.cms_backup_contents' doesn't exist !?!?

[Fernando Michel Barros Martinet]

when I publish I get this error: java.sql.SQLException: Table 'opencms.cms_backup_contents' doesn't exist

(the complete output is at the end of this message)



everything else seems to work ok



the installation did not report any problem when creating tables



thanks to anyone you can help me with this

regards,

fernando.



SYSTEM:



Opencms 6.2.1

Tomcat 5.5.9

Mysql 5.0.21

Windows 2000



OUTPUT:



  
Validating links ...
( 1 / 1 ) Validating links in file /sites/cinterfor/prueba_cfor.html ... o.k.
... finished validating links
Publishing resources ...
Publishing files ...
( 1 / 1 ) Publishing file /sites/cinterfor/prueba_cfor.html ... Error publishing file "/sites/cinterfor/prueba_cfor.html". 
Exception org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: com.mysql.jdbc.PreparedStatement at 14492fb: INSERT INTO CMS_BACKUP_CONTENTS (CONTENT_ID,RESOURCE_ID,FILE_CONTENT,PUBLISH_TAG,VERSION_ID,BACKUP_ID) VALUES ('9a549628-1d9c-11db-9ebd-001422430534','9a4fdb37-1d9c-11db-9ebd-001422430534',x'3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0D0A0D0A3C706167657320786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E636522207873693A6E6F4E616D657370616365536368656D614C6F636174696F6E3D22687474703A2F2F7777772E6F70656E636D732E6F72672F6474642F362E302F786D6C706167652E787364223E0D0A20203C70616765206C616E67756167653D226465223E0D0A202020203C656C656D656E74206E616D653D227465787431223E0D0A2020202020203C6C696E6B732F3E0D0A2020202020203C636F6E74656E742F3E0D0A202020203C2F656C656D656E743E0D0A20203C2F706167653E0D0A20203C70616765206C616E67756167653D22656E223E0D0A202020203C656C656D656E74206E616D653D227465787431223E0D0A2020202020203C6C696E6B732F3E0D0A2020202020203C636F6E74656E742F3E0D0A202020203C2F656C656D656E743E0D0A20203C2F706167653E0D0A3C2F70616765733E',62,1,'bf56ef33-1da0-11db-9ebd-001422430534'). 
at org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1253)
at org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1087)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:1204)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1654)
at org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4493)
at org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2893)
at org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)
at org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java:122)
Caused by: java.sql.SQLException: Table 'opencms.cms_backup_contents' doesn't exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1250)
... 7 more
Statistics: published files: 1, published folders: 0, deleted folders: 0, duration: 00:00:00
Exception org.opencms.db.CmsDbSqlException: Error publishing file "/sites/cinterfor/prueba_cfor.html". 
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1675)
at org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4493)
at org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2893)
at org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)
at org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java:122)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: com.mysql.jdbc.PreparedStatement at 14492fb: INSERT INTO CMS_BACKUP_CONTENTS (CONTENT_ID,RESOURCE_ID,FILE_CONTENT,PUBLISH_TAG,VERSION_ID,BACKUP_ID) VALUES ('9a549628-1d9c-11db-9ebd-001422430534','9a4fdb37-1d9c-11db-9ebd-001422430534',x'3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0D0A0D0A3C706167657320786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E636522207873693A6E6F4E616D657370616365536368656D614C6F636174696F6E3D22687474703A2F2F7777772E6F70656E636D732E6F72672F6474642F362E302F786D6C706167652E787364223E0D0A20203C70616765206C616E67756167653D226465223E0D0A202020203C656C656D656E74206E616D653D227465787431223E0D0A2020202020203C6C696E6B732F3E0D0A2020202020203C636F6E74656E742F3E0D0A202020203C2F656C656D656E743E0D0A20203C2F706167653E0D0A20203C70616765206C616E67756167653D22656E223E0D0A202020203C656C656D656E74206E616D653D227465787431223E0D0A2020202020203C6C696E6B732F3E0D0A2020202020203C636F6E74656E742F3E0D0A202020203C2F656C656D656E743E0D0A20203C2F706167653E0D0A3C2F70616765733E',62,1,'bf56ef33-1da0-11db-9ebd-001422430534'). 
at org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1253)
at org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1087)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:1204)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1654)
... 4 more
Caused by: java.sql.SQLException: Table 'opencms.cms_backup_contents' doesn't exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1250)
... 7 more
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060727/bef555f2/attachment.htm>