Po zainstalowaniu GARS otrzymuję taki błąd:

Kod:

Database error in vBulletin:

Invalid SQL:

		SELECT  IF(ga.synopsis, ga.synopsis,post.pagetext) AS preview,
			thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
			thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
			thread.prefixid, thread.taglist, hiddencount, deletedcount
			
			, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
			
			, threadredirect.expires
			, ga.header_image, ga.synopsis, ga.byline, ga.feature_untill, round((ga.overall_rating/10),0) author_rating, ga.rating_count, ga.overall_rating author_rating_percent, round((ga.avg_rating/10),0) member_rating, ga.avg_rating member_rating_percent, ga.pagecount, ga.custom2
		FROM vb3_thread AS thread
			LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			
			
			 LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid) 
			
			LEFT JOIN vb3_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			 LEFT JOIN vb3_gars as ga ON(ga.threadid = thread.threadid) 
		WHERE thread.threadid IN (0,64414) 
		ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,IMPLICIT) for operation 'if'
Error Number  : 1267
Request Date  : xxx
Error Date    : xxx
Script        : xxx
Referrer      : xxx
IP Address    : xxx
Username      : xxx
Classname     : xxx
MySQL Version : 5.0.51a-24+lenny5

Da to się jakoś załatać ?

Wydaje mi się czy instalujesz skrypt pisany dla vB 3.5 na vB 3.8?

Wg info jest kompatybilny ze wszystkimi 3.x GARS does not work with VB3.7+ - The vB Geek


EDIT:

Znalazłem wstępne rozwiązanie tylko potrzebna wskazówka co i jak mam zmienić:

http://www.thevbgeek.com/showthread....highlight=1267

Sprawdź czy tabela moda ma takie samo kodowanie jak reszta tabel bazy.

Dzięki, za pomoc. Wszystko działa poprawnie.