FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » v2.7.1 SQL Error
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
v2.7.1 SQL Error [message #27117] Sat, 27 August 2005 02:06 Go to next message
u0u0 is currently offline  u0u0   China
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 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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 Go to previous message
u0u0 is currently offline  u0u0   China
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!
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: statistic problem on main page
Next Topic: Parse error in pdf.php
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 11:56:34 GMT 2024

Total time taken to generate the page: 0.03690 seconds