mozilla/zamboni — comment on commit a1a2345cf85127e95347e183065506242c6ed898
File:  line 0
By robhudson:

It might be a different name on the foreign key constraint. Check the "show create table" and if it differs I guess alter it? This was tough because remora differed from landfill and what django created. So I opted for what is on the server.

On Nov 11, 2011, at 7:05 PM, Kumar McMillan wrote:

> ugh, mysql is annoying. I get this cryptic error (haven't narrowed it down yet):
>
> ALTER TABLE `applications_versions` ADD CONSTRAINT `applications_versions_ibfk_4` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`) ON DELETE CASCADE
> Foreign key constraint fails for table `zamboni`.:
> ,
> CONSTRAINT `applications_versions_ibfk_4` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`) ON DELETE CASCADE
> Trying to add in child table, in index `version_id` tuple:
> DATA TUPLE: 2 fields;
> 0: len 4; hex 00000005; asc ;; 1: len 4; hex 00000001; asc ;;
>
> But in parent table `zamboni`.`versions`, in index `PRIMARY`,
> the closest match we can find is record:
> PHYSICAL RECORD: n_fields 15; compact format; info bits 0
>
> ---
> Reply to this email directly or view it on GitHub:
> https://github.com/mozilla/zamboni/commit/a1a2345cf85127e95347e183065506242c6ed898#commitcomment-712681