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

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