^ tried that, got the following error:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT COUNT(*) AS groups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.visible DESC, club.name) AS CHAR(255)) AS postgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.discussions DESC, club.name) AS CHAR(255)) AS topicgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.picturecount DESC, club.name) AS CHAR(255)) AS picsgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.members DESC, club.name) AS CHAR(255)) AS hotgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.dateline DESC, club.name) AS CHAR(255)) AS newgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.lastupdate DESC, club.name) AS CHAR(255)) AS activegroups
FROM socialgroup AS club WHERE club.groupid IS NOT NULL;
MySQL Error : Table 'pakfuse_vbulletin_011409.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 09:38:12 PM
Error Date : Sunday, February 8th 2009 @ 09:38:12 PM
Script : [url of my forum]
Referrer : [URL of the group I created]
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-log
|