jforum 问题解决

1.在建数据库时要用如下语句：
Create DATABASE JForum DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

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

我终于弄好了！
在MySql的安装目录下，有个my.in文件，打开它：
将下面的值改为utf8如下:
default-character-set=utf8 有两个

对了，要记得把mysql服务重新启动下，就可以了

文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: jforumjforum
相关日志: