Campaign email not sent

[skindlen]

Hi,

Have went through the instructions on creating a camapaign email and nothing seesm to work.

The emails are not sent out, either by Send Test of Send Emails.

Scheduler is working and is running.

There seems to be no reason for the emails not be sent.

They are stuck in the queue , and go no further.

Turned on debug for log, there is only this erroe is reported:

Tue Jun 8 14:25:01 2010 [15284][1][INFO] Query Execution Time:0.000345945358276
Tue Jun 8 14:25:01 2010 [15284][1][INFO] QueryELETE FROM schedulers_times WHERE date_entered < DATE_FORMAT('2010-06-07 13:25:01', '%Y-%m-%d %H:%i:%s')
Tue Jun 8 14:25:01 2010 [15284][1][INFO] Query Execution Time:0.0163559913635
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] get_full_list: order_by = '' and where = 'schedulers.status='Active''
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] SugarBean.load_relationships, Loading relationship (created_by_link).
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] Link Constructor, relationship name: schedulers_created_by_rel
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] Link Constructor, Table name:
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] Link Constructor, Key name:
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] Link Constructor, _bean_table_name: schedulers
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] Link Constructor, _bean_key_name: created_by
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] Link Constructor, relationship record found.
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] SugarBean.load_relationships, Loading relationship (modified_user_link).
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (modified_user_link).
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] SugarBean.load_relationships, Loading relationship (modified_user_link).
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (modified_user_link).
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] process_full_list_query: query is SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod FROM schedulers LEFT JOIN users jt0 ON
jt0.id= schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 where (schedulers.status='Active') AND schedulers.deleted=0
Tue Jun 8 14:25:01 2010 [15284][1][INFO] Query: SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod FROM schedulers LEFT JOIN users jt0 ON
jt0.id= schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 where (schedulers.status='Active') AND schedulers.deleted=0
Tue Jun 8 14:25:01 2010 [15284][1][INFO] Query Execution Time:0.00054407119751
Tue Jun 8 14:25:01 2010 [15284][1][DEBUG] process_full_list_query: result is mysqli_result Object
(
)

System is:
Version of SugarCrm Community is Version 5.5.1 (Build 1202)
PHP: 5.2.13

Can someone help me out Here, please?

Regards,

Simon
MySQL: 5.0.90-community-log

[salesagility]

Do you have any custom modules?

Have you made any modifications ... new code etc?

[skindlen]

Hi,

No custom modules, no code modified.

Script was installed by automated script, softaculous, provided by web site hosting company.

Regards,

Simon

[salesagility]

And ... can you send emails from sugar from other user accounts?

[skindlen]

Email was set up in admin for out going. Tested from admin. On testing from the Collaboration Module, composing the email error was given that there was no outgoing set up for system. Edited the details in the setting for out going. Why does collaboration not pick up on the system settings for outgoing account? Is this a known bug?

Sent email okay from Collaboration, email received. Went queued emails, and the queue is now cleared. No email received though from the campaign though, no longer queued so I assume the email has gone out. Where can I check to make sure the email has been sent?

[chrislynch8]

Have you configure a Monitored Inbound Email Account with Bounce Handling for Campaigns?

Rgds
Chris

[skindlen]

Chris,

I have inbound Bounce Handling, using the same email address for sending email. Do not want to have millions of email addresses.
I so no setting for monitoring accounts.


I want to monitor emails being sent.

Looking at the status of a campaign shows that emails being sent to the same domain as the sending account are being suppressed. Sending email to another domain does not show up in the supressed list but they are not showing up in the attempted or sent list.

How do I know that the test email has been sent? If it is not listed does this mean that it has not been sent? If it has not been sent, what are the possible reasons for failure?

Regards,

Simon

[salesagility]

How do I know that the test email has been sent? If it is not listed does this mean that it has not been sent? If it has not been sent, what are the possible reasons for failure?

Set yourself up on as a Contact on the test list ... send the test ... do you get an email?

Also check the status of the Campaign after you send the test ... it records all sends and send attempts ... even for tests

[skindlen]

Chris,

Reset email addresses and passwords, and this time it worked.

Email in sent list and viewed status is given.

Used email addresses outside the doamin.

Why does Sugar CRM suppress email7s sent to the sending domain?

Why does Sugar CRm not give error messages in the log when sending fails.

Will use your tip on the contact.

Find it confusing all these different lists and targets, specially when starting out.

Thank you for your help, the both of you.

Regards,

Simon

[chrislynch8]

Hi,

I must not be understanding something correctly. In my setup here I have two Email addresses configured
1: Is the main crm@mydomail.ie that sent emails to users, etc.. This is configured in Email Settings->Email Notifcation Settings.
2: Is setup in the Monitor Inbound Emails - in here I have another address newsletters@mydmain.ie. In the options I choose bouce handling as a possible Action.

Then when I create my Email Marketing message I choose the second Email Address in the Use Mailbox dropdown (it will be the only one available).

Are you getting an Address to use in this part?

Rgds
Chris


Forgot to submit this post earlier - so take no notice as I see you have it working