sugar v5 email campaign not emailing

[hodgson]

[edit]
My OS is windows Vista, that is what is running the site.
IIS7 is the web server
Im using sugar version 5, I downloaded it just a few days ago
my PHP version is 5.2.5
[/edit]
OK,
Ive read the admin manual and a number of threads here. Ive read about how I am suposed to set up these campaigns. I am able to send an email throught the regular email client in sugar, but email campaigns are not working.

When I create an email campaign, the mail that it should send just sits in the mail queue indefinitly. The default schedulers are currently set to run as often as posible (crontab input of all * ). The schedulers page shows things running as often as posible, this includes tasks named:
Run nightly mass email
Run nightly process bounced campaign email
Check inbound mail boxes

these tasks have activity logs on the schedulers screen, these show no activity. The schedulers themselves show that they have never executed. How Do I get these to start?

so why is my email queue filling up and not sending? there is a collumn there for "Send Attempts" this is 0 for all the messages.

Is there some other setting that is preventing the email queue from getting sent?
every record i can find is listed as active, nothing is disabled as far as I can tell.

[hodgson]

I performed a diagnostic from the admin page and I noticed this in the log file "sugarcrm.log":

12/20/07 08:41:43,716 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 08:43:38,163 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 08:47:04,132 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 08:47:15,721 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 08:48:26,171 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 08:48:41,923 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 08:49:44,933 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 08:50:14,199 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 09:34:17,373 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 10:00:33,872 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
12/20/07 10:36:52,377 [6140] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by

....
im not sure what this error message indicates, but perhaps it is related to my email queue problem?

[Hauke]

Hi Hodgson,

Did you activate the crontab job from the server side? There is an older comment stating:

...create a new cron job at your linux, supposing your htdocs is located at /var/www:

Add this line to your crontab: * * * * * cd /var/www/your_sugar; php -f cron.php > /dev/null 2>&1

Don't miss to replace the first asterisk with a value in crontab format. So the job will be done in the intervall you give. When you execute this line containing only asterisks it will run only once.

I hope this might help you.

[hodgson]

Thanks for the suggestion Hauke,

I am running on a windows system (vista), so im not 100% certain how to activate the cron job server side.
I realize i should have posted my OS in the original post, I will now go back and edit this if I can.

I mentioned the crontab format because it is mentioned on the page where the schedulers are configured. I will go there are edit these values as you have mentioned (having a value in the minutes box other than * so that it runs more than once. Then I will test things again to see if that fixes the issue.

In the mean time any additional suggestions are still welcome!

[hodgson]

hmmm
Still no luck.
The email queue is still getting populated, but the "send attempts" is stuck at 0.

the advanced setting for my schedulers have been checked, here are the settings:
Job function::runMassEmailCampaign Status Active
Date & Time Start 01/01/2005 01:15am Active From 01:00am
Date & Time End perpetual Active To 11:59pm
Last Successful Run Never Interval As often as possible.
Execute If Missed Always
Date Created: 12/18/2007 11:42am by Last Modified: 12/20/2007 02:01pm by admin

in the advanced options:
min Hours date Mo Day
*/1 * * * *

is this Ok? will this setting run more than once?
On a windows system, do I need to set up scheduled tasks or something of that nature?

[eddy]

hodgson,

in the schedulers list view page, there is a blurb that reads something like:

To Setup Windows Scheduler:
Create a batch file with the following commands:
cd <Current Working Directory>
php.exe -f cron.php

Have you tried this yet? If you haven't, then take a look at this thread, it goes over how to set up your windows batch file.
http://www.sugarcrm.com/forums/showthread.php?t=7952

--eddy

[hodgson]

Thank you Eddy !!
This is no doubt the piece i was missing. Dont know how I missed it, but there it is.

Next Problem:
It still isnt working

when I ran the commands via command line, i got these results:
C:\>c:\PHP\php-cgi.exe -c c:\windows\php.ini -f cron.php
No input file specified.
Error in my_thread_global_end(): 1 threads didn't exit

so I tried running it again:
C:\>c:\PHP\php-cgi.exe -c c:\Windows\php.ini -f cron.php
No input file specified.

Ok, Now I go into the task scheduler (in windows) and make sure my task is running. I have to manualy start it this time, but that should be OK, it runs every few minutes.
So I wait for a few minutes.

The sugar scheduled tasks still state that have never executed. I am thinking the first error message from above is the issue.

[hodgson]

OK,
after much friggin in the riggin '

i think its all sorted out now...
I simply had to make sure that the file paths where correct.
c:\PHP>c:\PHP\php-cgi.exe -c c:\windows\php.ini -f D:\Sugar5\SugarCE-Full-5.0.0\cron.php
111111111Error in my_thread_global_end(): 2 threads didn't exit

but im still getting an error message!
and,
My email queue IS getting cleared out, but the emails are not getting delivered. I think this points to a different issue. I will now go and review my various email settings.