I'm Running Civi 5.0.0 with Wordpress 4.9.5

I'm looking to troubleshoot the following warning. It comes up on the Find and Merge page after select any of my Find and Merge rules - no results are shown despite duplicate contacts existing,

DataTables warning: table id=dupePairs - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

ajax "response" in Chrome's tab shows what looks like the page's html file - I have no idea where to search for the actual ajax: Response tab in Chrome

No error is recorded in Civi's log.

It looks and sounds a lot like this bug. Which is odd because I assume it would have fixed when upgrading to Civi 5.0

This staging site was running 4.7.17 until I updated to 5.0 (I had to manually create the columns card_type, and pan_truncation in the civicrm_financial_trxn table to complete the update).

Looking at the github patch, my dedupefind.tpl appears to contain the patched lines. Is there a part of the patch I'm missing via the WP copy or something else?

  • 1
    That looks like a different error/bug than the one on issues.civicrm.org. Is there anything in the apache/httpd log like an error 500 or 403/404 for the ajax call? Or can you manually see which ajax call/url is returning the invalid json and what the response looks like? – Demerit Apr 13 '18 at 19:50
  • If the following isn't enough I'll have to look up how to check the ajax/url stuff. As far as I know, I only have access to the CPanel Error Log, which doesn't show anything recorded. Looking at my browser's inspector everything is loaded except for the civicrm logo "logo16px" (no idea why it's been missing since the install) and a 302 redirect from .../wp-admin/admin.php?page=CiviCRM&q=civicrm/contact/dedupefind&reset=1&rgid=10&gid=&limit=&action=renew to .../wp-admin/.../dedupefind&reset=1&rgid=10&gid=&limit=&action=update – Evan Apr 14 '18 at 9:20
  • 1
    The browser inspector should work. That screenshot seems like the wrong screenshot though. – Demerit Apr 14 '18 at 13:18
  • 1
    Try visiting /wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1 to rebuild the routing table. It seems like it's not recognizing how to route civicrm/ajax/dedupefind. – Demerit Apr 14 '18 at 15:05
  • 1
    I have the same problem on the Joomla version of 5.0.0. No error in the CiviCRM log or the Apache log. Tried rebuild&reset, but no change. – Jern Apr 15 '18 at 19:13

I've taken a look at this & a patch should be out next week (I'm expecting that to mean we will release 5.0.1 - the flexibility to do that being the main motivation for the renumbering)

  • Thanks for the info. Edit: Is there a place where I can try the patch out before? I need dedupe to test some issues I'm having with my database. – Evan Apr 16 '18 at 9:07
  • 1
  • 1
    Thank you for posting this - I just spent the last hour trying to figure this out - glad there is a solution – themak Apr 18 '18 at 2:25
  • 1
    patched it with old code - did the trick – themak Apr 18 '18 at 2:32
  • @user4278 Friggin' beautiful. Works again. Many thanks. – Evan Apr 19 '18 at 18:36

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.