[jgommel]

Not sure if this a 3.6.2 issue, but I just intalled and now I'm getting database errors. If I deactivate the hack, I'm back to normal. I checked my Template edits... all there and correct according to the documentation.

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
usergroup.usergroupid, usergroup.title,
groupa.opentag as opentaga, groupa.closetag as closetaga, 
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb_subscriptionlog AS subscriptionlog
LEFT JOIN vb_user ON (subscriptionlog.userid = user.userid)
LEFT JOIN vb_usergroup ON(user.usergroupid = usergroup.usergroupid)
LEFT JOIN vb_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, 5;

MySQL Error  : Unknown table 'user' in field list
Error Number : 1109
Date         : Tuesday, October 10th 2006 @ 03:35:33 PM
Script       : http://www.website.com/vb/
Referrer     : http://www.website.com/index.php
IP Address   : xx.xx.xx.xx
Username     : xxxxxxxx
Classname    : vb_database

and

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
usergroup.usergroupid, usergroup.title,
groupa.opentag as opentaga, groupa.closetag as closetaga, 
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb_subscriptionlog AS subscriptionlog
LEFT JOIN vb_user ON (subscriptionlog.userid = user.userid)
LEFT JOIN vb_usergroup ON(user.usergroupid = usergroup.usergroupid)
LEFT JOIN vb_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, 5;

MySQL Error  : Unknown table 'user' in field list
Error Number : 1109
Date         : Tuesday, October 10th 2006 @ 03:36:30 PM
Script       : http://www.website.com/index.php
Referrer     : http://www.website.com/index.php
IP Address   : xx.xx.x.xx
Username     : xxxxxx
Classname    : vb_database

Site Stats:
Apache Server 1.3.37 (Unix)
PHP 4.4.4
MySQL 4.1.21
vBulletin 3.6.2
vBadvanced CMPS 2.2.0