Discuz! info: MySQL Query Error
User: JK.b
Time: 2008-9-12 8:27am
Script: /search.php
SQL: SELECT searchid, dateline,
('15'<>'0' AND uid='1' AND 1221179238-dateline<15) AS flood,
(searchstring='title|初音|0||\'75\',\'77\',\'83\',\'79\',\'78\',\'62\',\'63\',\'114\',\'64\',\'65\',\'66\',\'67\',\'69\',\'68\',\'70\',\'72\',\'90\',\'46\',\'49\',\'47\',\'50\',\'43\',\'104\',\'53\',\'54\',\'56\',\'57\',\'55\',\'58\',\'59\',\'60\',\'112\',\'111\',\'110\',\'34\',\'35\',\'113\',\'28\',\'96\',\'106\',\'94\',\'108\',\'105\',\'32\',\'33\',\'37\',\'3\',\'4\',\'5\',\'6\',\'81\',\'7\',\'91\'|0|0|all' AND expiration>'1221179238') AS indexvalid
FROM [Table]searchindex
WHERE ('15'<>'0' AND uid='1' AND 1221179238-dateline<15) OR (searchstring='title|初音|0||\'75\',\'77\',\'83\',\'79\',\'78\',\'62\',\'63\',\'114\',\'64\',\'65\',\'66\',\'67\',\'69\',\'68\',\'70\',\'72\',\'90\',\'46\',\'49\',\'47\',\'50\',\'43\',\'104\',\'53\',\'54\',\'56\',\'57\',\'55\',\'58\',\'59\',\'60\',\'112\',\'111\',\'110\',\'34\',\'35\',\'113\',\'28\',\'96\',\'106\',\'94\',\'108\',\'105\',\'32\',\'33\',\'37\',\'3\',\'4\',\'5\',\'6\',\'81\',\'7\',\'91\'|0|0|all' AND expiration>'1221179238')
ORDER BY flood
Error: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (big5_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267