[dennisuello]

Originally Posted by whitetigergrowl

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

I get the same error

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
Date : Monday, November 27th 2006 @ 11:24:25 AM
Script : http://www.reno4x4.com/forum/
Referrer : http://www.reno4x4.com/
IP Address : ******
Username : ******
Classname : vB_Database