"DB Error: unknown error" upon install

[sdondley]

drupal 5.10
apache 2.0
mysql  Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2 with innodb
php 5.2

When I try to install without sample data, I see this ugliness: http://pastebin.ca/1199744

With sample data: http://pastebin.ca/1199745

Refreshing page does not help. Error just repeats.

Any ideas?

[Piotr Szotkowski]

This is very strange – and the MySQL error of ‘DB Error: unknown error’ is not that helpful either.

Do you control this server? I googled a bit and it seems this is most often a result of missing MySQL privileges – are you sure the user specified in the configuration has sane privileges?

[sdondley]

Yes, this is my server. User has all privileges for the db in question.

[sdondley]

I just double checked the user's privileges. phpmyadmin reports that the user has all database privileges but not table specific privileges.

[sdondley]

I don't think the table specific permissions has anything to do this problem, though. The user has all permissions on the database.

[sdondley]

OK, when I run the mysql query directly into the database that mysql chokes on when installing the sample data, I get this:

#1452 - Cannot add or update a child row: a foreign key constraint fails (`nwu_civicrm2/civicrm_custom_field`, CONSTRAINT `FK_civicrm_custom_field_custom_group_id` FOREIGN KEY (`custom_group_id`) REFERENCES `civicrm_custom_group` (`id`) ON DELETE CASCADE)

Here's the query I'm running:

INSERT INTO `civicrm_custom_field` ( `custom_group_id` , `label` , `data_type` , `html_type` , `is_required` , `weight` , `help_post` , `is_active` , `is_searchable` , `options_per_line` , `column_name` , `option_group_id` )
VALUES ( 1, 'Most Important Issue', 'String', 'Radio', 0, 1, '', 1, 1, NULL , 'most_important_issue', @option_most_id ) , ( 1, 'Marital Status', 'String', 'Select', 0, 2, '', 1, 1, NULL , 'marital_status', @option_marital_id )

[Deepak Srivastava]

Foreign key constraint error implies it expects a value to be present in another table, which currently its not able to find. Also in your query you haven't provided any value for @option_marital_id, so thats an expected error.

I would suggest creating a simple table with 3 to 4 columns and add some data into it, just to check if its a permission related issue. Make sure you are logged in as permissioned user before doing those operations (and not as some root user).

[sdondley]

Found the problem, it's a problem with civicrm installation sscript. See http://issues.civicrm.org/jira/browse/CRM-3536