Add Dashlets - Basic Charts *Fail message

[tancott]

Hi,

Please could you help me to fix this issue, I have installed version 6.2.0 of sugar, and have set the permissions correctly according to what they are required to be but this issue keeps cropping up and Im not sure where to find the fix for it.

When on the dashboard > Click "Add Dashlet" then select "Charts" when I try to add a new Basic Chart a prompt appears saying Fail - When I proceed to click "OK" another prompt box appears saying "Failed - Prevent this dialogue from creating additional pages".

Although the chart does add to the dashboard it appears empty, although there is data.

Please see the screen-shots attached.

I am rather desperate to find a solution for this as I don't want to go back to an earlier version,

Any help is greatly appreciated.

[houlejo]

Did you found any answers ?

[houlejo]

Ok found it.

Clear the cache folder.
Add the dashlet.
Set cache folder and subfolder to chmod 775
Set cache files to chmod 664
Refresh

[houlejo]

Ok that's bad, I had to do it each time I add a dashlet.

I had to do modification to the code to make it work because the cache file created when adding the dashlet is always chmod 660.

You can 2 things :
Modifications to /include/SugarCharts
Files : SugarChart.php, JsChart.php

Sugarchart.php
********************
//MOD CHMOD 664 HOULEJO
chmod($xmlFilename,0664);
//MOD CHMOD 664 HOULEJO
$GLOBALS['log']->debug("Success, wrote ($xmlContents) to file ($xmlFilename)");
*********************

JSChart.php
*********************
//MOD CHMOD 664 HOULEJO
chmod($this->jsonFilename,0664);
//MOD CHMOD 664 HOULEJO
$GLOBALS['log']->debug("Success, wrote ($jsonContents) to file ($this->jsonFilename)");
******************************

Or modify the config.php file to give the correct file permissions (755 and 664)
'default_permissions' =>
array (
'dir_mode' => 1517, //Was 1528 by default
'file_mode' => 436, //Was 432 by default
'user' => '',
'group' => '',

The second one (config.php) worked better. But I don't know the risks of giving different permissions to all the system.

good luck!

[mathias.de]

Hi,
i'm installed sugar 6.2.4
I have the Exact same problem but your solutions aren't working for me...

What can i do to get charts?

any idea?

Thanks
Mat

[houlejo]

Hi, For me it was a permission thing. Look at the permissions by default.

[mathias.de]

ok the problem is a permission one.

see the below:

First you need to log onto your server and go to the folder where you have your crm files located.

Here are the steps:

1. Click on the file cache.

2. Click on the file XML.

3. You will now see a lot files and highlight all of them except chart_strings and index.html.

4. Right click and select properties set permissions to 666.

Go back to your dashboard and refresh all the charts should be coming up for you now.

And you need to do that each time you want to had a new charts! i don't know how to generate permanently permission on 666 when added new charts... any idea?

[houlejo]

For permanent permission, see my post in this thread :

Or modify the config.php file to give the correct file permissions (755 and 664)
'default_permissions' =>
array (
'dir_mode' => 1517, //Was 1528 by default
'file_mode' => 436, //Was 432 by default
'user' => '',
'group' => '',

[tshepoth]

Thanks Houlejo, changing permisions in config.php file worked for me as well

[tshepoth]

I learned the harder way... the danger is that config file gets corrupt and the sugar instance does not open anymore!