[opencms-dev] error setup current cvs version

Kraus Marcel Marcel.Kraus at sycor.de
Tue Nov 30 18:28:09 CET 2004


hi,
 
i cant import the workplace during the install 
 
who can help me?
 
 
1: OpenCms WEB-INF path: d:\server\Tomcat50\webapps\opencms\WEB-INF\

2: OpenCms property file: d:\server\Tomcat50\webapps\opencms\WEB-INF\config\opencms.properties

3: 

4: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

5: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

6: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)

7: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)

8: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)

9: at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)

10: at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)

11: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

12: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

13: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374)

14: at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:526)

15: at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4470)

16: at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

17: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

18: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

19: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

20: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

21: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

22: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

23: Initialization of default users and groups failed

24: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

25: Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

26: at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:296)

27: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:384)

28: at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:526)

29: at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4470)

30: at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

31: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

32: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

33: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

34: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

35: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

36: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

37: >-----------

38: >Root cause:

39: >java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

40: > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)

41: > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)

42: > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)

43: > at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)

44: > at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)

45: > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

46: > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

47: > at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374)

48: > at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:526)

49: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4470)

50: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

51: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

52: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

53: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

54: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

55: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

56: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

57: 

58: [CmsDriverManager] Critical error while initializing org.opencms.db.mysql.CmsUserDriver

59: java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

60: Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

61: at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)

62: at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4470)

63: at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

64: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

65: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

66: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

67: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

68: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

69: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

70: Caused by: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

71: Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

72: at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:296)

73: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:384)

74: at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:526)

75: ... 8 more

76: Critical init error/3

77: org.opencms.main.CmsException: Critical error while initializing org.opencms.db.mysql.CmsUserDriver [Code 33 - DriverManager init error]

78: Root cause was: java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

79: Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

80: at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4482)

81: at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

82: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

83: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

84: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

85: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

86: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

87: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

88: >-----------

89: >Root cause:

90: >java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

91: >Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

92: > at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)

93: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4470)

94: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

95: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

96: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

97: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

98: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

99: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

100: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

101: >Caused by: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

102: >Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

103: > at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:296)

104: > at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:384)

105: > at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:526)

106: > ... 8 more

107: 

108: Critical error during OpenCms initialization

109: org.opencms.main.CmsException: Database init failed [Code 33 - DriverManager init error]

110: Root cause was: org.opencms.main.CmsException: Critical error while initializing org.opencms.db.mysql.CmsUserDriver [Code 33 - DriverManager init error]

111: Root cause was: java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

112: Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

113: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1041)

114: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

115: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

116: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

117: >-----------

118: >Root cause:

119: >org.opencms.main.CmsException: Critical error while initializing org.opencms.db.mysql.CmsUserDriver [Code 33 - DriverManager init error]

120: >Root cause was: java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

121: >Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

122: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4482)

123: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

124: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

125: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

126: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

127: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

128: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

129: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

130: >>-----------

131: >>Root cause:

132: >>java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

133: >>Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

134: >> at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)

135: >> at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4470)

136: >> at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:395)

137: >> at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2182)

138: >> at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

139: >> at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

140: >> at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

141: >> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

142: >> at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

143: >>Caused by: org.opencms.main.CmsException: [org.opencms.db.mysql.CmsUserDriver] where: org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:374), why: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" [Code 4 - Sql exception]

144: >>Root cause was: java.sql.SQLException: General error message from server: "Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

145: >> at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:296)

146: >> at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:384)

147: >> at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:526)

148: >> ... 8 more

149: 

150: java.lang.NullPointerException

151: at org.opencms.main.CmsShell.<init>(CmsShell.java:448)

152: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

153: java.lang.NullPointerException

154: at org.opencms.main.CmsShell.printPrompt(CmsShell.java:719)

155: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:666)

156: at org.opencms.main.CmsShell.start(CmsShell.java:491)

157: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)

158: java.lang.NullPointerException

159: at org.opencms.main.CmsShell.exit(CmsShell.java:554)

160: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)

161: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)

162: java.lang.NullPointerException

163: at org.opencms.main.CmsShell.exit(CmsShell.java:560)

164: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)

165: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)



************************************************

sycor plastics - die neue Branchenlösung für die Kunststoffindustrie

www.sycor-plastics.de

************************************************




Diese E-Mail ist vertraulich und kann darüber hinaus persönliche Informationen beinhalten. Wenn Sie nicht der bestimmungsgemäße Empfänger sind, löschen Sie bitte die E-Mail und deren Anhänge sofort und benachrichtigen Sie uns darüber. Die Firma sycor willigt in keine Verträge oder vertragliche Verpflichtungen ein oder übermittelt rechtsverbindliche Angebote, die in Form von E-Mail versandt werden, sofern dies nicht ausdrücklich in schriftlicher Form zwischen den Parteien vereinbart wurde.

This e-mail is confidential and may contain personal and/or privileged information. If you are not the intended recipient please delete this e-mail and all attachments immediately and inform us. The company sycor does not agree with contracts or contract obligations sent by e-mail, neither do we transmit legally binding offers by e-mail, unless this is not expressly agreed upon between the parties and documented in written form.




More information about the opencms-dev mailing list