[Caddyman]

Originally Posted by chadi

I'm getting this error:


Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT g.dateline AS sonmesajtarih, g.gmid, s.description, g.pagetext, g.postuserid, g.postusername, s.groupid, s.dateline, s.name, s.lastposter, s.lastposterid, g.state, s.visible, s.lastgmid, s.lastpost, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM groupmessage AS g
LEFT JOIN socialgroup AS s ON (g.gmid = s.lastgmid)
LEFT JOIN user AS user ON(user.username = g.postusername)
WHERE g.state = 'visible' AND s.visible > '0'
ORDER BY g.dateline DESC
LIMIT 0, 10;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Sunday, July 6th 2008 @ 02:08:35 PM
Error Date : Sunday, July 6th 2008 @ 02:08:35 PM
Script : http://www.talkjesus.com/group.php
Referrer : http://www.talkjesus.com/
IP Address : *****
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.51a-community

i got the same thing