Answers.Body: <p>This doesn't look like a Wordpress compatibility error.  It is, as you guessed, related to deduplication.</p>
  
  <p>It sounds like you may not have a rule designated as your "Supervised" dedupe rule - or there's a problem with the rule you have designated as your "Supervised" rule.  Check to make sure you have a rule, and if you do, try changing it to the default Supervised dedupe rule.  That should clear your problem.  Then you can troubleshoot the dedupe rule itself.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-15T11:43:22.423Z
Answers.Text: thanks!
  
  but... can I delete a reserved rule?
Answers.UserDisplayName: yvose
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-15T12:10:16.347Z
Answers.Text: You can't delete a reserved rule - or at least you shouldn't!
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-13T03:52:26.760Z
Answers.LastActivityDate: 2015-09-13T03:52:26.760Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Experienced the same problem on CiviCRM 4.7.... Creating an Individual contact resulted in "DB Error: syntax error" message on the front end. A custom de-dupe rule had been set as the "Supervised" rule, with just a single field from a multi-record custom data set. This naturally doesn't make sense as it's a multi-value data set and could have duplicate values for a single contact.</p>
  
  <p>Setting the default "Name only" rule as the "Supervised" rule resolved the issue.</p>
  
  <p>Lesson learned - do not use multi value custom data set fields in "Supervised" de-dupe rules.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-11T10:26:19.487Z
Answers.LastActivityDate: 2016-04-11T10:26:19.487Z
Answers.UserDisplayName: Darren
Body: <p>CiviCRM 4.6.8
  Wordpress 4.3
  MySQL Apache/2.2.22 (Debian)
  Datenbank-Client Version: libmysql - 5.5.44</p>
  
  <p>I've imported contacts, added new contacts, without any problem.</p>
  
  <p>Then I've added a rule for individuals in "Find and merge duplicate contacts". and added following rule: 
  "Firstname Lastname"; 
  "supervised";
  "field=LastName"
  "field=First Name". Saved and used the rule.</p>
  
  <p>The message i've got was: <strong>"DB Error: syntax error"</strong></p>
  
  <p>Now I'm not able to add a new contact... </p>
  
  <p>I've already tested this in the public demo and it didn't show an error-message.</p>
  
  <p>Can someone help?</p>
  
  <p>Here are the Error Details:</p>
  
  <p>Sep 10 18:22:10  [info] $Fatal Error Details = Array (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )</p>
  
  <pre><code>[code] =&gt; -2
  [message] =&gt; DB Error: syntax error
  [mode] =&gt; 16
  [debug_info] =&gt; INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
  [type] =&gt; DB_Error
  [user_info] =&gt; INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
  [to_string] =&gt; [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]"]
  </code></pre>
  
  <p>)</p>
  
Tags: <wordpress><error-page>
Title: CiviCRM 4.6.8 compatible with Wordpress 4.3?
ThreadText: # CiviCRM 4.6.8 compatible with Wordpress 4.3?
  
  (Asked by: username_0 on 2015-09-12)
  
  CiviCRM 4.6.8
  Wordpress 4.3
  MySQL Apache/2.2.22 (Debian)
  Datenbank-Client Version: libmysql - 5.5.44
  I've imported contacts, added new contacts, without any problem.
  Then I've added a rule for individuals in "Find and merge duplicate contacts". and added following rule: 
  "Firstname Lastname"; 
  "supervised";
  "field=LastName"
  "field=First Name". Saved and used the rule.
  The message i've got was: "DB Error: syntax error"
  Now I'm not able to add a new contact... 
  I've already tested this in the public demo and it didn't show an error-message.
  Can someone help?
  Here are the Error Details:
  Sep 10 18:22:10  [info] $Fatal Error Details = Array (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  [code] => -2
  [message] => DB Error: syntax error
  [mode] => 16
  [debug_info] => INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
  [type] => DB_Error
  [user_info] => INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
  [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]"]
  
  )
  
  **Tags:** wordpress, error-page
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-09-13. Score: 2
  
  This doesn't look like a Wordpress compatibility error. It is, as you guessed, related to deduplication.
  
  It sounds like you may not have a rule designated as your "Supervised" dedupe rule - or there's a problem with the rule you have designated as your "Supervised" rule. Check to make sure you have a rule, and if you do, try changing it to the default Supervised dedupe rule. That should clear your problem. Then you can troubleshoot the dedupe rule itself.
  
  > **Comments:**
  > **username_0**: thanks!  but... can I delete a reserved rule?  
  > **username_1**: You can't delete a reserved rule - or at least you shouldn't!  
  
  ---
  
  ### Answer by username_2 on 2016-04-11. Score: 0
  
  Experienced the same problem on CiviCRM 4.7.... Creating an Individual contact resulted in "DB Error: syntax error" message on the front end. A custom de-dupe rule had been set as the "Supervised" rule, with just a single field from a multi-record custom data set. This naturally doesn't make sense as it's a multi-value data set and could have duplicate values for a single contact.
  
  Setting the default "Name only" rule as the "Supervised" rule resolved the issue.
  
  Lesson learned - do not use multi value custom data set fields in "Supervised" de-dupe rules.
  
  
  ---
  
  