BUG: Can't serach contacts through campaigns

[lateefkhan]

I want to search contacts though campaign name, but it show me nothing. When i checked the logs i found out the error:

ERROR SugarCRM - MySQL error 1054: Unknown column 'contacts.campaign_name' in 'where clause'

I am using SugarCRM 5.0g.

I have checked the contacts table and there is no field like 'campaign_name' instead there is a field 'campaign_id'

Anybody have any clue.
thank you.
Reply With Quote

[jerrymt]

I'm either trying the same thing or something similar, with no luck.

In Sugar 5.1.0b, I used the Studio to add "Campaign [campaign_name]" to the Basic and Advanced Search forms for Contacts. I then enter the name of a Campaign that I know contains contacts in its target list. However, the search result set is completely empty.

I was hoping to use this as a workaround for the fact that you can't directly export target lists for offline mail merge. Unfortunately, it doesn't seem to work.

Edit: I do not see any errors in my logs when I try to search. So maybe I'm having a different problem than the original poster.

[roblaus]

Seems as if an old bug is back: http://www.sugarcrm.com/crm/?option=...6-48160259860b

Or at least closely related.

BTW: works in my case (5.1b)