Answers.Body: <p>I've taken a look at this &amp; 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)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-16T09:07:08.673Z
Answers.Text: 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.
Answers.UserDisplayName: Evan
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-17T21:14:53.773Z
Answers.Text: https://github.com/civicrm/civicrm-core/pull/11975
Answers.UserDisplayName: user4278
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-18T02:25:05.947Z
Answers.Text: Thank you for posting this - I just spent the last hour trying to figure this out - glad there is a solution
Answers.UserDisplayName: themak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-18T02:32:55.667Z
Answers.Text: patched it with old code - did the trick
Answers.UserDisplayName: themak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-19T18:36:26.530Z
Answers.Text: @user4278 Friggin' beautiful. Works again. Many thanks.
Answers.UserDisplayName: Evan
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-16T00:10:22.317Z
Answers.LastActivityDate: 2018-04-16T00:10:22.317Z
Answers.UserDisplayName: user4278
Body: <p>I'm Running Civi 5.0.0 with Wordpress 4.9.5</p>
  
  <p>I'm looking to troubleshoot the following warning. It comes up on the <em>Find and Merge</em> page after select any of my Find and Merge rules - no results are shown despite duplicate contacts existing,</p>
  
  <blockquote>
    <p>DataTables warning: table id=dupePairs - Invalid JSON response. For
    more information about this error, please see
    <a href="http://datatables.net/tn/1" rel="nofollow noreferrer">http://datatables.net/tn/1</a></p>
  </blockquote>
  
  <p>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:
  <a href="https://i.sstatic.net/ZNUv1.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ZNUv1.png" alt="Response tab in Chrome"></a></p>
  
  <p>No error is recorded in Civi's log. </p>
  
  <p>It looks and sounds a lot like <a href="https://issues.civicrm.org/jira/browse/CRM-20556" rel="nofollow noreferrer">this bug</a>. Which is odd because I assume it would have fixed when upgrading to Civi 5.0</p>
  
  <p>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).</p>
  
  <p>Looking at <a href="https://github.com/civicrm/civicrm-core/pull/10503/files" rel="nofollow noreferrer">the github patch</a>, my dedupefind.tpl <em>appears</em> to contain the patched lines. Is there a part of the patch I'm missing via the WP copy or something else?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-13T19:50:40.943Z
Comments.Text: 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?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-14T09:20:16.223Z
Comments.Text: 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
Comments.UserDisplayName: Evan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-14T10:01:31.280Z
Comments.Text: Sorry, the ajax stuff isn't in my realm of knowledge and I forgot about what I read yesterday. The 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: https://www.dropbox.com/s/4jnz9czoa2i4htz/Ajax%20response.png?dl=0
Comments.UserDisplayName: Evan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-14T13:18:54.357Z
Comments.Text: The browser inspector should work. That screenshot seems like the wrong screenshot though.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-14T14:03:33.830Z
Comments.Text: You would be correct - I thought it was a weird review to leave for Whitman's Leaves of Grass.
  
  This was the intended screenshot (I doubled checked it): https://www.dropbox.com/s/zqpb35yaoraz5x5/Ajax%20response.png?dl=0
Comments.UserDisplayName: Evan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-14T14:13:33.933Z
Comments.Text: Probably a bot review hehe. If you scroll down I expect there is some error text somewhere in there. If you visit that url manually what do you see?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-14T14:30:09.273Z
Comments.Text: I'm not sure what to look for but the file itself is html and calls for scripts.  Opening the URL only loads CiviCRM home. Edit: Here's the file, https://dl.dropboxusercontent.com/s/kyt1m18z3eomrkf/file-with-ajax-issue.txt
Comments.UserDisplayName: Evan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-14T15:05:16.720Z
Comments.Text: 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.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-15T19:13:22.757Z
Comments.Text: 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.
Comments.UserDisplayName: Jern
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-16T09:04:13.247Z
Comments.Text: @Demerit Thanks for the suggestion but it didn't seem to have any effect.
  
  And Jern; So it's not just me? Hm...
Comments.UserDisplayName: Evan
Tags: <wordpress><duplicate-contacts>
Title: DataTables warning on Find and Merge page - Upgraded to 5.0 from 4.7.17
ThreadText: # DataTables warning on Find and Merge page - Upgraded to 5.0 from 4.7.17
  
  (Asked by: username_0 on 2018-04-13)
  
  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](https://i.sstatic.net/ZNUv1.png)](https://i.sstatic.net/ZNUv1.png)
  
  No error is recorded in Civi's log.
  
  It looks and sounds a lot like [this bug](https://issues.civicrm.org/jira/browse/CRM-20556). 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](https://github.com/civicrm/civicrm-core/pull/10503/files), 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?
  
  **Tags:** wordpress, duplicate-contacts
  
  > **Comments:**
  > **username_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?  
  > **username_0**: 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  
  > **username_0**: Sorry, the ajax stuff isn't in my realm of knowledge and I forgot about what I read yesterday. The 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: https://www.dropbox.com/s/4jnz9czoa2i4htz/Ajax%20response.png?dl=0  
  > **username_1**: The browser inspector should work. That screenshot seems like the wrong screenshot though.  
  > **username_0**: You would be correct - I thought it was a weird review to leave for Whitman's Leaves of Grass.  This was the intended screenshot (I doubled checked it): https://www.dropbox.com/s/zqpb35yaoraz5x5/Ajax%20response.png?dl=0  
  > **username_1**: Probably a bot review hehe. If you scroll down I expect there is some error text somewhere in there. If you visit that url manually what do you see?  
  > **username_0**: I'm not sure what to look for but the file itself is html and calls for scripts.  Opening the URL only loads CiviCRM home. Edit: Here's the file, https://dl.dropboxusercontent.com/s/kyt1m18z3eomrkf/file-with-ajax-issue.txt  
  > **username_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.  
  > **username_2**: 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.  
  > **username_0**: @username_1 Thanks for the suggestion but it didn't seem to have any effect.  And username_2; So it's not just me? Hm...  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2018-04-16. Score: 2 | Accepted answer
  
  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)
  
  > **Comments:**
  > **username_0**: 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.  
  > **username_3**: https://github.com/civicrm/civicrm-core/pull/11975  
  > **username_4**: Thank you for posting this - I just spent the last hour trying to figure this out - glad there is a solution  
  > **username_4**: patched it with old code - did the trick  
  > **username_0**: @username_3 Friggin' beautiful. Works again. Many thanks.  
  
  ---
  
  