FAQ - MySQL errors

[Marc]

I just received notice of several MySQL errors that appear related to the vBulletin FAQ engine.

When we set up the new server, the latest copies of MySQL and PHP were installed. MySQL has some backward compatability issues which we think we've addressed. This *appears* to be related a language issue but we're not sure yet.

If you're having any problems with the FAQ, please let me know in this thread. This is the error:

Database error in vBulletin 3.0.6:

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_poll_explain')
OR
faqname IN('vb_poll_explain')
)

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

mysql error number: 1267

Date: Tuesday 22nd of February 2005 11:27:16 AM
Referer: https://elsmar.com/elsmarqualityforum/faq.php?
Username: dlschneider

 

[Al Dyer]

Marc,


I typed in a few words and tried a search with"no results" as the response, even when I typed in "quality". I also got this error message:

There seems to have been a slight problem with the The Elsmar Cove database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Al...

 

[Marc]

I think I have this fixed. If any of you folks want to try out searching in the FAQ to help test, let me know what happens here, please.