vb.org Archive - sql error when i try to post a thread

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

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

- - sql error when i try to post a thread (https://vborg.vbsupport.ru/showthread.php?t=207990)

VBUsers

03-11-2009 06:42 AM

sql error when i try to post a thread

this is the error i get

Database error in vBulletin 3.8.1:

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 = 17

            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  : Wednesday, March 11th 2009 @ 12:39:47 AM

Error Date    : Wednesday, March 11th 2009 @ 12:39:47 AM

Script        : http://www.*******.com/newthread.php?do=newthread&f=17

Referrer      : http://www.*******.net/staff-lounge-f17.html

IP Address    : *******

Username      : Steve

Classname     : vb_database

MySQL Version : 4.1.22-standard

TigerC10

03-11-2009 07:48 AM

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

Basically, you must have used a 3rd party tool to do database maintenance/restoration at some point, because your tables are set to different language character sets. Ultimately you're going to need to make sure that your tables are set to the latin1_general_ci collalation setting. One of them, somewhere (like maybe prefixset) is set to latin1_swedish_ci by mistake.

VBUsers

03-11-2009 05:00 PM

thanks and i appreciate it. i got it fixed.

All times are GMT. The time now is 02:13 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01023 seconds Memory Usage 1,732KB 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: