mySQL complaint on running cron; no email sent

cbcafiero - October 5, 2007 - 10:30
Project:Account reminder
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:critical
Assigned:jaydub
Status:closed
Description

Cron reports the following error.

user warning: Unknown table 'account_reminder' in where clause query: DELETE d_account_reminder.* FROM d_account_reminder,d_users WHERE account_reminder.uid=users.uid AND access!=0 AND users.uid!=0 AND status=1 in [PATH-INFO-HERE]/includes/database.mysql.inc on line 172.

However table d_account_reminder exists. I can see records in table.

I think this is the fix (line 124, account_reminder.module):

//Remove users who have signed up from the reminder table...
$result=db_query("DELETE {account_reminder}.* FROM {account_reminder},{users} WHERE {account_reminder}.uid={users}.uid AND access!=0 AND {users}.uid!=0 AND status=1");

But still no mail!

It looks like this might need correction

drupal_mail('acount_reminder_email',$email, $subject, $body, $from);

to

drupal_mail('account_reminder_email',$email, $subject, $body, $from);

No?

Forgive my ignorance: Is there a separate account_reminder_email module?

Please help. Functionality of this module would be great to have! Thanks.

#1

the1who - October 16, 2007 - 08:39

I have the same problem with my installation of this module. I have been waiting at least since May for a reply, here is my post: http://drupal.org/node/139947

I too agree that it'd be nice to have this functionality. I know a lot of my members from our club have joined up but have yet to sign on it so using this feature would help remind them besides me having to do it all of the time. I hope something is to come of this.

Matt

#2

jaydub - March 16, 2008 - 15:32
Assigned to:Anonymous» jaydub

#3

jaydub - March 28, 2008 - 12:18

Please try out the current -dev release to see if it fixes your problems.

#4

jaydub - April 20, 2008 - 12:29
Status:active» fixed

clearly not a problem anymore...

#5

Anonymous (not verified) - May 4, 2008 - 12:33
Status:fixed» closed

Automatically closed -- issue fixed for two weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.