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 »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Unable to access Civicrm at all due to "DB Error: constraint violation"
Pages: [1]

Author Topic: Unable to access Civicrm at all due to "DB Error: constraint violation"  (Read 1852 times)

radrotor

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4.8
  • CMS version: Joomla 1.5.25
  • MySQL version: 5.0.91
  • PHP version: 5.2.5
Unable to access Civicrm at all due to "DB Error: constraint violation"
March 24, 2012, 06:38:00 am
New install on joomla successfully installed, all files created, component present in admin, however when trying to access Civicrm, either on backend through Joomla admin or front end by menu the following error occurs:

 A non-recoverable error has occurred.
DB Error: constraint violation
Error Details
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`taxicab9_joom403/civicrm_uf_match`, CONSTRAINT `FK_civicrm_uf_match_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`)), 1452
Additional Details:

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
         
     
    I have Acesef installed, disabled to test, still a problem.
    Anybody able to help?

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: Unable to access Civicrm at all due to "DB Error: constraint violation"
March 24, 2012, 07:54:01 am

Most likely your install did not complete properly. Seems like the "core meta" data was not loaded :(

Can you use PMA to check:

1. If there are any records in the tables: civicrm_domain, civicrm_option_group, civicrm_location_type

2. How many civicrm_* tables are there in your DB (a rough approximation is fine)

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

radrotor

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4.8
  • CMS version: Joomla 1.5.25
  • MySQL version: 5.0.91
  • PHP version: 5.2.5
Re: Unable to access Civicrm at all due to "DB Error: constraint violation"
March 24, 2012, 09:24:54 am
There are no records in those 3 tables.

Total civicrm_* tables,     128

Thanks for prompt response :)

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: Unable to access Civicrm at all due to "DB Error: constraint violation"
March 24, 2012, 03:13:56 pm

not sure what version u r on, but both 3.4/4.0/4.1 have 140+ tables. so seems like the installer "died" while trying to load the sql stuff

i'd recommend trying the installer again and keeping a close watch on the error log

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

radrotor

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4.8
  • CMS version: Joomla 1.5.25
  • MySQL version: 5.0.91
  • PHP version: 5.2.5
Re: Unable to access Civicrm at all due to "DB Error: constraint violation"
March 25, 2012, 01:32:35 am
Have tried repeat installs, my problem lies with server php max execution settings 45.
Can never complete the install.

Have requested server assistance with no joy.
See this response:

The shared server have are configured to meet the industry standards. According to this we cannot change the main configuration per user request. In this case you can contact the developers of the extension and ask for assistance. The second option is to contact a local developer and ask your application and / or extension to be reconfigured.

Is it possible to break the install package into smaller install packages? Can I do it?

I am sure a lot of Joomla users are having this problem.

 Having looked at the demo, I really want to get this extension to work.

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: Unable to access Civicrm at all due to "DB Error: constraint violation"
March 25, 2012, 07:46:05 am

Was not aware that shared servers have "industry standards" :)

Your best bet would be to switch to a better hosting plan and/or provider. CiviCRM is a fairly heavy module and requires a fair amount of resources. Broadly speaking, cheap shared hosting is not the best environment to host CiviCRM

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

radrotor

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4.8
  • CMS version: Joomla 1.5.25
  • MySQL version: 5.0.91
  • PHP version: 5.2.5
Re: Unable to access Civicrm at all due to "DB Error: constraint violation"
March 25, 2012, 09:05:22 am
Thanks.

radrotor

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4.8
  • CMS version: Joomla 1.5.25
  • MySQL version: 5.0.91
  • PHP version: 5.2.5
Re: Unable to access Civicrm at all due to "DB Error: constraint violation"
March 26, 2012, 12:38:25 am
Here is the workaround for Joomla users using shared hosting or experience server problems.
Create a sub-domain and install Drupal into the sub domain.
Install the Drupal version of Civicrm.
 Use the wrapper menu or module function in Joomla to access Civicrm
I did it and so far it works like a dream ;D ;D ;D ;D
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Unable to access Civicrm at all due to "DB Error: constraint violation"

This forum was archived on 2017-11-26.