| dennisuello |
08-24-2006 03:04 PM |
I received a DB error when I installed this. I promptly uninstalled it, as to not keep my forum down.
Quote:
Invalid SQL:
SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb3_subscriptionlog AS subscriptionlog
LEFT JOIN vb3_user ON (subscriptionlog.userid = user.userid)
LEFT JOIN vb3_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb3_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, 5;
MySQL Error : Unknown column 'user.userid' in 'field list'
|
Quote:
Invalid SQL:
SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscription.title, 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 < 1159026430
GROUP BY subscription.title
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;
MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
|
Quote:
Invalid SQL:
SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb3_subscriptionlog AS subscriptionlog
LEFT JOIN vb3_user ON (subscriptionlog.userid = user.userid)
LEFT JOIN vb3_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb3_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, 5;
MySQL Error : Unknown column 'user.userid' in 'field list'
|
Quote:
Invalid SQL:
SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscription.title, 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 < 1159026435
GROUP BY subscription.title
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;
MySQL Error : Unknown column 'subscriptionlog.userid' in 'on clause'
|
|
More Information