兄弟姐妹们，快来看看

我以前的是MYSQL4.0的数据库，现在改成为4.1的数据库，我是这样操作的，用4.0的后台备份成4.1的数据库，然后用4.1的后台导入刚才备份的数据，出现这个错误,但是我用字母搜索就不会报错

Discuz! info: MySQL Query Error
User: zhy1899
Time: 2007-1-31 9:38am
Script: /search.php
SQL: SELECT searchid, dateline,
('30'<>'0' AND uid='2' AND 1170207498-dateline<30) AS flood,
(searchstring='title|注册机|0||\'66\',\'43\',\'71\',\'72\',\'73
\',\'74\',\'82\',\'19\',\'21\',\'78\',\'81\',\'29\',\'32\',\'30
\',\'31\',\'62\',\'63\',\'40\',\'22\',\'25\',\'26\',\'27\',\'28
\',\'75\',\'77\',\'24\',\'58\',\'59\',\'60\',\'45\',\'67\',\'16
\',\'69\',\'76\',\'51\',\'54\',\'55\',\'80\',\'56\',\'87\',\'12
\',\'11\',\'42\',\'41\'|0|0|all' AND expiration>'1170207498') AS
indexvalid
FROM new591_searchindex
WHERE ('30'<>'0' AND uid='2' AND 1170207498-dateline<30) OR
(searchstring='title|注册机|0||\'66\',\'43\',\'71\',\'72\',\'73
\',\'74\',\'82\',\'19\',\'21\',\'78\',\'81\',\'29\',\'32\',\'30
\',\'31\',\'62\',\'63\',\'40\',\'22\',\'25\',\'26\',\'27\',\'28
\',\'75\',\'77\',\'24\',\'58\',\'59\',\'60\',\'45\',\'67\',\'16
\',\'69\',\'76\',\'51\',\'54\',\'55\',\'80\',\'56\',\'87\',\'12
\',\'11\',\'42\',\'41\'|0|0|all' AND expiration>'1170207498')
ORDER BY flood
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.
   我在后台进行数据库优化的时候，发现这个表不能选中，是灰色的
   

kankan_sessions

HEAP

21

28000

12000

55

[ 本帖最后由 zhy1899 于 2007-1-31 09:51 编辑 ]

重建下 sessions 表试试，方法见：https://discuz.dismall.com/viewthread.php?tid=384794

还是不行
Discuz! info: MySQL Query Error
User: zhy1899
Time: 2007-1-31 9:38am
Script: /search.php
SQL: SELECT searchid, dateline,
('30'<>'0' AND uid='2' AND 1170207498-dateline<30) AS flood,
(searchstring='title|注册机|0||\'66\',\'43\',\'71\',\'72\',\'73
\',\'74\',\'82\',\'19\',\'21\',\'78\',\'81\',\'29\',\'32\',\'30
\',\'31\',\'62\',\'63\',\'40\',\'22\',\'25\',\'26\',\'27\',\'28
\',\'75\',\'77\',\'24\',\'58\',\'59\',\'60\',\'45\',\'67\',\'16
\',\'69\',\'76\',\'51\',\'54\',\'55\',\'80\',\'56\',\'87\',\'12
\',\'11\',\'42\',\'41\'|0|0|all' AND expiration>'1170207498') AS
indexvalid
FROM new591_searchindex
WHERE ('30'<>'0' AND uid='2' AND 1170207498-dateline<30) OR
(searchstring='title|注册机|0||\'66\',\'43\',\'71\',\'72\',\'73
\',\'74\',\'82\',\'19\',\'21\',\'78\',\'81\',\'29\',\'32\',\'30
\',\'31\',\'62\',\'63\',\'40\',\'22\',\'25\',\'26\',\'27\',\'28
\',\'75\',\'77\',\'24\',\'58\',\'59\',\'60\',\'45\',\'67\',\'16
\',\'69\',\'76\',\'51\',\'54\',\'55\',\'80\',\'56\',\'87\',\'12
\',\'11\',\'42\',\'41\'|0|0|all' AND expiration>'1170207498')
ORDER BY flood
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