[ishare]

I have a serious problem with Video Directory which is not caused by script itself. After installation, i got below error and couldnt/cant run this hack.

Database error in vBulletin 3.8.2:

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 6;

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

I did "ALTER DATABASE db_name CHARACTER SET latin5" through phpmyadmin but nothing changed.

Anyone can help ?