vb.org Archive - vb3: DB Error when searching FAQ??

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - vb3: DB Error when searching FAQ?? (https://vborg.vbsupport.ru/showthread.php?t=78612)

mkdevo

03-23-2005 11:38 AM

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?

can anyone explain this?

Marco van Herwaarden

03-23-2005 12:22 PM

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

theinz

05-22-2005 11:12 AM

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

05-22-2005 12:21 PM

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

All times are GMT. The time now is 04:59 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00931 seconds Memory Usage 1,716KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: