[havard20009]

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT video.*, user.*, IF(video.ratingnum > 0, video.ratingtotal / video.ratingnum, 0) AS ratingavg, IF(NOT ISNULL(user.userid), user.username, video.username) AS username
FROM video AS video
LEFT JOIN user AS user ON(user.userid = video.userid)
WHERE video.videocategoryid IN(0,1)
ORDER BY dateline DESC
LIMIT 5;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (cp1251_general_ci,IMPLICIT) for operation 'if'
Error Number : 1267
Request Date : Wednesday, November 4th 2009 @ 04:14:59 AM
Error Date : Wednesday, November 4th 2009 @ 04:14:59 AM
Referrer :
IP Address : 94.183.76.243
Username : EMO
Classname : vB_Database
MySQL Version : 5.0.81-community-log