Campaign Status gone after upgrade to 5.1

[matthewboh]

I just upgraded from 5.0g to 5.1 using the upgrade wizard, but now the Campaign Response by Activity Chart is no longer showing. I have been able to go back to my 5.0g instance and it's there, but not on the 5.1

Any ideas? I'm afraid that over the year, the email campaign I've been running has been messed up and am thinking about trying to start clean by clearing out the tables.

Thanks

[muhammadfr]

I am having the same problem. Did you find an answer?

[matthewboh]

No - and it's apparently not sending out any campaign emails. The last version where I upgraded the cron job for emails didn't work, so I was hoping that the upgrade would fix it - but at least I could run the emails manually.

I'm going to try and figure out what's going on, but the code is pretty complicated. I'll post what I find.

[matthewboh]

Okay - figured out part of the problem. One was my fault.

Anyway, I had a bad date in the send date - once I fixed that, my email campaign is getting sent out. Seems to have fixed the issues that I had last month as well.

However, the chart seems to be another problem. I still have Version 5.0g up and running in another folder / database and it happily creates the chart. Version 5.1 does not work.

I have checked the HTML that is generated - one small difference is that the XML file names are different - but the contents of the XML look alike.

I was able to take the page source for both versions, copy it to my hard drive, change the relative URL's to my copy of 5.0g and get the chart to show up. However, if I changed ONLY the source of the XML files - the chart doesn't work anymore pointing to a problem with the XML files. I'll try and figure out some more...

OK - I'm out of ideas Even if I copy the files that work from my 5.0g over to the cache in my 5.1 - the chart doesn't work. However, if I point the files back to the original files in the original directory, it works. Got me what's wrong....

This works

<tr>
	<td width="10%" >&nbsp;</td>
		<td><p align=center><OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"  codebase="https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"  WIDTH="800" HEIGHT="400" id="hBarF" ALIGN="">
		<PARAM NAME=movie VALUE="http://www.imparisystems.com/SugarCRM5g/include/charts/hBarF.swf?filename=http://www.imparisystems.com/SugarCRM5g/cache/xml/837ee6f1-2fea-e4fb-8f9e-48c6a2bd0d80_campaign_response_by_activity_type_2008_09_09_2008_09_09.xml">
		<PARAM NAME=bgcolor VALUE=#FFFFFF><PARAM NAME=wmode VALUE=transparent>
		<PARAM NAME=quality VALUE=high><EMBED src="http://www.imparisystems.com/SugarCRM5g/include/charts/hBarF.swf?filename=http://www.imparisystems.com/SugarCRM5g/cache/xml/837ee6f1-2fea-e4fb-8f9e-48c6a2bd0d80_campaign_response_by_activity_type_2008_09_09_2008_09_09.xml" wmode="transparent" quality=high bgcolor=#FFFFFF  WIDTH="800" HEIGHT="400" NAME="hBarF" ALIGN=""  TYPE="application/x-shockwave-flash" PLUGINSPAGE="https://www.macromedia.com/go/getflashplayer"></EMBED></OBJECT>
</p>
</td>
<td width="20%">&nbsp;</td>						 		
</tr>

This does NOT work - and I copied the above file that does work to the directory structure for 5.1

<tr>
	<td width="10%" >&nbsp;</td>
		<td><p align=center><OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"  codebase="https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"  WIDTH="800" HEIGHT="400" id="hBarF" ALIGN="">
		<PARAM NAME=movie VALUE="http://www.imparisystems.com/SugarCRM5g/include/charts/hBarF.swf?filename=http://www.imparisystems.com/SugarCRM/cache/xml/837ee6f1-2fea-e4fb-8f9e-48c6a2bd0d80_campaign_response_by_activity_type_2008_09_09_Y_m_d.xml">
		<PARAM NAME=bgcolor VALUE=#FFFFFF><PARAM NAME=wmode VALUE=transparent>
		<PARAM NAME=quality VALUE=high><EMBED src="http://www.imparisystems.com/SugarCRM5g/include/charts/hBarF.swf?filename=http://www.imparisystems.com/SugarCRM/cache/xml/837ee6f1-2fea-e4fb-8f9e-48c6a2bd0d80_campaign_response_by_activity_type_2008_09_09_Y_m_d.xml" wmode="transparent" quality=high bgcolor=#FFFFFF  WIDTH="800" HEIGHT="400" NAME="hBarF" ALIGN=""  TYPE="application/x-shockwave-flash" PLUGINSPAGE="https://www.macromedia.com/go/getflashplayer"></EMBED></OBJECT>
</p>
</td>
<td width="20%">&nbsp;</td>						 		
</tr>

BUT if I change the name to follow the old style without the Y_m_d - it works! Now I have to find where it creates the file for this!

[shareaholic]

any updates? have you come up with a workaround? I'd really appreciate your help with this issue

[shareaholic]

I have figured out that this problem is probably the direct result of re-factored tracking functionality. The issue has already been raised here: http://www.sugarcrm.com/forums/showthread.php?p=135561

[Mekanek]

I managed to get my missing status chart problem solved. For me it was and still is a file permission problem. Status info or at least part of it is written on a daily basis to /cache/xml -folder to those xml files with long names.

This is probably server related also, but in my case this daily update file is also set with permission 660 when it is made after midnight. SugarCRM, however, requires 664 to be able to display it in my case (and with my server ?).

I still could use info on how to make the system set correct file permissions when writing, was it either SugarCRM or server related....