DataTables warning: table id=DataList - Ajax error

k-george

Hi,

      I am stuck with an error as ''DataTables warning: table id=DataList - Ajax error. For more information about this error, please see http://datatables.net/tn/7''

Also not good in datatables serverside processing implementation and error corrections as a beginner.

The three basic files are attached herewith

fetchDataSongs.php

ssp.class.php

index-table-songs.html

Looking for a proper solution from you all who able to do so.

george.

allan

What is the response from the server to the Ajax request? Follow the instructions in the error message's link if you aren't sure how to get that.

Allan

k-george

I am not good in understanding errors from console.

Also removed the 0 before the closing tag of </script> at index-table-songs.html

The following are the errors shown now

Failed to load resource: the server responded with a status of 500 () fetchDataSongs.php?draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=0&order%5B0%5D%5Bdir%5D=asc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1742226822263:1

No idea that ''What needs to do with the above error '?

Can you help us ?

allan

A 500 error is a server error. It could be something as simple as an incorrect MySQL password in the script, or a file permission error, a syntax error or anything else. It is a very generic error.

You need to check your server's error logs (the PHP error log would be the place to start) to see what it says.

Allan

k-george

Finally find the error and that was an extra exclamation mark in the ''fetchDataSongs.php''

But now the problem is only the first two audio files only loading and the rest are not loading.

find it in the image attached herewith.

any solution to correct it ?

k-george

Also when i changed the 3rd and 4th row file name to 1st and 2nd file names respectively then it loads and working.

But when i changed the first row file to another name it doesn't load.

Any solution ?

kthorngren

I would start by looking at the browser's network inspector tool to see the JSON response. Does it look correct?

Can you post the response here so we can take a look?

Kevin

k-george

''I would start by looking at the browser's network inspector tool to see the JSON response. Does it look correct?''

I don't know how to do and get it exactly.

Anyhow i clicked on the network and take three different screenshots by scrolling and is attached herewith.

Is this what you are looking for ?

allan

But now the problem is only the first two audio files only loading and the rest are not loading.

Your network information shows that they are 404 not found.

Why that would be, I don't know. Perhaps the files aren't on the server? Perhaps they have permission restrictions? The server's httpd log would be the first place to look for more information.

Allan

k-george

Don't know why it shown so.

All audio files are visibly available in the server.

All the permission check boxes are checked associated with the database.

allan

Without access to the page and the server, all I can go on is what the information you are showing me is saying, which is that the files are 404 not found.

Allan

k-george

Did you talk about these permissions and is attached herewith ?

kthorngren

As Allan said:

The server's httpd log would be the first place to look for more information.

Have you looked at this log?

Let us know what you find.

Kevin

allan

No - those are SQL permissions. I'm talking about file permissions. And even then, I'm only guessing. As indicated, the server's logs would be the place to look.