My site is getting an error! help

Grinderhand

New Member
Since you have already tried installing this mod incorrectly once, my suggestion at this point would be to uninstall the mod completely including deleting all misplaced and correctly placed files/folders, template edits (if there were any), and the product xml itself and start the install all over again, as something seems to be screwing up the works. I'm assuming your forum was working correctly before attemting the install, so the uninstall/reinstall should cure it.
 

Hoxxy

New Member
Current error:
Code:
Database error in vBulletin 3.8.1:

Invalid SQL:

			SELECT 
				aw.id AS id
				,aw.postid AS postid
				,SUM(aw.amount) AS points
				,COUNT(*) AS count
				,IF(COUNT(*) > 1,GROUP_CONCAT(aw.comment),aw.comment) AS comment
				,aw.from AS userid
				,aw.to AS receiver
				
				
			FROM `kbank_donations` AS aw
			
			WHERE aw.postid in (834,836)
				
			GROUP BY aw.postid,aw.from
			ORDER BY aw.time ASC;;

MySQL Error   : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '(aw.comment),aw.comment) AS comment
				,aw.from AS userid
				
Error Number  : 1064
Request Date  : Sunday, April 12th 2009 @ 09:21:23 PM
Error Date    : Sunday, April 12th 2009 @ 09:21:24 PM
Script        : http://xxxxx.com/showthread.php?p=836
Referrer      : http://xxxxx.com/
IP Address    : xx.xx.xx.xx
Username      : Unregistered
Classname     : vb_database
MySQL Version :

This tells me the mod your using maybe out of date ie: not compatible with 3.8.1

Follow these steps...
http://www.vbteam.info/how/20215-basic-fix-product-problems.html

then try to login and uninstall the pesky mod
 
Top