| Virtualshiner |
12-03-2008 05:47 PM |
Database Error
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:
Code:
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:
Code:
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, |
More Information