Forum LAMS for Tech-Heads - General Forum: Re: A stupid, stupid mistake

By: Matthew Topp

[ Reply | Forward ]

Thanks Ernie, I tried it, but...

I get this error:

Cannot add or update a child row: a foreign key constraint fails (`lams2/lams_user_organisation_role`, CONSTRAINT `FK_lams_user_organisation_role_3` FOREIGN KEY (`user_organisation_id`) REFERENCES `lams_user_organisation` (`user_organisation_id`) ON DELETE N)

Any ideas?

Matt.

Posted by Matthew Topp

By: Jun-Dir Liew

[ Reply | Forward ]

You need to fulfill the constraint before running that script.  Do this first:

insert into lams_user_organisation (organisation_id, user_id) values (1,1);

then do:

select user_organisation_id from lams_user_organisation where organisation_id=1 and user_id=1;

you'll get a number back.  in the following script replace <the number> with this number.

insert into lams_user_organisation_role (user_organisation_id, role_id) values (<the number>, 1);

then restart lams.  if you run these 3 commands, don't run Ernie's one.  also, insert usual warning here about modifying data, make sure you have backups, etc.

Posted by Jun-Dir Liew