CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • DB Error: Merge duplicate contacts [resolved]
Pages: [1]

Author Topic: DB Error: Merge duplicate contacts [resolved]  (Read 1583 times)

anorthite

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7.34
  • MySQL version: 5.3.12-MariaDB
  • PHP version: 5.4.20
DB Error: Merge duplicate contacts [resolved]
October 13, 2012, 02:33:33 pm
"Find and Merge Duplicate Contacts" is producing this error:

PEAR_Exception: DB Error: no such field in CRM_Core_Error::exceptionHandler() (line 676 of .../sites/all/modules/civicrm/CRM/Core/Error.php).

I'm not sure how to diagnose what is happening. Any help would be appreciated.  :)
« Last Edit: October 17, 2012, 05:00:35 pm by anorthite »

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: DB Error: Merge duplicate contacts
October 15, 2012, 10:23:23 am
Troubleshooting steps:
* Is debug mode on?  If so, you should get a traceback.  Posting the traceback here will allow folks to make better suggestions.  Ideally, this is happening on a non-production instance of your CiviCRM install.
* Is the problem happening on demo.civicrm.org?

Hope that gets you moving forward!
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

anorthite

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7.34
  • MySQL version: 5.3.12-MariaDB
  • PHP version: 5.4.20
Re: DB Error: Merge duplicate contacts
October 15, 2012, 10:53:49 am
Thanks, debug mode did help, I found where the problem is by trying to view one of the affected contacts:

Database Error Code: Unknown column 'civicrm_value_XXXXX' in 'field list', 1054

I'm not sure how that happened when the user of civicrm had no access to the database.

Edit: I tried to add the missing row to the column using mysql and got this error:

ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

I'm the admin not the user, so I have to guess how this happened. Could they have added too many values somewhere? Is this a CiviCRM bug?
« Last Edit: October 15, 2012, 06:11:14 pm by anorthite »

anorthite

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7.34
  • MySQL version: 5.3.12-MariaDB
  • PHP version: 5.4.20
Re: DB Error: Merge duplicate contacts
October 17, 2012, 05:00:05 pm
This was caused by having more than 40 fields in a custom field set. Why does civicrm allow the user to enter more than the db can handle?  ???

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: DB Error: Merge duplicate contacts [resolved]
October 17, 2012, 05:13:33 pm

yes, we need a lot better error handling in that section of the  code.

any chance you can take a look at the code and contribute a few patches to give the user a reasonable error and not allow things that exceed various mysql limits

lobo
 
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

anorthite

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7.34
  • MySQL version: 5.3.12-MariaDB
  • PHP version: 5.4.20
Re: DB Error: Merge duplicate contacts [resolved]
October 17, 2012, 07:17:01 pm
I would if I knew php.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: DB Error: Merge duplicate contacts [resolved]
October 18, 2012, 10:48:09 am

Thats ok :) There are other ways of contributing back besides code:

check:

http://book.civicrm.org/user/current/the-civicrm-community/civicrm-community/

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • DB Error: Merge duplicate contacts [resolved]

This forum was archived on 2017-11-26.