[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