FAQ searching problem

[Ploy1886]

Everytime someone searches the FAQ, this gets returned:

Database error in vBulletin 3.0.3:

Invalid SQL: 
		SELECT faqname, faqparent, phrase.text AS title
		FROM vb_faq AS faq
		INNER JOIN vb_phrase AS phrase ON(phrase.phrasetypeid = 7000 AND phrase.varname = faq.faqname)
		WHERE phrase.languageid IN(-1, 0, 1)
			AND (
			faqparent IN('vb_censor_explain', 'vb_edit_posts', 'vb_read_and_post', 'vb_special_codes', 'vb_announce_explain', 'vb_attachment_explain', 'vb_avatar_how', 'vb_board_search', 'vb_buddy_explain', 'vb_calendar_how', 'vb_email_member', 'vb_email_notification', 'vb_memberlist_how', 'vb_message_icons', 'vb_moderator_explain', 'vb_pm_explain', 'vb_poll_explain', 'vb_rss_syndication', 'vb_sig_explain', 'vb_smilies_explain', 'vb_threadedmode', 'vb_use_cookies', 'vb_vbcode_toolbar', 'vb_why_register')
			OR
			faqname IN('vb_censor_explain', 'vb_edit_posts', 'vb_read_and_post', 'vb_special_codes', 'vb_announce_explain', 'vb_attachment_explain', 'vb_avatar_how', 'vb_board_search', 'vb_buddy_explain', 'vb_calendar_how', 'vb_email_member', 'vb_email_notification', 'vb_memberlist_how', 'vb_message_icons', 'vb_moderator_explain', 'vb_pm_explain', 'vb_poll_explain', 'vb_rss_syndication', 'vb_sig_explain', 'vb_smilies_explain', 'vb_threadedmode', 'vb_use_cookies', 'vb_vbcode_toolbar', 'vb_why_register')
		)
	
mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

mysql error number: 1267

Date: Monday 24th of January 2005 01:07:29 AM
Script: http://forums.moneysavingexpert.com/faq.html?s=&do=search&q=post&match=all&titlesonly=0
Referer: http://forums.moneysavingexpert.com/faq.html?
Username: (hidden)
IP Address: (hidden)

Any ideas as to what the problem might be?

[Steve Machol]

This is a problem with MySQL 4.1.x:

http://www.vbulletin.com/forum/bugs.php?do=view&bugid=3627

http://www.vbulletin.com/forum/showthread.php?t=125929