The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
vb3: DB Error when searching FAQ??
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? |
#2
|
|||
|
|||
This is a MySQL "problem". Please look at:
http://www.vbulletin.com/forum/bugs....iew&bugid=3627 http://www.vbulletin.com/forum/showthread.php?t=125929 |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
it's fixed in the latest version of mysql anyway I believe.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|