Can't load data with server-side processing

art

I'm having problems to load the data from the mysql database.

First of all I'm on localhost and I want to load data by server-side processing. I'm using server_side.html and server_processing.php. In the latter I have configured my database settings.

I got a json error so I added fnServerParams/Data in the server_side.html and the error disappeared, however it still doesn't load the data.

Is there a point which I might have skipped?

allan

What was the JSON error? If you look at the return in Firebug, you'll see the exact return from the server - if you could post that here, that would be helpful. It will presumably have an error code in it.

Allan

art

I do have Firebug with Page Speed addon, but could you tell me where exactly to look for the return?

allan

On the console tab you'll see the XHR there. Click the little plus icon to expand it.

As an alternative I've recently been working on a bit of software to help with exactly this sort of thing - could you try using the DataTables debugger on your page please: http://debug.datatables.net and let me know what the debug code is. That way I'll be able to see the JSON return from the server.

Allan

art

Couldn't find the XHR tab on the console tab even if I'm using the latest Firebug.

But the DataTables debugger works great and the link is this one: debug.datatables.net/odozor

allan

Cool - good to here that the debugger is working well for you :-)

It shows the the return from the server is:

[code]
Could not select database testdb4
[/code]

so that would be the issue :-)

Allan

art

Solved. Thanks Allan!

allan

Good stuff. First success story (hopefully of many) of the new debugger :-).

Allan