DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati

[c4i]

After upgrading to CiviCRM 4.5.5, I can no longer display relationships. The relationships still exist in the database and I can add new ones. I just can't display (and therefore can't edit/delete).

The platform is SUSE Linux / Druplal 7, CiviCRM 4.5.5. The upgrade proceeded with no errors that I'm aware of. I upgraded from 4.5.2

Is this a known issue?
Thanks
Eric.

[Coleman Watts]

Well it's known in the sense that if your server sends a malformed json response then datatables don't work right.
The most common cause is that you have php set to display warnings on the screen instead of logging them to a file.
You can verify this is the problem by opening up your browser console (F12) and inspecting the response you're getting from the server when it fetches that datatable.

[c4i]

Thank for your post. I can't say I fully understand what you are saying. However, I can see the following from the browser.

https://c4i.ucb.com.au/c4i/index.php?q=civicrm/ajax/contactrelationships&context=current&cid=1926&sEcho=1&iColumns=11&sColumns=%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C&iDisplayStart=0&iDisplayLength=10&mDataProp_0=0&bSortable_0=true&mDataProp_1=1&bSortable_1=true&mDataProp_2=2&bSortable_2=true&mDataProp_3=3&bSortable_3=true&mDataProp_4=4&bSortable_4=true&mDataProp_5=5&bSortable_5=true&mDataProp_6=6&bSortable_6=true&mDataProp_7=7&bSortable_7=true&mDataProp_8=8&bSortable_8=false&mDataProp_9=9&bSortable_9=false&mDataProp_10=10&bSortable_10=false&iSortingCols=0&_=1421715719386

I get a status code 403 for this path. If you have any other advice, I'd appreciate it. Anything to check, etc? I've checked rights on the web server and they look fine. If need be, I'll get one of my web specialists to have a look if you have any further ideas I don't understand.
Thanks
Eric.

[Coleman Watts]

Is this maybe the same issue as https://issues.civicrm.org/jira/browse/CRM-15845 ?

[c4i]

Thank for your reply, undoubtedly this is the same issue. Is it something a user can fix, or is it a developer issue?
Is there a work around at all?
Thanks
Eric.

[Coleman Watts]

I guess that depends on what kind of user you are
If you have basic command-line skills then try applying the patch:

Code: [Select]

cd path/to/civicrm
wget https://github.com/civicrm/civicrm-core/pull/4985.diff
patch -p0 < 4985.diff

Then you would need to go to Administer -> System Settings -> Cleanup Caches and Update Paths and click on the "Cleanup Caches" button.

[c4i]

Thanks Coleman,

Although I wasn't able to apply the patch programmatically, it was so minor that I did it manually and it has solved the problem.
Many thanks
Eric.

[Aahar]

I did just as it is suggested here. but i still have the same problem (after upgrade from 4.3.5 to 4.5.5)

1) Did manually and also using the command line. Cleared caches. Yet cannot see relationship.

An upgrade to 4.4.6 from 4.3.5 does not have this problem