[opencms-dev] Installation problem OpenCMS 6.0.3 under Windows XP

[Zambra]

Hello Clayton, Jakob and Arash,

thanks again for your help regarding my install problem. I have:

- upgraded to Java SDK 1.5
- downgraded to MySQL 4.1
- created a user "admin" (is there a mention to this in the docs?) and 
granted him all the privileges

Then I have restarted the setup. As Clayton pointed out, the setup could 
not log in as admin, and now it can. Nevertheless I keep getting other 
exceptions, as the one pasted below (it is the first one that appears in 
the setup log:

===================
86:    Exception while calling method "publishProject".
87:    org.opencms.db.CmsDbSqlException: Error reading the publish list 
for project "_setupProject".
88:        at 
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)
89:        at 
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
90:        at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
91:        at 
org.opencms.db.CmsSecurityManager.getPublishList(CmsSecurityManager.java:2085)
92:        at org.opencms.file.CmsObject.getPublishList(CmsObject.java:1292)
93:        at org.opencms.file.CmsObject.publishProject(CmsObject.java:1966)
94:        at org.opencms.file.CmsObject.publishProject(CmsObject.java:1923)
95:        at org.opencms.file.CmsObject.publishProject(CmsObject.java:1909)
96:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
97:        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
98:        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown 
Source)
99:        at java.lang.reflect.Method.invoke(Unknown Source)
100:        at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:246)
101:        at org.opencms.main.CmsShell.executeCommand(CmsShell.java:767)
102:        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
103:        at org.opencms.main.CmsShell.start(CmsShell.java:663)
104:        at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:186)
105:    Caused by: org.opencms.db.CmsDbSqlException: An SQL error 
occurred when executing the following query: 
com.mysql.jdbc.PreparedStatement at 158f1fa: SELECT 
CMS_OFFLINE_STRUCTURE.STRUCTURE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_PATH,CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE,CMS_OFFLINE_STRUCTURE.DATE_RELEASED,CMS_OFFLINE_STRUCTURE.DATE_EXPIRED,CMS_OFFLINE_RESOURCES.RESOURCE_ID,CMS_OFFLINE_RESOURCES.RESOURCE_TYPE,CMS_OFFLINE_RESOURCES.RESOURCE_FLAGS,CMS_OFFLINE_RESOURCES.RESOURCE_STATE,CMS_OFFLINE_RESOURCES.DATE_CREATED,CMS_OFFLINE_RESOURCES.DATE_LASTMODIFIED,CMS_OFFLINE_RESOURCES.USER_CREATED,CMS_OFFLINE_RESOURCES.USER_LASTMODIFIED,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED 
LOCKED_IN_PROJECT,CMS_OFFLINE_RESOURCES.RESOURCE_SIZE,CMS_OFFLINE_RESOURCES.SIBLING_COUNT,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED 
FROM CMS_OFFLINE_STRUCTURE,CMS_OFFLINE_RESOURCES WHERE 
CMS_OFFLINE_RESOURCES.RESOURCE_ID=CMS_OFFLINE_STRUCTURE.RESOURCE_ID AND 
(CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED='2')  AND 
(CMS_OFFLINE_RESOURCES.RESOURCE_SIZE > -1)  AND NOT 
(((CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE='0' AND 
CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE >= 
CMS_OFFLINE_RESOURCES.RESOURCE_STATE) OR 
(CMS_OFFLINE_RESOURCES.RESOURCE_STATE='0' AND 
CMS_OFFLINE_RESOURCES.RESOURCE_STATE >= 
CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE)))  ORDER BY 
CMS_OFFLINE_STRUCTURE.RESOURCE_PATH.
106:        at 
org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1708)
107:        at 
org.opencms.db.CmsDriverManager.getPublishList(CmsDriverManager.java:3248)
108:        at 
org.opencms.db.CmsSecurityManager.getPublishList(CmsSecurityManager.java:2078)
109:        ... 13 more
110:    Caused by: java.sql.SQLException: General error message from 
server: "Can't create/write to file 
'c:\docume%1\czerny\config%1\temp\#sql_780_0.MYI' (Errcode: 2)"
111:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
112:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
113:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
114:        at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
115:        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)
116:        at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
117:        at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
118:        at 
org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1701)
119:        ... 15 more

Thanks in advance for any hints.

Best regards,

Michael
zambra.com