CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
Pages: [1]

Author Topic: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati  (Read 10885 times)

c4i

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3.4
  • CMS version: Drupal
  • MySQL version: 7.22
  • PHP version: 5.3.15
DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 18, 2015, 03:59:30 pm
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 19, 2015, 06:35:21 am
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.
Try asking your question on the new CiviCRM help site.

c4i

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3.4
  • CMS version: Drupal
  • MySQL version: 7.22
  • PHP version: 5.3.15
Re: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 19, 2015, 05:16:31 pm
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 20, 2015, 07:36:09 am
Is this maybe the same issue as https://issues.civicrm.org/jira/browse/CRM-15845 ?
Try asking your question on the new CiviCRM help site.

c4i

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3.4
  • CMS version: Drupal
  • MySQL version: 7.22
  • PHP version: 5.3.15
Re: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 20, 2015, 02:56:08 pm
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 21, 2015, 07:52:05 am
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.
Try asking your question on the new CiviCRM help site.

c4i

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3.4
  • CMS version: Drupal
  • MySQL version: 7.22
  • PHP version: 5.3.15
Re: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 21, 2015, 06:22:52 pm
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 post occasionally
  • **
  • Posts: 79
  • Karma: 3
  • CiviCRM version: 3.4 and 4.0
  • CMS version: Drupal 6.17, 6.x and Drupal 7.x
  • PHP version: 5.2
Re: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati
January 28, 2015, 11:31:36 pm
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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DataTables warning: table id=DataTables_Table_0 - Ajax error. For more informati

This forum was archived on 2017-11-26.