[Virtualshiner]

Hi,

I know that vB 3.8 RC 1 is 'Install at own risk' but we are having a database error with the Social Groups and member profiles.

The error is as follows:

Database error in vBulletin 3.8.0 Release Candidate 1:

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   : Table 'vfkforum_site.socialgroupcategory' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, December 3rd 2008 @ 01:45:17 PM
Error Date    : Wednesday, December 3rd 2008 @ 01:45:17 PM
Script        : http://www.vfkforums.com/forums/group.php
Referrer      : 
IP Address    : **.***.***.**
Username      : **********
Classname     : vB_Database
MySQL Version : 5.0.51a-community

That is when accessing the group.php file
The more important one is member profiles and that is:

Database error in vBulletin 3.8.0 Release Candidate 1:

Invalid SQL:

				SELECT socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, sgicon.dateline AS icondateline,
					sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
				FROM socialgroupmember AS socialgroupmember
				INNER JOIN socialgroup AS socialgroup ON
					(socialgroup.groupid = socialgroupmember.groupid)
				LEFT JOIN socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid
				WHERE
					socialgroupmember.userid = 1603
					AND socialgroupmember.type = 'member'
				ORDER BY socialgroup.name;

MySQL Error   : Table 'vfkforum_site.socialgroupicon' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, December 3rd 2008 @ 01:50:51 PM
Error Date    : Wednesday, December 3rd 2008 @ 01:50:51 PM
Script        : http://www.vfkforums.com/forums/member.php?u=1603
Referrer      : http://www.vfkforums.com/forums/
IP Address    : **.***.***.**
Username      : **********
Classname     : vB_Database
MySQL Version : 5.0.51a-community

Can anyone help on how to fix this?

Thanks,