SQL Error

[JonnyF]

We reinstalled the 2.1.8c because of the german phrase update.
Now we get a SQL Error when trying to open a GARS Forum saying it mixes (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT)

Datenbankfehler in vBulletin 3.6.5:

Invalid SQL:

		SELECT  IF(ga.synopsis, ga.synopsis,post.pagetext) AS preview,
			thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
			thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
			hiddencount, deletedcount
			, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
			, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
			, threadread.readtime AS threadread
			, threadredirect.expires
			, thread.threadprefix, thread.firstpostid, 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 vb_qthread AS thread
			LEFT JOIN vb_qdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			 LEFT JOIN vb_qsubscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
			 LEFT JOIN vb_qthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
			LEFT JOIN vb_qpost AS post ON(post.postid = thread.firstpostid)
			
			LEFT JOIN vb_qthreadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			 LEFT JOIN vb_qgars as ga ON(ga.threadid = thread.threadid) 
		WHERE thread.threadid IN (0,3194) 
		ORDER BY sticky DESC, lastpost DESC;

MySQL-Fehler : Unerlaubte Vermischung der Kollationen (utf8_general_ci,IMPLICIT) und (latin1_swedish_ci,IMPLICIT) für die Operation 'if'
Fehler-Nr.   : 1267
Datum        : Monday, July 9th 2007 @ 01:57:47 AM
Skript       : http://www.ingamers.de/forumdisplay.php?f=151
Referrer     : http://www.ingamers.de/
IP-Adresse   : 80.146.65.138
Benutzername : xxx
Klassenname  : vb_database

Our Forum is running on latin1_swedish_ci, but the GARS mysql tables are all utf-8.

What to do now ?

[The Geek]

What about your post pagetext field?

[JonnyF]

well it is latin1_swedish_ci of course.

[The Geek]

Can you change the gars.synopsis to latin1?

[JonnyF]

it is fixed now, thank you very much.
If there occours more sql errors later, i will add them here.