posted 16 years ago
Hi, i have one problem, when i start jforum integrated in my application on my PC i haven't got any problem, all run perfectly, but when i start my application in other computer, and start document.location = "forums/list.page"; javascript link, firefox say me the next message:
An error has occurred.
For detailed error information, please see the HTML source code, and contact the forum Administrator.
java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
Query being executed when exception was thrown:
SELECT r.name, '0' AS role_value FROM jforum_roles r WHERE r.group_id IN (1) UNION SELECT r.name, rv.role_value FROM jforum_roles r, jforum_role_values rv WHERE r.role_id = rv.role_id AND r.group_id IN (1) ORDER BY name
How i can fix it? thanks you.
[originally posted on jforum.net by MiLLeN]