Does this mod work with vb3.7x. I get a database error after installing this mod and doing the template edit:
Code:
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT
socialgroup.groupid,
socialgroup.name,
socialgroup.description,
socialgroup.picturecount,
socialgroup.lastpost,
socialgroup.lastposter,
socialgroup.lastposterid,
socialgroup.lastgmid,
socialgroup.visible,
socialgroup.lastdiscussion,
socialgroup.discussions,
socialgroup.members,
socialgroupicon.dateline
FROM vb_socialgroup as socialgroup
INNER JOIN vb_socialgroupmember as socialgroupmember
ON socialgroup.groupid = socialgroupmember.groupid
LEFT JOIN vb_socialgroupicon as socialgroupicon
ON socialgroupicon.groupid = socialgroup.groupid
WHERE socialgroupmember.userid = 1
GROUP BY name
ORDER BY lastpost DESC;
MySQL Error : Table 'xxxxxxxxx.vb_socialgroupicon' doesn't exist
Error Number : 1146
Request Date : Tuesday, July 14th 2009 @ 06:45:29 PM
Error Date : Tuesday, July 14th 2009 @ 06:45:29 PM
Script : http://www.xxxxxxxx.com/forum.php
Referrer : http://www.xxxxxxxx.com/admincp/index.php?do=head
IP Address : xx.xxx.xx.xxx
Username : xxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-log
Did I miss something???