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.
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.
Contact Relationships now show properly.
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'"
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.
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.
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.
