"No Data to Display" when run on website, but it works correctly against local DB
FusionCharts Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



"No Data to Display" when run on website, but... Expand / Collapse
Author
Message
Posted 5/1/2008 11:24:06 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 6/22/2008 7:28:15 AM
Posts: 15, Visits: 29
Can anyone help with this?

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".

I'm using the dataURL method with PHP Class.

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.

I've checked that DBConn.php has the correct information for host, user, password and database.

I've tried running the sql against the remote database and it produces the data I'm expecting.

What am I doing wrong?

--Liz

Post #6049
Posted 5/2/2008 1:13:10 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Moderators
Last Login: 2 days ago @ 4:56:35 AM
Posts: 706, Visits: 1,143
hi,

Could you please check the DataURL once whether it it producing the proper XML?

Regards,

Sudipto Choudhury
FusionCharts Team

Post #6057
Posted 5/2/2008 9:37:58 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 6/22/2008 7:28:15 AM
Posts: 15, Visits: 29
Wish I'd thought of that, Sudipto!

When I try to run the data.php file that's on my web server using a browser I get

"Could not connect: Access denied for user 'root'@'localhost' (using password: NO)"

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.

--Liz

Post #6066
Posted 5/2/2008 10:23:28 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 6/22/2008 7:28:15 AM
Posts: 15, Visits: 29
Okay. It was me. I was actually calling a different database connection file. The name differed by one letter.

Note to self: CHECK that what you think is happening, is ACTUALLY what is happening.

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

Liz

--Liz

Post #6067
« Prev Topic | Next Topic »


Permissions Expand / Collapse

All times are GMT -7:00, Time now is 5:42am


Execution: 0.078.