Dashboard Not Displaying Data

[mystirious]

Hi all last month I installed SugarCRM version 5.2.0j and its working fine the only problem I am facing is that when I click on Dashboard tab it show for few seconds "Loading" and after few seconds show no displaying data even though I have more than 40 account and contact , opportunity data filled in my sugar crm. please reply I want to see it in a graph mode.

[salesagility]

what version of sugar, db, php, webserver etc?

have you made any changes?

have you looked at the dashlet parameters ... click the dashlet pencil

[mystirious]

I am using Sugar on my web hosting server here are the details

Sugar version 5.2.0k
Database version MySQL version 5.0.81-community
PHP version 5.2.9
webserver Apache version 2.2.13 (Unix)
Operating System Linux

I have not made any changes

I looked at the dashlet parameters and clicked on dashlet pencil and selected some fields but still showing "No Displayable Data"

[salesagility]

Are none of the dashlets displaying any data?

Are you logged in as Admin with the "Only my data" checked in each dashlet?

[mystirious]

Yes, I am logged in with Admin but I tried by cheking only my user data and with checking other users but still first show loading and then showing No Displayable data.

[crossen]

This issue is also happening to me. I installed 5.2.0k from the sugarcrm website on a linux hosted server. Everything works except the graphs and other reporting data dashlet areas. "no displayable data".

There were no errors on install.

It must be a permissions or install issue.

Please let us know on this because I can't pitch this to my client without it.

Thanks,
Chris

[akkimca]

Hi,
u need to debug the code...

just find this file modules/charts/PredefinedChart.php.
in this file, check which chart is calling like this,

 function predefinedChartQuery($chart, $params=array()){
    print_r($chart);
        ............. 
  

after that, just debug the code and find out the query of calling chart and test it in ur mysql.
if it is giving u a result dn query is ok or not ?

all the best