MySQL error 1054: Unknown column 'name' in 'where clause'

[lmirguet]

Hello,

I'm trying to launch my first email campaign with SugarCRM (version 5.5.4). And apparently the scheduler runMassEmailCampaign never completes (it stays always in status "In Progress").

In the logs I can find only one line which seems to correspond to the scheduler issue:
MySQL error 1054: Unknown column 'name' in 'where clause'

Can you please me debugging this problem?

Thanks a lot
Laurent

[andopes]

Go to Admin -> System Settings.
Update log level to debug.
Try again.
Track the sugarcrm.log and figure out if the steps it is following regarding the Mass Email Campaigns.
Attach into your next post the piece of sugarcrm.log regarding the Campaigns.

Cheers

[lmirguet]

Hello Sugar Hero,

Thanks a lot for your help.

Here is the complete log of my problem:

Wed Feb 2 15:56:02 2011 [31265][1][DEBUG] -------------------------------> Email called save()
Wed Feb 2 15:56:02 2011 [31265][1][DEBUG] Including module specific hook file for Emails
Wed Feb 2 15:56:02 2011 [31265][1][DEBUG] Creating new instance of hook class EmailsHooks without parameters
Wed Feb 2 15:56:02 2011 [31265][1][DEBUG] Retrieve Contact: SELECT contacts.*,contacts_cstm.* FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE name = 'contact@microworld.org' AND deleted=0
Wed Feb 2 15:56:02 2011 [31265][1][DEBUG] Limit Query:SELECT contacts.*,contacts_cstm.* FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE name = 'contact@microworld.org' AND deleted=0 Start: 0 count: 1
Wed Feb 2 15:56:02 2011 [31265][1][INFO] Query:SELECT contacts.*,contacts_cstm.* FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE name = 'contact@microworld.org' AND deleted=0 LIMIT 0,1
Wed Feb 2 15:56:02 2011 [31265][1][INFO] Query Execution Time:0.000227928161621
Wed Feb 2 15:56:02 2011 [31265][1][FATAL] MySQL error 1054: Unknown column 'name' in 'where clause'
Wed Feb 2 15:56:02 2011 [31265][1][DEBUG] Calling DBManager::disconnect()

I am in the process of sending a mail campaign. The From: field of the mail campaign is "contact@microworld.org" so I am quite surprised by this request:
SELECT contacts.*,contacts_cstm.* FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE name = 'contact@microworld.org' AND deleted=0

Why would Sugar look for the contacts whose names are 'contact@microworld.org'?

Please could you give me a hint?
Best regards,
Laurent

[andopes]

Hi Laurent

Definitely it is so weird.
Do you know if someone had installed any additional package or customize files by hand?
This is not the default behavior at all.
It would be necessary to debug all related scripts in order to identify the buggy stuff.

Best regards

[lmirguet]

Hello Sugar Hero,

Thanks a lot for your help and advices !
Indeed I have found the culprit in a custom module that I did not know - and which was creating some troubles in my instance of SugarCrm when it was sending emails.

Your advices helped me a lot!

Thanks
Laurent