It doesnt work
Database error in vBulletin 3.8.0:
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 'adforop_000032.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 02:56:10 PM
Error Date : Sunday, February 8th 2009 @ 02:56:10 PM
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log
For some reason didnt add the table prefix to the query, it will query from table socialgroup instead of myprefix_socialgroup.
Can that be fixed?
|