Auto-Reply doesnt send the email...

**adaml** · 2006-10-13, 10:43 AM

Hello

Well i've searched around on all the threads and seems that other people have had the same problem but theres no been no fix?! So here goes, im a new install of SugarCRM (Open Source) Version 4.5.0d (Build 1168). Inbound emails work fine, outbound emails (replies to other emails or composing a new email they all work ok), all the smtp settings are correct (for admin and system), But for some reason, auto-replies on emails never get sent out. When i check my log for my mailserver it seems that sugarCRM isnt even trying to send the emails via smtp!?

Any ideas / fixes / work arounds i can do to get auto-replies working?

O/S: Windows 2003 Standard Edition
SugarCrm Version: 4.5.0d (Build 1168)
WebServer: IIS6
PHP Version: 5.1.6
SQL: MSSQL 2000 (with ROW_NUMBER patch)

Please help someone! I've uncommented the save code in /modules/InboundEmail/InboundEmail.php at line 551, so that the email gets saved it seems to get saved ok, just with the status of NULL. Is there a job that should be checking the email to be sent at certain times that i've missed or something? I've also turned on debuging and got no errors! Heres a snippet of where it should be sending an auto-reply:

10/13/06 10:45:01,557 [2892] DEBUG SugarCRM - Retrieve EmailTemplate : SELECT email_templates.* FROM email_templates WHERE email_templates.id = '8fdb2ddd-665e-c983-b04c-452f58506fbc'
10/13/06 10:45:01,557 [2892] DEBUG SugarCRM - Array
(
[0] => SELECT email_templates.* FROM email_templates WHERE email_templates.id = '8fdb2ddd-665e-c983-b04c-452f58506fbc'
[1] => 0
[2] => 1
[3] => 1
[4] => Retrieving record by id email_templates:8fdb2ddd-665e-c983-b04c-452f58506fbc found
)

10/13/06 10:45:01,558 [2892] DEBUG SugarCRM - Limit Query: SELECT TOP 1 email_templates.* FROM email_templates WHERE email_templates.id = '8fdb2ddd-665e-c983-b04c-452f58506fbc'
10/13/06 10:45:01,558 [2892] INFO SugarCRM - Query:SELECT TOP 1 email_templates.* FROM email_templates WHERE email_templates.id = '8fdb2ddd-665e-c983-b04c-452f58506fbc'
10/13/06 10:45:01,560 [2892] INFO SugarCRM - Query Execution Time:0.001288
10/13/06 10:45:01,563 [2892] DEBUG SugarCRM - get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE 1=1 AND is_group=0 ORDER BY user_name ASC
10/13/06 10:45:01,564 [2892] INFO SugarCRM - Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 AND is_group=0 ORDER BY user_name ASC
10/13/06 10:45:01,567 [2892] INFO SugarCRM - Query Execution Time:0.002642
10/13/06 10:45:01,568 [2892] DEBUG SugarCRM - saving and sending auto-reply email
10/13/06 10:45:01,569 [2892] DEBUG SugarCRM - -------------------------------> Email called save()
10/13/06 10:45:01,570 [2892] INFO SugarCRM - Insert: INSERT INTO emails (id,date_entered,date_modified,name,description_ht ml,from_addr,from_name,to_addrs,type,deleted ) VALUES ( '8af4f58c-a0e8-c10c-7425-452f605883f1','2006-10-13 09:45:01','2006-10-13 09:45:01','Thanks, we will get fixing straight away ...','Thanks for telling us about a bug! We will be sure to get it fixed it as quickly as possible!','bugs@webjam.com','Webjam','myemail@add ress.com ','out','0')
10/13/06 10:45:01,571 [2892] INFO SugarCRM - Save: INSERT INTO emails (id,date_entered,date_modified,name,description_ht ml,from_addr,from_name,to_addrs,type,deleted ) VALUES ( '8af4f58c-a0e8-c10c-7425-452f605883f1','2006-10-13 09:45:01','2006-10-13 09:45:01','Thanks, we will get fixing straight away ...','Thanks for telling us about a bug! We will be sure to get it fixed it as quickly as possible!','bugs@webjam.com','Webjam','myemail@add ress.com ','out','0')
10/13/06 10:45:01,571 [2892] INFO SugarCRM - Query:INSERT INTO emails (id,date_entered,date_modified,name,description_ht ml,from_addr,from_name,to_addrs,type,deleted ) VALUES ( '8af4f58c-a0e8-c10c-7425-452f605883f1','2006-10-13 09:45:01','2006-10-13 09:45:01','Thanks, we will get fixing straight away ...','Thanks for telling us about a bug! We will be sure to get it fixed it as quickly as possible!','bugs@webjam.com','Webjam','myemail@add ress.com ','out','0')
10/13/06 10:45:01,572 [2892] INFO SugarCRM - Query Execution Time:0.000681
10/13/06 10:45:01,576 [2892] DEBUG SugarCRM - Email sending ---------------------
10/13/06 10:45:01,586 [2892] DEBUG SugarCRM - --------------------- buh bye -- sent successful
10/13/06 10:45:01,587 [2892] INFO SugarCRM - Query:INSERT INTO inbound_email_autoreply (id, deleted, date_entered, date_modified, autoreplied_to) VALUES (
'8f3bf6d5-4316-ad83-1767-452f60ba03f1',
0,
'2006-10-13 09:45:01',
'2006-10-13 09:45:01',
'myemail@address.com ')
10/13/06 10:45:01,588 [2892] INFO SugarCRM - Query Execution Time:0.000616
10/13/06 10:45:01,589 [2892] DEBUG SugarCRM - ********************************* InboundEmail finished import of 1 email: Tewlkdf gmlk c
10/13/06 10:45:01,589 [2892] DEBUG SugarCRM - ***** On message [ 21 of 21 ] *****
10/13/06 10:45:01,592 [2892] DEBUG SugarCRM - In while loop of Inbound Emails

Hope someone can help me out, and get this fixed!

Thanks in advanced!