CiviCRM Community Forums (archive)

Hi this is following on from http://forum.civicrm.org/index.php/topic,3849.0.html

I've run all the sql upgrade scripts on my database.
I create the new empty dbase from civicrm_41.mysql.
Then strike all sorts of problems when trying to import data:-

First error

#1452 - Cannot add or update a child row: a foreign key constraint fails (`19newjul16/civicrm_acl`, CONSTRAINT `FK_civicrm_acl_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))

So I remove the whole "INSERT INTO `civicrm_acl` " section and try again

It gets a bit further - next error is when inserting into civicrm_activity

#1054 - Unknown column 'source_record_id' in 'field list'

And there's a little red blob with a white cross next to a particular record - does that mean it's just that record that's problematic, or is this a schema issue?

I am so struggling here - all help appreciated
cheers
Lesley

I am following the instructions on:

http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.0

I am running into a similar issue when trying to do the "ensure database integrity" step.

I am getting the error "Unknown column 'domain_id' in 'field list'"

It looks like my previous version of civicrm used the "domain ID" field in a whole bunch of places, whereas the new schema does not use it.

So there are two ways I could fix this as far as i can see:

1) edit the mysql file i'm importing and remove all references to "domain_id"
2) add extra field "domain_id" to various tables in the new system (I would assume that extra fields will just sit there and be ignored by the new civicrm system)

Any recommendations on which one I should try?   Is there a replacement for "domain_id" that I should be looking out for to make sure it is properly filled in???

Cheers,

Patrick