vb.org Archive - SELECT t.champion, u.userid FROM tournaments

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

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - SELECT t.champion, u.userid FROM tournaments (https://vborg.vbsupport.ru/showthread.php?t=178198)

PET	05-05-2008 12:22 PM

SELECT t.champion, u.userid FROM tournaments

Hello,

I have installed ibProArcade on a newly upgraded 3.7. It seems to work, but when I go to read a thread I get:

Code:

Database error in vBulletin 3.7.0:

Invalid SQL:

   SELECT t.champion, u.userid FROM tournaments AS t

   LEFT JOIN user AS u ON (t.champion = u.username)

   WHERE champion<>'';

MySQL Error   : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

Error Number  : 1267

Request Date  : Monday, May 5th 2008 @ 10:19:08 AM

Error Date    : Monday, May 5th 2008 @ 10:19:08 AM

Script        : xxx

Referrer      : hxxx

IP Address    : my ip

Username      : admin

Classname     : vb_database

MySQL Version : 4.1.22-standard-log

MrZeropage

05-05-2008 06:05 PM

try to run this query:

Code:

ALTER TABLE `tournaments` CHANGE `champion` `champion` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL

PET	05-05-2008 07:27 PM

I manualy edited them in phpMyAdmin.

redlabour

05-07-2008 04:39 PM

Does not work....now every Thread is blank if Arcade is active.

@PET - use Threadtitles that are useful at the Searchfunction.

russbo

05-10-2008 08:01 AM

OK, how do we fix this now?

Quote:

SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267

I've searched everywhere, and just cannot find the answer.

Most of my vbulletin tables are "latin swedish" for some reason. But there are some other tables that are latin general; all the other mods and hacks work except this one.

--------------- Added [DATE]1210414215[/DATE] at [TIME]1210414215[/TIME] ---------------

OK, think I fixed it.

Went into PHPMYADMIN, into the Tournaments table, and made that table, and all the relevant tables within that, "latin-swedish". Not sure if being "swedish" or "general" makes a difference, but it works as long as they're all the same. Couldn't get it to work at first, didn't change the tables within Tournaments.

All times are GMT. The time now is 12:52 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02540 seconds Memory Usage 1,719KB 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 (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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: