[whitetigergrowl]

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM vb_subscriptionlog AS subscriptionlog, vb_subscription AS subscription
LEFT JOIN vb_user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 1 AND subscriptionlog.expirydate < 1163215075
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 10:17:55 PM
Script : http://www..com/community/index.php
Referrer : http://www..com/community/admincp/index.php?do=head
IP Address :
Username :
Classname : vB_Database

Tried both. This is the error with the update one. (Minus sensitive info)