2

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?

Improve this question
10
  • 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
    Commented Apr 13, 2018 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
    Commented Apr 14, 2018 at 9:20
  • 1
    The browser inspector should work. That screenshot seems like the wrong screenshot though.
    – Demerit
    Commented Apr 14, 2018 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
    Commented Apr 14, 2018 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
    Commented Apr 15, 2018 at 19:13

1 Answer 1

Reset to default
2

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)

Improve this answer
5
  • 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
    Commented Apr 16, 2018 at 9:07
  • 1
    github.com/civicrm/civicrm-core/pull/11975
    – user4278
    Commented Apr 17, 2018 at 21:14
  • 1
    Thank you for posting this - I just spent the last hour trying to figure this out - glad there is a solution
    – themak
    Commented Apr 18, 2018 at 2:25
  • 1
    patched it with old code - did the trick
    – themak
    Commented Apr 18, 2018 at 2:32
  • @user4278 Friggin' beautiful. Works again. Many thanks.
    – Evan
    Commented Apr 19, 2018 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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