MyBB Community Forums

When i try to run this in task manager I get a error. Please help!

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND allownotices = 1 AND u.uid NOT IN(SELECT uid FROM mybb_rememberus_log WHERE ' at line 1
Query:
SELECT * FROM mybb_users u LEFT JOIN mybb_userfields f ON u.uid = f.ufid WHERE lastactive = AND allownotices = 1 AND u.uid NOT IN(SELECT uid FROM mybb_rememberus_log WHERE rid=1 OR rid=0) LIMIT 25

you have included the lastactive field,but assigned no valid value to it in the reminder criteria

I don't see anywhere I can edit this. it is not under board settings

you need to edit the reminder, scroll to the bottom where you set the criteria and see if you have a lastactive field there. if so, either remove it or add a value like "- 6 month" or an actual date code

thanks so much!

---

one more question... How can I tell when emails go out? I ran it in task manager but it's not showing a log of a email that was sent out.