<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I removed an opencms installation and tried installing
again. The following errors occurred during setup:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>!!! Error publishing file
"/system/modules/org.opencms.frontend.templateone/dialogs/property.jsp".
<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>272: !!! Exception An
SQL error occurred when executing the following query:
com.mysql.jdbc.ServerPreparedStatement[10] - (SELECT DISTINCT
CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BACKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BACKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKUP_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RESOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RESOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_RESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BACKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT FROM CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_STRUCTURE.RESOURCE_PATH='/system/modules/org.opencms.frontend.templateone/dialogs/property.jsp'
AND CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) UNION (SELECT
DISTINCT CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BACKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BACKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKUP_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RESOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RESOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_RESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BACKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT FROM CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_RESOURCES.RESOURCE_ID='3c40a339-bcd0-11db-b66f-f14389d13252' AND
CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) ORDER BY
VERSION_ID, RESOURCE_PATH ASC. <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>273:
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: com.mysql.jdbc.ServerPreparedStatement[10] - (SELECT DISTINCT
CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BACKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BACKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKUP_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RESOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RESOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_RESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BACKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT FROM CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_STRUCTURE.RESOURCE_PATH='/system/modules/org.opencms.frontend.templateone/dialogs/property.jsp'
AND CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) UNION (SELECT
DISTINCT CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BACKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BACKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKUP_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RESOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RESOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_RESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BACKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT FROM CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_RESOURCES.RESOURCE_ID='3c40a339-bcd0-11db-b66f-f14389d13252' AND CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID
AND CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) ORDER BY
VERSION_ID, RESOURCE_PATH ASC. <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>274:
at org.opencms.db.generic.CmsBackupDriver.readBackupFileHeaders(CmsBackupDriver.java:492)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>295: Caused by:
java.sql.SQLException: Can't create/write to file
'c:\windows\temp\#sql_900_1.MYI' (Errcode: 17)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>296:
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>347: Caused by:
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: com.mysql.jdbc.ServerPreparedStatement[10] - (SELECT DISTINCT
CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BACKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BACKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKUP_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RESOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RESOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_RESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BACKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT FROM CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_STRUCTURE.RESOURCE_PATH='/system/modules/org.opencms.frontend.templateone/dialogs/property.jsp'
AND CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) UNION (SELECT
DISTINCT CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BACKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BACKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKUP_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RESOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RESOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_RESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BACKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT FROM CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_RESOURCES.RESOURCE_ID='3c40a339-bcd0-11db-b66f-f14389d13252' AND
CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) ORDER BY
VERSION_ID, RESOURCE_PATH ASC. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>353: Caused by:
java.sql.SQLException: Can't create/write to file
'c:\windows\temp\#sql_900_1.MYI' (Errcode: 17)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>659: Caused by:
java.sql.SQLException: Can't create/write to file 'c:\windows\temp\#sql_900_0.MYD'
(Errcode: 17)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I encountered many such errors. It looks like some problem
with the MySQL database I’m using, but I’m not able to figure out
what.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Help me out if you have any ideas.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks and Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Latha<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
<table><tr><td bgcolor=#ffffff><font color=#000000>This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.<br>
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. <br>
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly <br>
prohibited and may be unlawful.<br>
</font></td></tr></table>