I've started getting this error:
Code:
Database error in vBulletin 3.0.1:
Invalid SQL:
SELECT subscriptionlog.subscriptionid, subscriptionlog.userid, subscriptionlog.expirydate,
user.username, user.email, user.languageid
FROM subscriptionlog AS subscriptionlog
LEFT JOIN user AS user ON (user.userid = subscriptionlog.userid)
WHERE subscriptionlog.expirydate >= 1085982016
AND subscriptionlog.expirydate <= 1086068416
AND status = 1
mysql error: Column: 'status' in where clause is ambiguous
mysql error number: 1052
Date: Saturday 29th of May 2004 12:40:17 AM
Script: http://www.mobileforces.org/forums/cron.php?&rand=923340
Referer: http://mobileforces.org/forums/index.php?
It applies randomly across many users and guests - and I'm guessing it is linked to the random running of the cron scripts - but I can't seem to find where the code for this Query is? On looking at the table, I need to add a subscriptionlog. in front of the status reference in the WHERE clause, but I can't find the query ...
Anyone ?
05-29-2004, 05:17 AM
SQL error - probably hack related...
Hybrid Mode
