1

Civicrm 4.7.1 Joomla 3.4.8

I'm unable to view data in the relationships tab. I get the following errors:

"DataTables warning: table id=DataTables_Table_0 - Ajax error."

And

"DataTables warning: table id=DataTables_Table_1 - Ajax error."

This issue has been ongoing since updating to 4.7.0

Any help would be appreciated. Please let me know if you need additional information.

Thanks.

  • Here is the error that appears in the browser console: GET domainname.com/?option=com_civicrm&task…art=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1455045491224 404 (Not Found) jquery.js:9664. – trvrtwr Feb 9 '16 at 19:19
  • I am also seeing this under 4.7.10 using Joomla under IIS - it is a 404 error. The setup is just a local development system. I don't have Modsec installed. The organisation I work for has installations under Apache/Linux, where we don't see the error. I have tried in vain to discover where in the code the error occurs in order to debug it. I even tried a clean Joomla/CiviCRM installation and saw the same problem. The console has: HTTP404: NOT FOUND - The server has not found anything matching the requested URI (Uniform Resource Identifier). (XHR)GET - jupiter/joomla/administrator/?opti – Stephen Palmstrom Aug 16 '16 at 14:41
2

I am seeing this on 4.6.14 . This is due to modsec thinking it is a SQL attack. I saw a popup indicating datatables saw an error and to look here:https://datatables.net/manual/tech-notes/7

Console showed these errors:

Failed to load resource: the server responded with a status of 403 (Forbidden) https://www.xxxxxx.com/civicrm/ajax/contactrelationships?context=past&cid=10…_9=false&mDataProp_10=10&bSortable_10=false&iSortingCols=0&_=1462288897639 Failed to load resource: the server responded with a status of 403 (Forbidden)

When I disabled the modsec rule it worked without error. here is the rule: SecRule ARGS|ARGS_NAMES|REQUEST_COOKIES|REQUEST_COOKIES_NAMES|XML:/|!ARGS:/body/|!ARGS:/content/|!ARGS:/description/|!ARGS:/message/|!ARGS:Post|!ARGS:desc|!ARGS:text|!ARGS:text_message|!REQUEST_COOKIES:/__utm/|!REQUEST_COOKIES:/_pk_ref/|!ARGS:sql_query "@rx [[]\"',().]{10}$|(?:union\s+all\s+select\s+(?:(?:null|\d+),?)+|order\s+by\s+\d{1,4}|(?:and|or)\s+\d{4}=\d{4}|waitfor\s+delay\s+'\d+:\d+:\d+'|(?:select|and|or)\s+(?:(?:pg_)?sleep(\d+)|\d+\s=\s*(?:dbms_pipe.receive_message((?:chr(\d+)(?:\s*\|\|\s*)?),\d+)|(select\s+\d+\s+from\s+pg_sleep(\d+)))))(?:\s(?:and|or)\s+(?(?:(\d{4})=\1|'(\w{4})'='\2|'%'=')|--\s*\w*|#)$|(select\s*(case\s+when\s*(\d+\s*=\s*\d+)\s+then\s+\d+\s+else\s+(?:0x[\0-9a-h]+|\d+)\s+end))|(?:(?:and|or)\s+(?'?(?:\w{1,4}|%)'?)?(?:=|<|>)(?'?\w{0,4}'?)?|order\s+by\s+\d+)(?:#|--\s*\w{0,4})?$" \ "id:1,rev:5,msg:'COMODO WAF: SQLmap attack detected',phase:2,severity:2,capture,block,setvar:'tx.sqli_points=+%{tx.points_limit4}',setvar:'tx.points=+%{tx.points_limit4}',logdata:'Matched Data: %{TX.0} found within %{MATCHED_VAR_NAME}: %{MATCHED_VAR}',ctl:'auditLogParts=+E',t:'none',t:'urlDecodeUni',t:'lowercase'"

2

I had the same issue. CiviCRM 4.7/Drupal 7/IIS8 configuration. The Ajax call was generating a query longer than what the web server was configured to handle and behind the scenes the web server was throwing an error, but it is not logged to the Civicrm log nor the Drupal log.

I was able to solve this by increasing the query string length in IIS.

  • In IIS Manager select the site
  • Choose the Request filtering icon
  • Navigate to the query string tab
  • Click the edit feature settings
  • Change the Maximum query string (Bytes) from 2048 to 4096 or something larger

Contact Relationships now show properly.

1

This sounds like a bug you could probably report the bug the issue tracker: http://issues.civicrm.org

As 4.7 is verly new it might contains a few bugs.

1

I have tested the above issue against WP 4.6.1 and CiviCRM 4.7.11. I am running Apache 2.4, php 5.6 and MySQL 5.6. The OS is CentOS 6.

I cannot reproduce this error nor the one mentioned AJAX error when viewing contact groups

I commented in https://issues.civicrm.org/jira/browse/CRM-19331 about this as well.

I would suspect the issue here is due to either a plugin conflict or something specific to the Hosting Configuration. I am interested if these issues are specific to a host or a specific configuration.

I'd disable all plugins (except CiviCRM) and see if you can trace errors in you apache and php logs. I would also revert to a default theme (CiviCRM demo sites are tested with TwentyThirteen) I'd also look at the CiviCRM logs. The CiviCRM logins should be in the /civicrm/ConfigAndLog directory that is stored in the WP upload directory in 4.7

I'd be interested if these issues are specific to a host or a specific configuration.

1

I had a very similar issue. It turned out to be a limitation of the web-server on the maximum number of characters in the GET request. It was set to 2048 characters, whereas the request was bigger than 2200 characters. Increasing the limitation on the webserver solved my issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.