I get the following error messages:

" * user warning: You have an error in your SQL syntax near 'account_reminder.* FROM account_reminder,users WHERE account_reminder.uid=users.' at line 1 query: DELETE account_reminder.* FROM account_reminder,users WHERE account_reminder.uid=users.uid AND access!=0 AND users.uid!=0 AND status=1 in /home/bsarc/public_html/includes/database.mysql.inc on line 172.
* user warning: You have an error in your SQL syntax near '(NOW(), b.last_reminder) AS date_diff FROM users a LEFT JOIN account_reminder b ' at line 1 query: SELECT a.*, b.msg_cnt, DATEDIFF(NOW(), b.last_reminder) AS date_diff FROM users a LEFT JOIN account_reminder b ON b.uid=a.uid WHERE a.access=0 AND a.uid!=0 AND status=1 in /home/bsarc/public_html/includes/database.mysql.inc on line 172."

I also checked the DB and the table is there, however no individual data is present for the accounts within the table, are they store on different table? I'm assuming I get the error messages because it's not showing in the account_reminder table but I don't know exactly what I am looking for. Your assistance or anyones will be appreciated so I can continue to use this module. There are other members of the site that are going to be using this, that aren't as technically advised and if they see the red error messages, they are more bound to turn off this useful module, so I'm trying to get this going before they start messing with it if you know what I mean. Thanks in advance, sorry if I forgot anything that would be of use, not sure what you need.

-Matt

Comments

the1who’s picture

Oh, and the e-mail was never sent, I set it for 1 day, still waiting after 15 min on the test account I'm working with, so I know that parts not working too.

skwark’s picture

Priority: Normal » Critical
Status: Active » Closed (duplicate)

I've got the same problem with the mySQL syntax error.

the1who’s picture

Any updates? I thought it was fixed when I did a reinstall pretty much, but it still doesn't send reminder e-mail, since I tested it here today with the notification e-mail to be sent today, it didn't send. cron.php still shows same error messages, so just checking, wondering how things are progressing to a fix. Thanks!

Matt