Problem when searching FAQs

[Dragon]

I went to search the FAQs on my own system and got this:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT faqname, faqparent, phrase.text AS title
FROM faq AS faq
INNER JOIN phrase AS phrase ON(phrase.phrasetypeid = 7000 AND phrase.varname = faq.faqname)
WHERE phrase.languageid IN(-1, 0, 1)
AND (
faqparent IN('vb_why_register', 'vb_referrals_explain')
OR
faqname IN('vb_why_register', 'vb_referrals_explain')
)

mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

SWEDISH? Does anyone know where this is coming from or how to fix it? Maybe it will fix my other problems....thanks in advance.

[Floris]

Hello,

Apologies for the late reply.

I believe this is due to an issue with MySQL. Upgrade MySQL to the latest version and this issue should be resolved.

[poi@nwdnb]

As i understand it, this is a problem with MySQL 4.1.7. See this thread http://www.vbulletin.com/forum/showthread.php?t=121120 - there is a fix at the bottom which worked for me.

[Dragon]

Brilliant!

Instant fix...thank you!!!

[Floris]

Instant fix...thank you!!!

Happy to hear that worked out for you and nice to see it fixed so soon. Enjoy the FAQ engine from vBulletin! And please let me know if you require any further assistance.