安华波

Discuz! info: MySQL Query Error

User: 陆小千
Time: 2008-6-20 3:24pm
Script: /plugin.php

SQL: SELECT * from [Table]qiuhun where dlg='0' and (username='陆小千' or tousername='陆小千')
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.

到 http://faq.comsenz.com 搜索此错误的解决方案

有问题啊  晕死  怎么解决？

mlyu

谢了LZ。。正需要呢

mlyu

Discuz! info: MySQL Query Error

User:
Time: 2008-6-24 9:02pm
Script: /marryset.php

SQL:
CREATE TABLE `cdb_jhzhufu` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`jhid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`lmoney` int(10) unsigned default NULL,
`message` text,
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

Error: Table 'cdb_jhzhufu' already exists
Errno.: 1050

mlyu

怎么装不了？

Nuisence

Discuz! info: MySQL Query Error

User: 紫禁恶魔
Time: 2008-6-28 2:49am
Script: /plugin.php

SQL: SELECT * from [Table]qiuhun where dlg='0' and (username='紫禁恶魔' or tousername='紫禁恶魔')
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267


麻烦啊!!! 楼主帮忙解决啊!! 还是那个高手来看看~~

lxj520xf

用不了呀
Discuz! info: MySQL Query Error

User: admin
Time: 2008-6-28 12:58pm
Script: /plugin.php

SQL: select uid,gender,hw,extcredits2 from [Table]members WHERE username='admin'
Error: Unknown column 'hw' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

到 http://faq.comsenz.com 搜索此错误的解决方案

ivanspring

首先，必须运行marrysetv.php
其次，后台升级数据库：

复制内容到剪贴板
代码:
ALTER TABLE `cdb_jhzhufu` CHANGE `username` `username` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `tousername` `tousername` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `message` `message` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL
复制内容到剪贴板
代码:
ALTER TABLE `cdb_jie` CHANGE `username` `username` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `thename` `thename` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `content` `content` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL
复制内容到剪贴板
代码:
ALTER TABLE `cdb_lihun` CHANGE `username` `username` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `tousername` `tousername` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `reason` `reason` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL
复制内容到剪贴板
代码:
ALTER TABLE `cdb_qiuhun` CHANGE `username` `username` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `tousername` `tousername` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
CHANGE `message` `message` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL ,
CHANGE `content` `content` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL

50977320

修改viewthread.htm

找到


<p><em>$post[authortitle]</em></p>
我怎么找不到<p><em>$post[authortitle]</em></p>？
找不到怎么修改？
   郁闷````(::22:

gn02099009

發現求婚後的同意是否應該是另一方按的
可是追求者可以自行選按同意
根本不需要對方的答應便成功地結婚了

請問各位會員是否有小弟一樣的情況問題出現呢!?

請問如何解決這個問題

memorable

可以装上，但有两个错误：
1、求婚后对方显示有新短消息，但里面无内容。
2、在任何显示可以查看求婚（被求婚）人信息时连接错误。

有哪位高手修改好了，能不能教一下。

[ 本帖最后由 memorable 于 2008-7-6 23:26 编辑 ]