[Ideal Web Tech]

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

Check and make sure that all your db's tables are set to the same collation type as from the error thats telling me that your tables for vbulletin are not all of the same collation type.

You can check this using phpmyadmin. (I dont remember how off the top of my head, If I get time later to look it up I will let you know the steps)