The Arcive of vBulletin Modifications Site.

mkdevo · #1 03-23-2005, 11:38 AM

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 · #2 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 · #3 05-22-2005, 10: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 · #4 05-22-2005, 11:21 AM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05667 seconds Memory Usage 4,654KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (4)postbit (4)postbit_onlinestatus (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: