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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Constraint Error Saving Contact Records post Installation
Pages: [1]

Author Topic: Constraint Error Saving Contact Records post Installation  (Read 1104 times)

peverist

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
    • Be The Change
  • CiviCRM version: 3.4.4
  • CMS version: Drupal 6.2
  • MySQL version: 5.1.49
  • PHP version: 5.3.3-7+squeeze3
Constraint Error Saving Contact Records post Installation
January 12, 2011, 01:16:54 am
I have recently installed CiviCRM as a Joomla component. I have added various custom data sets, imported some records and generally experimented with adding/editing/deleting contacts.
I am now getting non recoverable errors saying DB Constraint Violation whenever i attempt to save a contact record during edit (even if no changes are made) .
The display message (see attached) has a link for error details but it doesn't do anything.
I was on the 3.2beta version but have since upgraded to the latest stable 3.3 to see if it wold resolve the problem 3.3
There have been a number of similar errors post installation so I am not convinced I have a stable database.
I am thinking I should reinstall from scratch and starting again.
Any other suggestions?
If i go down the completely new install route is there anything I need to do to delete the existing CiviCRM database?

Thanks     

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Constraint Error Saving Contact Records post Installation
January 12, 2011, 02:20:46 am
Have you enabled the debug mode ? It will probably be more verbose and tell more about what sql command is the issue.

Could you paste the text of the error message? easier to read than a printscreen and will allow the search engine to index better and hopefully help others that might get the same problem than you.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

peverist

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
    • Be The Change
  • CiviCRM version: 3.4.4
  • CMS version: Drupal 6.2
  • MySQL version: 5.1.49
  • PHP version: 5.3.3-7+squeeze3
Re: Constraint Error Saving Contact Records post Installation
January 13, 2011, 04:06:55 am
thanks - I enabled Debug and BackTrace and got the following when saving a contact with no changes:
backTrace

/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2421
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1607
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 145
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 868
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomValueTable.php, executeQuery, 224
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomValueTable.php, create, 322
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php, store, 376
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Contact/Form/Contact.php, create, 903
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, postProcess, 250
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php, mainProcess, 153
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php, realPerform, 130
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 284
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php, run, 115
/home/bethech6/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 191
/home/bethech6/public_html/administrator/components/com_civicrm/admin.civicrm.php, invoke, 77
/home/bethech6/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/home/bethech6/public_html/libraries/joomla/application/component/helper.php, require_once, 162
/home/bethech6/public_html/administrator/includes/application.php, renderComponent, 136
/home/bethech6/public_html/administrator/index.php, dispatch, 67
/home/bethech6/public_html/administrator/index2.php, include, 14
Sorry. A non-recoverable error has occurred.
DB Error: constraint violation
Error Details
Return to home page.

The Error details link still doesn't work so I'm still not getting much more debug information - do I need to do something else to get the SQL command? 

bweber

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6.20
  • MySQL version: 5.1.54
  • PHP version: 5.2.17
Re: Constraint Error Saving Contact Records post Installation
April 03, 2011, 10:19:21 pm
I am seeing a similar problem when logged in as a non-Admin.   Was there any solution identified?
Barry
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Constraint Error Saving Contact Records post Installation

This forum was archived on 2017-11-26.