cocomilo

江南恋人（恋人情人系统）for dz6.0 GBK正式版
    无法结婚，，，提示错误
Discuz! info: MySQL Query Error

User: 伊梦随缘
Time: 2007-12-20 10:43am
Script: /bbs/plugin.php

SQL: select * from [Table]3736qiuai where username='伊梦随缘' and chk='0' or tousername='伊梦随缘' and chk=0 or username='幸福无止境' and chk='0' or tousername='幸福无止境' and chk=0
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

Similar error report has beed dispatched to administrator before

yangzhu6263736

数据库字符集不对，需要phpmyadmin删掉所有以3736开前的表。然后再用正式版压缩包里的sql文件在phpmyadmin中重新执行建表。

realfage

#1060 - Duplicate column name '3736lover1'

realfage

SQL 查询:

ALTER TABLE cdb_members ADD 3736lover2 varchar( 15 ) NULL ;

MySQL 返回：文档
#1060 - Duplicate column name '3736lover2'

请问这该咱整啊??