Sql Hatasından Anlayan ?

14-11-2009, 19:29:05

Merhaba arkadaşlar video dirctory eklentisini kurdum ve aşağıda ki hatayı verdi sanırım akrakter kodlaması ile ilgili ama tam anlayamadım..

Database error in vBulletin 3.8.4:

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)
				ORDER BY RAND() DESC
				LIMIT 3;

MySQL Error   : Illegal mix of collations (latin5_turkish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'if'
Error Number  : 1267
Request Date  : Saturday, November 14th 2009 @ 09:24:50 AM
Error Date    : Saturday, November 14th 2009 @ 09:24:50 AM
Script        : http://www.gothicturkey.net/gothicworld.php
Referrer      : http://www.gothicturkey.net/video.php
Classname     : vB_Database
MySQL Version : 5.0.45

14-11-2009, 20:42:59

#2

eftal

Herhangi bir hata göremedim ben forumda.Ayrıca siteye girince korktum ya

14-11-2009, 20:45:27

#3

GothicTurkey

Hocam hata göremezsin çünkü eklentiyi kaldırdım (: eklentiyi kurunca verdiği hata yukarıda..