Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 15 Jan 2010, 13: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 14: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 19:10 ---------------

anyone?

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

will pay for a fix???

Last edited by idoL1; 16 Jan 2010 at 06:19. Reason: Auto-Merged DoublePost
Reply With Quote
Comments
  #2  
Old 25 Jan 2010, 04: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"?
__________________
Reply With Quote
  #3  
Old 04 Feb 2010, 08: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.
Reply With Quote
  #4  
Old 04 Feb 2010, 22: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.
__________________
Reply With Quote
  #5  
Old 08 Feb 2010, 11: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!
Reply With Quote
Reply



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

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
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 21:17.

Layout Options | Width: Wide Color: