Messages on Queue are not sent

[reinier]

After Creating, succesfully testing and finally Sending my campaign, my email queue looks like this: (sorry for the formatting):


Start Start Previous Previous (1 - 15 of 385) Next Next End End
Campaign Sort Recipient Name Sort Recipient Email Sort Marketing Message Sort Send On Sort Send Attempts Sort In Process Sort
Comtel Weekly Email For August 31st Dennis Labal Piny xxx@kinyara.co.ug Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st Daniel Onyiah xxx@neptunesoftwareplc.com Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st Daisy Uyirwoth xxx@ug.spedag.com Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st xxx@cmcuganda.com Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st xxxr@utlonline.co.ug Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st xxx@grofin.com Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st xxx@veco-uganda.org Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st xxx@akesu.org Weekly Email 2006-08-01 10:20 0 0
Comtel Weekly Email For August 31st xxx@hfcultd.co.ug Weekly Email 2006-08-01 10:20 0 0


and some 350 more

None of these emails are sent, though. Although the time is now 11:11am ont the first of August, and the mails are supposed to be send at 10:20. There are no errors in the log file.

A previous run had a Send date/time of july 25th, and these messages where also not sent.

I have tried both using the scheduler, pressing the 'Send queued campaign Emails' button, calling the cron.php file and the emailmandelivery.php file directly. Nothing works.

As there is not even an attempt to send the messages (the value is 0), I suspect that the server is in some timewarp, meaning it thinks its in 1998 or something, and it is still waiting for the 1st of August 2006 to happen. Which is strange, because when creating or altering a record, the time is inserted correctly.
That might be related to the error i get here:

08/01/06 10:35:26,614 [456] FATAL SugarCRM - -----> Scheduler got a bad execute time: [ 1999-12-31 21:00:00 GMT-0 ]

which only 1 person has ever reported, and never got an anwser to.


While i keep digging deeper, any tips are highly appreciated.

Sysconfig:
Win2003
PHP Version 5.0.4
Apache 2.0
MySQL 4.1.13
Sugar 4.2.1b (a didnt work either, i upgraded)

[reinier]

I found the cause. I upgraded MrMilks PowerProspecting modules. (which is really cool) and I introduced a bug there, somehow the type if the links was spelled 'contacts' and not 'Contacts' The Campaign module does not mind about that, but the massmailer does.

I'll be fixing the module, when I'm done you can download it from our website

[reinier]

I found it. I upgraded the Powerprospect Module from sugar 3.x to 4.x and there was a small bug in it, which inserted the related_type as 'contact' instead of 'Contact' which does not harm the Campaign module, but made the emailer not select these records once they were in the Queue.

I upgraded the PowerProspect Module acordingly, and it is fixed now.