v2.7.1 SQL Error [message #27117] |
Sat, 27 August 2005 02:06 |
u0u0
Messages: 9 Registered: August 2005
Karma: 0
|
Junior Member |
|
|
when i post a newtopic,it return this
Sat Aug 27 2:05:02 UTC 2005 (/usr/local/www/data-dist/FUDforum2/index.php:200
/usr/local/www/data-dist/FUDforum2/theme/default/post.php:2738
/usr/local/www/data-dist/FUDforum2/theme/default/post.php:1654
/usr/local/www/data-dist/FUDforum2/theme/default/post.php:3885
/usr/local/www/data-dist/FUDforum2/index.php:1166
) 1271: Illegal mix of collations for operation ' IN '
Query: INSERT INTO fud26_index (word_id, msg_id) SELECT id, 1 FROM fud26_search WHERE word IN('部電視劇是以服裝界的設計大師Coco','Chanel','可可·香奈尔','和Elsa','Schiaparelli','埃尔沙·斯基亚帕雷利','的大戰構圖中取其樣本,把共存於','年代的上流社會和庶民社會的文化通過愛情和欲望�','一素材來講述,以','世紀','年代服裝界和上流社會爲背景,描寫了','個年輕人的愛情和野心。')
_GET: array ( 't' => 'post', )
_POST: array ( 'msg_subject' => '时尚风云70年代', 'thr_ordertype' => '0', 'thr_orderexpiry' => '1000000000', 'msg_icon' => '', 'fnt_size' => '', 'fnt_color' => '', 'fnt_face' => '', 'msg_body' => '這部電視劇是以服裝界的設計大師Coco Chanel(可可·香奈尔)和Elsa Schiaparelli(埃尔沙·斯基亚帕雷利)的大戰構圖中取其樣本,把共存於60-70年代的上流社會和庶民社會的文化通過愛情和欲望這一素材來講述,以20世紀70年代服裝界和上流社會爲背景,描寫了4個年輕人的愛情和野心。 ', 'tmp_f_val' => '1', 'msg_poster_notif' => 'Y', 'msg_show_sig' => 'Y', 'S' => '7c95b1cec68f0aff4ee4b779a199311d', 'SQ' => '949d9fda44465ed36253dc35ccf61824', 'submitted' => '1', 'reply_to' => '0', 'th_id' => '', 'frm_id' => '1', 'start' => '0', 'msg_id' => '0', 'pl_id' => '0', 'old_subject' => '', 'prev_loaded' => '1', 'btn_submit' => 1, )
Server Version: 4.1.13-log
[Referring Page] http://172.24.6.32/FUDforum2/index.php?t=post&frm_id=1&S=7c95b1cec68f0aff4ee4b779a199311d
|
|
|
Re: v2.7.1 SQL Error [message #27119 is a reply to message #27117] |
Sat, 27 August 2005 04:25 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
What is the charset of the table and the database connection?
FUDforum Core Developer
|
|
|
Re: v2.7.1 SQL Error [message #27120 is a reply to message #27117] |
Sat, 27 August 2005 13:11 |
u0u0
Messages: 9 Registered: August 2005
Karma: 0
|
Junior Member |
|
|
The former mysql configure is
WITH_CHARSET=gbk WITH_XCHARSET=all
I recompiling mysql and remove these options.
it OK now.
thanks!
|
|
|