Database Error

[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,

[Lynne]

Did you run the upgrade script? Those tables should have been created then.

[Virtualshiner]

We have found the problem and believe have been fixed.

Sorry for the thread,

VS