Campagn Status Screen - Subpanels Not Showing Data

[Moher]

Hi all - I've got a CE install that I recently upgraded 5.2 > 5.5.1 > 5.5.2 ...

My problem is with the Campaign status screen. In 5.2, the subpanels used to show data. viewed message, click through link, etc. All worked perfectly.

After upgrading to 5.5.2, the subpanels show the count (number of records, ie. 1-10 of 891) in the right top corner of the subpanel. However, the subpanels are not listing the actual records as they did previously.

I checked sugarcrm.log, and it shows an error message:

05/18/10 13:09:07 [6196][87d776bd-6c14-68f3-d541-49dd14742786][FATAL] SQL Server error: Column 'campaign_log.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

I'm not sure how to go about troubleshooting or fixing this. Any ideas would be appreciated!!

Program is running on a Windows 2003 server.

Database is MS SQL Server 2005

Thanks!

[salesagility]

I suspect it's one for sugar ... you should report a bug

[Moher]

Reported here

[Moher]

If anyone has any insight as to what is causing this and how I might try to fix it, it would be very much appreciated.

Thanks!

[Moher]

OK I think I found the fix....

in \modules\campaigns\campaign.php, there seems to be some stray bad code that is causing the problem...

simply commenting out lines 276, 277 and 278 so it appears as:

// if(isset($arg['group_by'])) {
// $query_array['group_by'] = $arg['group_by'];
// }

seems to have fixed the problem.

It does not appear that this code in this position was in previous versions of campaign.php, so I'm not sure of the purpose of it being inserted here for 5.5.2. But after commenting out those lines, all subpanel data now appears on the campaign detail screen as it should.

[skwong2000]

I have faced the same problem in Version 6.0.0RC1 (Build 3812).

Will SugarCRM team fix this problem in coming 6.0 release?
As our software depends on the marketing campaign, I really hope that the campaign module can be tested more completely.

[salesagility]

I have faced the same problem in Version 6.0.0RC1 (Build 3812).

Will SugarCRM team fix this problem in coming 6.0 release?
As our software depends on the marketing campaign, I really hope that the campaign module can be tested more completely.

If you are betting your business on sugarcrm you should NOT be using a release candidate ... it is not production ready ... rather, you should deprecate to a production version such as 5.5.x and wait until 6.0 has a few bug fix releases before using for production.

Sugar is no different than many software products ... new releases are more prone to error and using them can be very trying!!

[bwang]

It seems not working in Sugar6.0.0GA.

Only the first page of a subpanel can display records, but the other pages won't be able to list any data except the counts.
In my case, it won't be an issue to view the details in the subpanels under Campaign Status, I know they are there, just not showing up.
But I do have more than 10 target lists and email marketings for each campaign, so I have to increase the "Subpanel items per page" from 10 to 50 to see all of them.

Please see attached.