CiviCRM Community Forums (archive)

I just did a new install of Drupal 7 and CiviCRM 4.1.1 and at the end I get an error.

There's alot of output, so I will summarize with a short clip.
Also, I can see that now the civicrm_option_value table is empty and civicrm_component table has a value for each CiviCRM component.


DB_Error Object
(
    [error_message_prefix] =>
    [mode] => 1
    [level] => 1024
    => -3
    [message] => DB Error: constraint violation
    [userinfo] => INSERT INTO
   `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`)
VALUES
   (@option_group_id_pcm, 'Phone', 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
   (@option_group_id_pcm, 'Email', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
   (@option_group_id_pcm, 'Postal Mail', 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
   (@option_group_id_pcm, 'SMS', 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
   (@option_group_id_pcm, 'Fax', 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
 
   (@option_group_id_act, 'Meeting',                            1, 'Meeting', NULL, 0, NULL, 1, NULL,                                                                        0, 1, 1, NULL, NULL),
   (@option_group_id_act, 'Phone Call',                         2, 'Phone Call',          NULL, 0, NULL, 2, NULL,                                                          0, 1, 1, NULL, NULL),
   (@option_group_id_act, 'Email',                              3, 'Email',               NULL, 1, NULL, 3, 'Email sent.',                                                          0, 1, 1, NULL, NULL),
   (@option_group_id_act, 'Text Message (SMS)',                 4, 'SMS',                 NULL, 1, NULL, 4, 'Text message (SMS) sent.',                                             0, 1, 1, NULL, NULL),

...

Lotsa other messages here of a similar type.
...

[4] => 1452 ** Cannot add or update a child row: a foreign key constraint fails (`crm_civicrm/civicrm_option_value`, CONSTRAINT `FK_civicrm_option_value_component_id` FOREIGN KEY (`component_id`) REFERENCES `civicrm_component` (`id`))
                        )
...

Any ideas?

MySQL version 5.0.77

Thanks. I do see that now in the requirements, but I can't figure out why I have this working on another server running MySQL 5.0.95 as a new install.

The only difference is I also loaded the sample data when I did that install which was CiviCRM version 4.1.0.

I understand. Now I have to see if our IT dept has MySQL 5.1+ running somewhere.

Thanks!

For development, I do accidentally have it working under mysql 5.0 on one server, but given that mysql 5.1 support is required, there will eventually be some functionality that you hit or that is utilized in a future update that will attempt to use features of 5.1. At that point, you will be sorry.

When I looked into this recently, I believe I saw a prior version of CiviCRM didn't have this requirement, but you won't have an upgrade path.

I've exactly tesame error as andersiversen.
Install civicrm 4.3.0 on a new drupal 7.22 installation.

In attachment the logfile with the error civicrm returns.

Thanks for sharing your solution petbos - that did the trick for me as well.
Also, when failing, I  untar'ed the localization files before install - so I didn't do that, and didn't touch the language dropdown on the install page and then it worked.
Well it almost worked - because the installer didn't finished and I got a WSOD. So I looked in the server's error log and found out that the install script exhausted the memory allowed to be used by PHP. I bumped it up to 160M - that wasn't enough, so I bumped it to 256M and it finally worked (in case anyone reading are wondering: that's in php.ini - the memory_limit setting).