vb3: DB Error when searching FAQ??

[mkdevo]

most of the time, when i try to search for keywords in my FAQ, i get the following db error:

Database error in vBulletin 3.0.7:

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_threadedmode')
OR
faqname IN('vb_threadedmode')
)

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

mysql error number: 1267

Date: Wednesday 23rd of March 2005 08:36:58 AM
Script: http://www.thebreakfast.info/forum/faq.php?s=&do=search&q=four&match=all&titlesonly=0
Referer: http://www.thebreakfast.info/forum/faq.php?

can anyone explain this?

[Marco van Herwaarden]

This is a MySQL "problem". Please look at:
http://www.vbulletin.com/forum/bugs.php?do=view&bugid=3627
http://www.vbulletin.com/forum/showthread.php?t=125929

[theinz]

Guys, I found a solution to this problem. I had this on my site as well. If you have phpymyAdmin with your host provider do the following:

1. Open vb_phrase in your VB database
2. Click on structure
3. Select the change icon next to "varname"
4. Change the COLLATION to latin1_swedish_ci

This will fix the problem.

tony

[Paul M]

it's fixed in the latest version of mysql anyway I believe.