most of the time, when i try to search for keywords in my FAQ, i get the following db error:
Code:
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?
03-23-2005, 11:38 AM
vb3: DB Error when searching FAQ??
Threaded Mode