FusionCharts Forum / FusionCharts Free / FusionCharts Free and PHP / "No Data to Display" when run on website, but it works correctly against local DB / Latest PostsInstantForum.NET v4.1.4FusionCharts Forumhttp://www.fusioncharts.com/forum/support@fusioncharts.comMon, 08 Sep 2008 07:16:04 GMT20RE: "No Data to Display" when run on website, but it works correctly against local DBhttp://www.fusioncharts.com/forum/Topic6049-43-1.aspxOkay. It was me. I was actually calling a different database connection file. The name differed by one letter. </P><P>Note to self: CHECK that what you think is happening, is ACTUALLY what is happening.:) </P><P>Thanks, Sudipto. If you hadn't asked me to check the output for the dataURL I would have kept going in circles. Sorry to have wasted your time</P><P>LizFri, 02 May 2008 10:23:28 GMTqzgbd9RE: "No Data to Display" when run on website, but it works correctly against local DBhttp://www.fusioncharts.com/forum/Topic6049-43-1.aspxWish I'd thought of that, Sudipto! </P><P>When I try to run the data.php file that's on my web server using a browser I get </P><P>"Could not connect: Access denied for user 'root'@'localhost' (using password: NO)" </P><P>This is a bit confusing, because my DBConn.php file contains the correct information for connecting to this database and the correct path to the file is in the includes statement.Fri, 02 May 2008 09:37:58 GMTqzgbd9RE: "No Data to Display" when run on website, but it works correctly against local DBhttp://www.fusioncharts.com/forum/Topic6049-43-1.aspxhi,</P><P>Could you please check the DataURL once whether it it producing the proper XML?Fri, 02 May 2008 01:13:10 GMTSudipto Choudhury"No Data to Display" when run on website, but it works correctly against local DBhttp://www.fusioncharts.com/forum/Topic6049-43-1.aspxCan anyone help with this? <P>I have a MySQL databse on my PC that is an exact replica of the one on my web hosting server. Before uploading the files I tested everything against the local database and the charts display correctly. When I move the files to the web server and run the application, the charts don't display. I get "No Data to Display". </P><P>I'm using the dataURL method with PHP Class.</P><P>I've set the permissions on the files to 755 (owner can read, write and execute,the world can read and execute). The files all exist in the correct paths.</P><P>I've checked that DBConn.php has the correct information for host, user, password and database.</P><P>I've tried running the sql against the remote database and it produces the data I'm expecting. </P><P>What am I doing wrong?Thu, 01 May 2008 11:24:06 GMTqzgbd9