Author Topic: Problem upgrading from 3.2.3 to 3.4.8 (Read 565 times)

yvoalen · June 23, 2012, 05:47:19 am

DB Error: unknown error

Database Error Code: Error on rename of './fed_joomla/civicrm_contact' to './fed_joomla/#sql2-452f-f9' (errno: 152), 1025

ALTER TABLE civicrm_contact DROP FOREIGN KEY FK_civicrm_contact_mail_to_household_id

Already mentioned in http://forum.civicrm.org/index.php?topic=22988.0.

Tried this with 3.3.6 as well.
Joomla 1.5.25 and CiviCRM 3.2.3, works well, I have a valid backup, tried the upgrade several times, always the same error. Even with other db backups. Checked for FK, everything looks fine.

Donald Lobo · June 23, 2012, 07:25:16 am

1. Is there an FK with exactly the same name

2. If so, my next guess would be to write a query that checks the column mail_to_household_id and ensure they do point to valid contacts. You can just null that column since we dont use that column and drop it in that version or a future version

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Problem upgrading from 3.2.3 to 3.4.8 (Read 565 times)

yvoalen

Problem upgrading from 3.2.3 to 3.4.8

Donald Lobo

Re: Problem upgrading from 3.2.3 to 3.4.8