<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman">when I publish I get this error:
</FONT></FONT></SPAN><SPAN class=head><FONT size=3><FONT
face="Times New Roman">java.sql.SQLException: Table
'opencms.cms_backup_contents' doesn't exist</FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3>(the complete output is at the end of this
message)</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3>everything else seems to work ok</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head></SPAN><SPAN
class=head><FONT face="Times New Roman" size=3></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3>the installation did not report any problem when
creating tables</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3>thanks to anyone you can help me with
this</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3>regards,</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
face="Times New Roman" size=3>fernando.</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman"></FONT></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman">SYSTEM:</FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman"></FONT></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman">Opencms
6.2.1<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman">Tomcat
5.5.9<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman">Mysql
5.0.21<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman">Windows 2000</FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT face="Times New Roman"></FONT></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN class=head><FONT
size=3><FONT
face="Times New Roman">OUTPUT:<o:p></o:p></FONT></FONT></SPAN></P></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV class=main><SPAN class=head>Validating links
...</SPAN><SPAN><BR></SPAN><SPAN class=note>( 1 / 1 ) </SPAN><SPAN
class=note>Validating links in file
</SPAN><SPAN>/sites/cinterfor/prueba_cfor.html </SPAN><SPAN>... </SPAN><SPAN
class=ok>o.k.</SPAN><SPAN><BR></SPAN><SPAN class=head>... finished validating
links</SPAN><SPAN><BR></SPAN><SPAN class=head>Publishing resources
...</SPAN><SPAN><BR></SPAN><SPAN class=head>Publishing files
...</SPAN><SPAN><BR></SPAN><SPAN class=note>( 1 / 1 ) </SPAN><SPAN
class=note>Publishing file</SPAN><SPAN> /sites/cinterfor/prueba_cfor.html
</SPAN><SPAN>... </SPAN><SPAN class=err>Error publishing file
"/sites/cinterfor/prueba_cfor.html". </SPAN><SPAN><BR></SPAN><SPAN
class=throw>Exception org.opencms.db.CmsDbSqlException: An SQL error occurred
when executing the following query: com.mysql.jdbc.PreparedStatement@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').
<BR>at
org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1253)<BR>at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1087)<BR>at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:1204)<BR>at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1654)<BR>at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4493)<BR>at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2893)<BR>at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)<BR>at
org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java:122)<BR>Caused
by: java.sql.SQLException: Table 'opencms.cms_backup_contents' doesn't
exist<BR>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)<BR>at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)<BR>at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)<BR>at
com.mysql.jdbc.Connection.execSQL(Connection.java:2994)<BR>at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)<BR>at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)<BR>at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)<BR>at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)<BR>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR>at
org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1250)<BR>...
7 more<BR></SPAN><SPAN>Statistics: published files: 1, published folders: 0,
deleted folders: 0, duration: 00:00:00</SPAN><SPAN><BR></SPAN><SPAN
class=throw>Exception org.opencms.db.CmsDbSqlException: Error publishing file
"/sites/cinterfor/prueba_cfor.html". <BR>at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)<BR>at
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)<BR>at
org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)<BR>at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1675)<BR>at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4493)<BR>at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2893)<BR>at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)<BR>at
org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java:122)<BR>Caused
by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: com.mysql.jdbc.PreparedStatement@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').
<BR>at
org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1253)<BR>at
org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriver.java:1087)<BR>at
org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:1204)<BR>at
org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1654)<BR>...
4 more<BR>Caused by: java.sql.SQLException: Table 'opencms.cms_backup_contents'
doesn't exist<BR>at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)<BR>at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)<BR>at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)<BR>at
com.mysql.jdbc.Connection.execSQL(Connection.java:2994)<BR>at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)<BR>at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)<BR>at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)<BR>at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)<BR>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR>at
org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(CmsBackupDriver.java:1250)<BR>...
7 more<BR></SPAN></DIV></DIV></BODY></HTML>