CiviCRM Community Forums (archive)

When I try to edit a contact I am getting a SQL Syntax error. The following sql is being generated, which looks like a mashup of a couple of different sql statements

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)
I looked at the code in CRM/Dedupe/BAO/RuleGroup.php where this sql statement is generated and it doesn't look like this sql statement could have come from that bit of code. I have emptied the civicrm cache folder and restarted apache to make sure that the APC cache wasn't storing something strange. Is there anything else I should try?

Here is the backtrace generated by the error:

/home/user/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/home/user/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/home/user/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/home/user/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home/user/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home/user/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/user/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/user/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2421
/home/user/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1607
/home/user/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 145
/home/user/public_html/sites/all/modules/civicrm/CRM/Dedupe/BAO/RuleGroup.php, query, 220
/home/user/public_html/sites/all/modules/civicrm/CRM/Dedupe/Finder.php, fillTable, 107
/home/user/public_html/sites/all/modules/civicrm/CRM/Contact/Form/Contact.php, dupesByParams, 1040
/home/user/public_html/sites/all/modules/civicrm/CRM/Contact/Form/Edit/Individual.php, checkDuplicateContacts, 135
, formRule,
/home/user/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm.php, call_user_func, 1597
/home/user/public_html/sites/all/modules/civicrm/CRM/Core/Form.php, validate, 293
/home/user/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php, validate, 137
/home/user/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php, realPerform, 130
/home/user/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/user/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/user/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284
/home/user/public_html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 115
/home/user/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 191
/home/user/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 355
, civicrm_invoke,
/home/user/public_html/includes/menu.inc, call_user_func_array, 348
/home/user/public_html/index.php, menu_execute_active_handler, 18

I was having a similar error- when people went to make a donation, it gave a db error-  before sending them to paypal.
I had made an unsupervised rule- to match voterID number in an import- thinking I was smart.
It was based on a field that voters wouldn't ever know.
However, when the donor tired to donate- it was giving syntax error.
It wasn't clear what the fields should contain- for length and weight- since it was the only rule I was using-
changing them to 7 for length and 1 for weight and changing it from unsupervised, to supervised- and then back to supervised seeemed to fix it.
There isn't a clear way to delete the rule.
Can some shed some light on what the length is supposed to do- and what the weight means?
Also- how to delete a rule?
And- why it's part of the process on creating a new record?
I don't see it in the process of creating a contribution form.
Thanks