vb.org Archive - Error Number : 1267

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

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

- - Error Number : 1267 (https://vborg.vbsupport.ru/showthread.php?t=201091)

adhmwagde

01-08-2009 05:23 PM

Error Number : 1267

PHP Code:


		
			
Invalid SQL:

            SELECT prefix.*, prefixpermission.usergroupid AS restriction
            FROM forumprefixset AS forumprefixset
            INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
            INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
            LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
            WHERE forumprefixset.forumid = 2
            ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error   : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Thursday, January 8th 2009 @ 11:21:50 PM
Error Date    : Thursday, January 8th 2009 @ 11:21:50 PM
Script        : [url]http://www.alshohooh.ws/vb/newthread.php?do=newthread&f=2[/url]
Referrer      : [url]http://www.alshohooh.ws/vb/forumdisplay.php?f=2[/url]
IP Address    : 41.178.144.86
Username      : &#1575;لدعم الفني
Classname     : vB_Database
MySQL Version : 5.0.51a-community

Bellardia

01-08-2009 06:09 PM

All your tables should have the same collation, the vb default is latin1_swedish_ci.

UKBusinessLive

01-08-2009 06:51 PM

Thats Right, This is from Wayne Luke over at the VBulletin.com site

All tables and fields should be the same collation to prevent this error from occuring in the future. It can occur on other queries not just when upgrading if there are mixed collations. When vBulletin creates new tables and fields it will use the default of the database for the collation. This is usually latin1_general_ci unless you change it. You can see instructions on how to change a database's collation settings in the MySQL manual.

;)

All times are GMT. The time now is 01:03 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01663 seconds Memory Usage 1,722KB 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_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: