FAQ Database Error

[Weapon-x]

I keep getting this error when I do a search in FAQ for a word

Database error in vBulletin 3.0.7:

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

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

mysql error number: 1267


What does it mean? And how do I fix it?

[Steve Machol]

This is a bug in MySQL 4.1.x. Please see these threads:

Bug report:

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

Workaround:

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

Also MySQL 4.1.12 has fixed this problem so you could upgrade to this version.

http://www.vbulletin.com/forum/showthread.php?p=866464#post866464

[Weapon-x]

Hey steve I am going to email my host on what version of MySql they are using and what is the newest version. Then ill post in the same topic on about how to switch the version of mysql on the vbulletin forum or should it be reinstalled?

[Steve Machol]

All they need to do is upgrade to MySQL 4.1.12 and this will be solved. You will not have to do anything to your forums.

[Weapon-x]

By the way what is the newest version of mysql?

[Steve Machol]

The newst 'stable'' release is 4.0.24. The 4.1.x series is still too new. However if they are going to run it, they should upgrade to 4.1.12.

[Weapon-x]

Here they are running
4.3.10

I got that from my vbulletin admincp phpinfo so what does that mean and what should we do?

[Steve Machol]

That is the PHP version. What I meant was that you need to upgrade to MySQL 4.1.12 to fix this problem. Either that or downgrade to 4.0.24.

[Weapon-x]

I found a thing you run in Myphpadmin you run

ALTER TABLE faq CHANGE faqname faqname VARCHAR(250) BINARY NOT NULL

If you have a table prefix 'xdb' where do you put the prefix on the code above at? And does that code correct the problem? And is it a secure code?

[Steve Machol]

ALTER TABLE xdb_faq CHANGE faqname faqname VARCHAR(250) BINARY NOT NULL

[Weapon-x]

Alright thanks it works