i get this when i run promotionpost from cron..
Quote:
Database error in vBulletin 3.5.7:
Invalid SQL:
SELECT user.userid, user.usergroupid as usergroupid, user.joindate as joindate, user.lastvisit as lastvisit, user.lastpost as lastpost, user.posts as posts, post.userid as huserid, count(postid) as totalpost
FROM vb_user LEFT JOIN vb_post ON user.userid = post.userid
WHERE dateline >= 1168016694 AND dateline < 1170435894 AND lastpost > 1170003894 AND lastvisit > 1170003894 AND joindate <= 1170003894 AND posts >= 45 AND usergroupid = 2 GROUP BY huserid HAVING totalpost >= 40;
MySQL Error : Unknown table 'user' in field list
Error Number : 1109
|