The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2007, 12:11 AM
JonnyF JonnyF is offline
Junior Member
 
Join Date: Jan 2007
Posts: 29
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Gazette License Holder 
Default SQL Error

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)

Code:
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 ?
__________________
MMORPG Forum WoW / RO Guides and Exploits.
Reply With Quote
  #2  
Old 07-09-2007, 07:47 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

What about your post pagetext field?
Reply With Quote
  #3  
Old 07-09-2007, 11:56 AM
JonnyF JonnyF is offline
Junior Member
 
Join Date: Jan 2007
Posts: 29
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Gazette License Holder 
Default

well it is latin1_swedish_ci of course.
__________________
MMORPG Forum WoW / RO Guides and Exploits.
Reply With Quote
  #4  
Old 07-09-2007, 12:43 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Can you change the gars.synopsis to latin1?
Reply With Quote
  #5  
Old 07-09-2007, 08:50 PM
JonnyF JonnyF is offline
Junior Member
 
Join Date: Jan 2007
Posts: 29
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Gazette License Holder 
Default

it is fixed now, thank you very much.
If there occours more sql errors later, i will add them here.
__________________
MMORPG Forum WoW / RO Guides and Exploits.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL error trana Geek Article and Review System 1 12-12-2006 10:49 PM
SQL error Scribbller Geek Article and Review System 0 12-12-2006 04:50 PM
Big SQL error after reinstall utw-Mephisto Geek Article and Review System 1 07-14-2006 06:46 AM
Weird SQL Error when trying to go to "Next Article" Mithan Geek Article and Review System 2 07-11-2006 05:55 PM
GAB Issue Mark All Forums Read SQL Error Michael-MI Geek Advertising Banner System 2 02-12-2006 04:07 PM


All times are GMT. The time now is 08:28 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.