
08-26-2006, 01:23 AM
|
 |
|
|
Join Date: Dec 2002
Location: Las Cruces, NM
Posts: 473
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I'm getting the same message -- running 3.5.2
Quote:
Database error in vBulletin 3.5.2:
Invalid SQL:
SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscription.title, subscriptionlog.expirydate,
user.userid, user.username
FROM subscriptionlog AS subscriptionlog, subscription AS subscription
LEFT JOIN user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 1 AND subscriptionlog.expirydate < 1159150769
GROUP BY subscription.title
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;
MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
Error Number : 1054
|
|