[Virtualshiner]

We have done that but the error still appears.

--------------- Added [DATE]1226150911[/DATE] at [TIME]1226150911[/TIME] ---------------

Okay well what I did was found that table in the database and this is what it shows:

SELECT COUNT( * ) AS `Rows` , `socialgroupcategoryid` 
FROM `socialgroupcategory` 
GROUP BY `socialgroupcategoryid` 
ORDER BY `socialgroupcategoryid` 
LIMIT 0 , 30

and this is the error:

Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:
SELECT cat.socialgroupcategoryid AS categoryid, cat.title, COUNT(socialgroup.groupid) AS total
				
				FROM socialgroupcategory AS cat
				LEFT JOIN socialgroup AS socialgroup
				 ON (socialgroup.socialgroupcategoryid = cat.socialgroupcategoryid)
				
				WHERE socialgroup.groupid IS NOT NULL
				
				GROUP BY cat.socialgroupcategoryid
				ORDER BY total
				LIMIT 0, 40;

MySQL Error   : Unknown column 'socialgroup.socialgroupcategoryid' in 'on clause'
Error Number  : 1054
Request Date  : Saturday, November 8th 2008 @ 07:28:16 AM
Error Date    : Saturday, November 8th 2008 @ 07:28:16 AM
Script        : http://www.vfkfansite.com/forums/group.php
Referrer      : 
IP Address    : **.***.***.***
Username      : **********
Classname     : vB_Database
MySQL Version : 5.0.51a-community

--------------- Added [DATE]1226151913[/DATE] at [TIME]1226151913[/TIME] ---------------

We also have another one now, any help?

Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:

			REPLACE INTO prefixpermission (usergroupid, prefixid)
			SELECT 35, prefixid FROM prefix
			WHERE options & 1;

MySQL Error   : Unknown column 'options' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, November 8th 2008 @ 07:43:58 AM
Error Date    : Saturday, November 8th 2008 @ 07:43:58 AM
Script        : http://www.vfkfansite.com/forums/admincp/usergroup.php?do=update
Referrer      : http://www.vfkfansite.com/forums/admincp/usergroup.php?do=add