Body: <p>I am migrating civicrm from version 4.2.9 to 5.16.0. While running the upgrade url 
  giving this error "ALTER TABLE civicrm_membership_type DROP FOREIGN KEY FK_civicrm_membership_autorenewal_msg_id [nativecode=1091 ** Can't DROP 'FK_civicrm_membership_autorenewal_msg_id'; check that column/key exists]". But I didn't find that consrtaints for that table.
  Please help me to get out of this.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-01T17:33:49.390Z
Comments.Text: I think this is the same as https://civicrm.stackexchange.com/a/26563/181. Try commenting out the 4 lines that it says in the 2nd paragraph there.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-03T04:39:40.030Z
Comments.Text: Yup thanks. I solved that problem while commenting four lines. but now I am getting another problem that "SELECT id, name FROM civicrm_contribution_type WHERE name IN ('Donation', 'Event Fee', 'Member Dues') AND is_active =1 [nativecode=1146 ** Table 'vvki_in_civicrm_1_4.2.9.civicrm_contribution_type' doesn't exist]". That "civicrm_contribution_type" table not exists in 4.2.9 database. Please help me for this too.
Comments.UserDisplayName: Prasad kanalli
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-03T04:45:21.403Z
Comments.Text: It sounds like you might have several issues that need ongoing help for upgrading such an old database. Consider contacting someone on the partners list: https://civicrm.org/partners-contributors
Comments.UserDisplayName: Demerit
Tags: <drupal>
Title: Civicrm Migration Giving Foreign Key consrtant error
ThreadText: # Civicrm Migration Giving Foreign Key consrtant error
  
  (Asked by: username_0 on 2019-10-01)
  
  I am migrating civicrm from version 4.2.9 to 5.16.0. While running the upgrade url
  giving this error "ALTER TABLE civicrm\_membership\_type DROP FOREIGN KEY FK\_civicrm\_membership\_autorenewal\_msg\_id [nativecode=1091 \*\* Can't DROP 'FK\_civicrm\_membership\_autorenewal\_msg\_id'; check that column/key exists]". But I didn't find that consrtaints for that table.
  Please help me to get out of this.
  
  **Tags:** drupal
  
  > **Comments:**
  > **username_1**: I think this is the same as https://civicrm.stackexchange.com/a/26563/181. Try commenting out the 4 lines that it says in the 2nd paragraph there.  
  > **username_0**: Yup thanks. I solved that problem while commenting four lines. but now I am getting another problem that "SELECT id, name FROM civicrm_contribution_type WHERE name IN ('Donation', 'Event Fee', 'Member Dues') AND is_active =1 [nativecode=1146 ** Table 'vvki_in_civicrm_1_4.2.9.civicrm_contribution_type' doesn't exist]". That "civicrm_contribution_type" table not exists in 4.2.9 database. Please help me for this too.  
  > **username_1**: It sounds like you might have several issues that need ongoing help for upgrading such an old database. Consider contacting someone on the partners list: https://civicrm.org/partners-contributors  
  
  ---
  
  ## 0 answers
  
  