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 »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
Pages: [1]

Author Topic: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4  (Read 2970 times)

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 11:14:18 am
Any insight into this problem would be greatly appreciated.

I am on PHP4, so I have to use CiviCRM 1.8 with Drupal 5+


Code: [Select]
     

   Sorry. A non-recoverable error has occurred.

    Database Error Code: Cannot add or update a child row: a foreign key constraint fails, 1216

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , hash ) VALUES ( 1 , 'Individual' , 'admin@culturekitchen.com' , 'admin@culturekitchen.com' , '40ee97a5b32cb62648f961c4adcb848f' )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [type] => db_error
    [user_info] => INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , hash ) VALUES ( 1 , 'Individual' , 'admin@culturekitchen.com' , 'admin@culturekitchen.com' , '40ee97a5b32cb62648f961c4adcb848f' )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , hash ) VALUES ( 1 , 'Individual' , 'admin@culturekitchen.com' , 'admin@culturekitchen.com' , '40ee97a5b32cb62648f961c4adcb848f' )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)
thanks in advance for any input. [/code]

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 11:26:27 am
Can you give more details when you get this error?

kurund
Found this reply helpful? Support CiviCRM

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Re: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 12:52:24 pm
when i go into CiviCRMs main page inside Drupal

so the path is http://SITENAME.com/SITEFOLDER/civicrm/admin?reset=1

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: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 02:10:52 pm

