Table doesn't work properly after move to hosting
Table doesn't work properly after move to hosting
dadko123456789
Posts: 8Questions: 1Answers: 0
Hello,
I have a problem with datatables, I'm getting this error after I moved mi website from the vps server to the shared hosting.
When I have for example 10 pages and then I try to go to the last page, I get this:
DataTables warning: table id=list_table - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
Also when I have some larger table with more entries.
Can you help me? I already extended every PHP parameter, like memory_limit, max_execution_time, post_max_size, etc.
Thanks!
David
This discussion has been closed.
Replies
Did you follow the steps in the link provided in the error?
http://datatables.net/tn/1
What is the JSON response?
Likely you will need to look at the server error logs to find the problem.
Kevin
Yes, I followed these steps, but I got nothing in the response in console.
I tried to look into server logs but there wasn't any error.
It seems like it cannot handle larger tables.
Hi @dadko123456789 ,
There's no limit on large tables. Can you link to your page so we can take a look?
Cheers,
Colin
Hello colin,
thank you for your answer.
Here is the link to the page: https://dadko.xyz/banned.php
The
banned_list.phpfile is returned zero data. That is invalid JSON hence the error.Try adding:
at the top of your banned_list.php file (inside the
<?php) to force PHP to show errors.Allan
I added it, even changed PHP settings in control panel of my hosting, but I got no errors, dunno where the problem can be, sometimes it works, sometimes not
The most likely thing to my mind is a utf8 encoding issue. What character set is your dB in? Is that different from your device dB where it does work?
Allan
Thanks so much allan!
It was the problem with utf8 encoding, I fixed it and everything works now