Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page:
  • 1

TOPIC: DataTables warning

DataTables warning 1 week 6 days ago #1

  • spark43
  • spark43's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 19
When I click on User Administration in control panel I get the following error message:

DataTables warning: table id=DataTables_Table_0 - Invalid JSON response.

Using Firefox network debugger the response is:

The requested URL was rejected. If you think this is an error, please contact the webmaster.

The URL is very long but begins with:

Request URL:http://ccgi.username.plus.com/webtrees/index.php?route=%2Fwebtrees%2Fadmin%2Fadmin-users-data&draw=2&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata...etc.

The rest of Webtrees is working normally.

David
Webtrees 2.0.3
MySQL-Version: 5.5.38-log
PHP-Version: 7.1.33
Win 10

Please Log in or Create an account to join the conversation.

DataTables warning 1 week 5 days ago #2

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 12929
If your server uses Microsoft IIS, see webtrees.net/install/iis/

Otherwise, see webtrees.net/faq/xhr/
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

DataTables warning 1 week 5 days ago #3

  • spark43
  • spark43's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 19
> If your server uses Microsoft IIS
I don't know. Is there a test or query I can run to find out?
My server has disabled php.ini for scurity reasons.

>Otherwise, see webtrees.net/faq/xhr/
I used this link to provide the info in my original post.
Webtrees 2.0.3
MySQL-Version: 5.5.38-log
PHP-Version: 7.1.33
Win 10
Attachments:

Please Log in or Create an account to join the conversation.

DataTables warning 1 week 5 days ago #4

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 12929
> I used this link to provide the info in my original post.

Apologies. I try to make sure every post gets answered - but I don't always have time to read them fully....

> The rest of Webtrees is working normally.

Does this include the other tables that load data dynamically. e.g. website logs or tree-changes logs?

>> If your server uses Microsoft IIS
> I don't know. Is there a test or query I can run to find out?

The HTTP headers may tell you.
The "Server information" section of the control panel may tell you.
But if this is not your server, then you won't be able to change the config, so knowing this won't really help...

Your server is blocking the URL.

It could be the length. It could security software on the server. The only way to find out might be to ask your web host.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

DataTables warning 1 week 5 days ago #5

  • spark43
  • spark43's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 19
> Does this include the other tables that load data dynamically. e.g. website logs or tree-changes logs?

I could only find three items in the control panel that use long urls:
Manage Media 12 lines of text.
Website logs 22 lines of text.
User Management 34 lines of text.
I don't have a tree-changes log.
User Management is the only one that fails.

I know you are a busy man and doing a great job but could you explain why User Management url is so long.
If its related to number of users I could try deleting some inactive users using phpadmin?
Webtrees 2.0.3
MySQL-Version: 5.5.38-log
PHP-Version: 7.1.33
Win 10

Please Log in or Create an account to join the conversation.

DataTables warning 1 week 5 days ago #6

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 12929
> but could you explain why User Management url is so long

The table is populated dynamically. Each time you change the page length, scroll to a new page, search, etc, a new request is sent to the server. There are a lot of options to send. Which columns to sort by, which columns to filter by, etc.

The request URLs aren't excessively long by any standard. A couple of thousand characters.

> Website logs 22 lines of text.

website logs and user list both use the same dynamic tables, and both have equally long URLs.

If you were hitting the IIS default limit, then both would fail.

So this suggests URL length is not the issue.

What we are left with is a server firewall-type message that has blocked a specific HTTP post request that contain the keyword "user".

It is happening before the request even gets to webtrees.

My guess is some sort of security software on your server is blocking these.

I think the only solution is a support ticket with your host.
They give you an ID number in the error message. They can presumably use this to tell you why the request was blocked.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

DataTables warning 1 week 4 days ago #7

  • spark43
  • spark43's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 19
Thanks Greg, I'll see what they have to say about it.
Webtrees 2.0.3
MySQL-Version: 5.5.38-log
PHP-Version: 7.1.33
Win 10

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum