Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #1  
Old 15 Jan 2010, 14:59
idoL1 idoL1 is offline
 
Join Date: Feb 2009
Illegal Mix Of Collations

whenever i enable the xml file in the plugins n products i get this error

Invalid SQL:

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

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


when i disable it it goes away...any help? website is www.360icons.com if that helps?

--------------- Added 15 Jan 2010 at 15:35 ---------------

ive tried making tournaments general instead of swedish
and ive tried making users swedish instead of general
its somethinggg to do witht he t.champion i believe wtf does that mean.....the = operation aka t.champion = u.username cannot run so how can i get rid of that operation i dont care if the tournament champion doesnt run because im sure that can be fixed alot easier.....this however MAKES IT SO EVERY SINGLE THREAD U GO 2 gets this error....

--------------- Added 15 Jan 2010 at 20:10 ---------------

anyone?

--------------- Added 16 Jan 2010 at 07:19 ---------------

will pay for a fix???

Last edited by idoL1; 16 Jan 2010 at 07:19. Reason: Auto-Merged DoublePost
Comments
  #2  
Old 25 Jan 2010, 05:55
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Real name: Mark Daniel Martinez
What do you mean by "enable the xml file"?
__________________
  #3  
Old 04 Feb 2010, 09:34
JonnyThunder JonnyThunder is offline
 
Join Date: Apr 2006
He means whenever he installs the product (using the XML file)

I get the same thing and have no other modifications installed.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


I started a new thread with this issue, here.
  #4  
Old 04 Feb 2010, 23:36
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Real name: Mark Daniel Martinez
Since your both having the same issue, see if the link I posted in JonnyThunder's thread is helpful at all.
__________________
  #5  
Old 08 Feb 2010, 12:47
JonnyThunder JonnyThunder is offline
 
Join Date: Apr 2006
I fixed my issue with the instructions I posted in the thread. It's actually a really quick fix!
 



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:09.

Layout Options | Width: Wide Color: