[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 < 1163203283
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Wednesday, October 11th 2006 @ 07:01:23 PM
Script : http://www.mywebsite.com/community/index.php
Referrer : http://www.mywebsite.com/community/a...ex.php?do=head
IP Address : *********
Username : ********
Classname : vB_Database

Sensite info blocked out. I have followed this to a T and this is the sql error I recieve. I use php and sql 5+.