1. note that we no longer support v1.8 :(

2. most likely you are missing an entry with id=1 in civicirm_domain table. if you can verify this that would be great

3. Did u load civicrm_data.mysql or civicrm_generated.mysql into your db?

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

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Re: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 02:32:41 pm
Quote from: Donald Lobo on January 12, 2008, 02:10:52 pm

1. note that we no longer support v1.8 :(

yeah ... unfortunately not everybody is running PHP5

Quote
2. most likely you are missing an entry with id=1 in civicirm_domain table. if you can verify this that would be great

3. Did u load civicrm_data.mysql or civicrm_generated.mysql into your db?

lobo

i just reckoned i have not successfully been able to do so. i get the following error message :


Quote
Error

SQL query:

-- MySQL dump 10.11
--
-- Host: localhost Database: ns2008
-- ------------------------------------------------------
-- Server version 5.0.41-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL said: Documentation
#1065 - Query was empty

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Re: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 02:37:08 pm
Quote from: Donald Lobo on January 12, 2008, 02:10:52 pm
2. most likely you are missing an entry with id=1 in civicirm_domain table. if you can verify this that would be great

Seems like it. This is all there is :(

Quote
INSERT INTO `civicrm_domain` VALUES (1, NULL, NULL, 'Domain Contact Name', 'FIXME.ORG', NULL, 'a:80:{s:11:"initialized";i:0;s:5:"debug";i:0;s:9:"backtrace";i:0;s:8:"daoDebug";i:0;s:9:"smartyDir";s:26:"/opt/local/lib/php/Smarty/";s:10:"pluginsDir";s:34:"/opt/local/lib/php/Smarty/plugins/";s:11:"templateDir";s:12:"./templates/";s:8:"mainMenu";N;s:12:"resourceBase";N;s:15:"DAOFactoryClass";s:23:"CRM_Contact_DAO_Factory";s:9:"uploadDir";s:75:"/home/liza/domains/culturekitchenmedia.com/public_html/ns2008/files/upload/";s:14:"imageUploadDir";s:87:"/home/liza/domains/culturekitchenmedia.com/public_html/ns2008/files/persist/contribute/";s:19:"customFileUploadDir";s:75:"/home/liza/domains/culturekitchenmedia.com/public_html/ns2008/files/custom/";s:14:"imageUploadURL";s:71:"http://culturekitchenmedia.com/ns2008/files/civicrm/persist/contribute/";s:8:"cleanURL";b:0;s:12:"countryLimit";i:1228;s:13:"provinceLimit";a:1:{i:0;b:0;}s:21:"defaultContactCountry";b:0;s:15:"defaultCurrency";s:3:"USD";s:10:"lcMessages";s:5:"en_US";s:18:"dateformatDatetime";s:20:"%B %E%f, %Y %l:%M %P";s:14:"dateformatFull";s:11:"%B %E%f, %Y";s:17:"dateformatPartial";s:5:"%B %Y";s:14:"dateformatYear";s:2:"%Y";s:16:"dateformatQfDate";s:8:"%b %d %Y";s:20:"dateformatQfDatetime";s:20:"%b %d %Y, %I : %M %P";s:15:"fiscalYearStart";a:2:{s:1:"M";i:1;s:1:"d";i:1;}s:11:"moneyformat";s:5:"%c %a";s:10:"lcMonetary";s:5:"en_US";s:15:"currencySymbols";s:0:"";s:21:"defaultCurrencySymbol";N;s:14:"gettextCodeset";s:5:"utf-8";s:13:"gettextDomain";s:7:"civicrm";s:10:"smtpServer";N;s:8:"smtpPort";i:25;s:8:"smtpAuth";b:0;s:12:"smtpUsername";N;s:12:"smtpPassword";s:0:"";s:13:"userFramework";s:6:"Drupal";s:20:"userFrameworkVersion";d:4.5999999999999996447286321199499070644378662109375;s:18:"userFrameworkClass";s:23:"CRM_Utils_System_Drupal";s:13:"userHookClass";s:21:"CRM_Utils_Hook_Drupal";s:19:"userPermissionClass";s:26:"CRM_Core_Permission_Drupal";s:19:"userFrameworkURLVar";s:1:"q";s:16:"userFrameworkDSN";N;s:27:"userFrameworkUsersTableName";s:5:"users";s:24:"userFrameworkResourceURL";s:64:"http://culturekitchenmedia.com/ns2008/sites/all/modules/civicrm/";s:21:"userFrameworkFrontend";b:0;s:12:"mysqlVersion";d:4.0999999999999996447286321199499070644378662109375;s:9:"mysqlPath";s:9:"/usr/bin/";s:17:"maxImportFileSize";i:1048576;s:11:"mapProvider";N;s:9:"mapAPIKey";N;s:13:"geocodeMethod";s:0:"";s:12:"versionCheck";b:1;s:12:"mailerPeriod";i:180;s:13:"verpSeparator";s:1:".";s:16:"mailerBatchLimit";i:0;s:16:"enableComponents";a:3:{i:0;s:14:"CiviContribute";i:1;s:10:"CiviMember";i:2;s:9:"CiviEvent";}s:9:"enableSSL";b:0;s:18:"fatalErrorTemplate";s:13:"CRM/error.tpl";s:17:"fatalErrorHandler";N;s:14:"legacyEncoding";s:12:"Windows-1252";s:17:"maxLocationBlocks";i:2;s:15:"captchaFontPath";s:25:"/usr/X11R6/lib/X11/fonts/";s:11:"captchaFont";s:17:"HelveticaBold.ttf";s:24:"includeAlphabeticalPager";i:1;s:20:"includeOrderByClause";i:1;s:15:"includeDomainID";i:1;s:13:"oldInputStyle";i:1;s:11:"includeDojo";i:1;s:7:"cmsCall";b:0;s:12:"mapGeoCoding";i:1;s:20:"paymentExpressButton";s:57:"https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif";s:27:"paymentPayPalExpressTestUrl";s:22:"www.sandbox.paypal.com";s:23:"paymentPayPalExpressUrl";s:14:"www.paypal.com";s:25:"googleCheckoutButton_test";s:126:"http://sandbox.google.com/checkout/buttons/checkout.gif?merchant_id=[MerchantID]&w=180&h=46&style=white&variant=text&loc=en_US";s:25:"googleCheckoutButton_live";s:118:"http://checkout.google.com/buttons/checkout.gif?merchant_id=[MerchantID]&w=180&h=46&style=white&variant=text&loc=en_US";s:21:"googleCheckoutTestUrl";s:27:"sandbox.google.com/checkout";s:17:"googleCheckoutUrl";s:19:"checkout.google.com";}', NULL);

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: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 06:02:33 pm

what version of mysql are you using? You will need to fix the mysql error message you are getting and load the civicrm files.

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

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Re: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 06:05:26 pm
Quote from: Donald Lobo on January 12, 2008, 06:02:33 pm

what version of mysql are you using? You will need to fix the mysql error message you are getting and load the civicrm files.

lobo



MySQL 4.1.11-standard running on localhost

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: Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4
January 12, 2008, 07:19:01 pm

You will need to experiment and tweak the civicrm_data.mysql file to get your version of mysql to load the civicrm data files.

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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Unrecoverable Error : Drupal 5, CiviCRM 1.8, Php 4

This forum was archived on 2017-11-26.