On Friday 21 December 2001 19:43, you wrote:
> I am under fire to upgrade a midgard site form 1.2.5 to 1.4.2. Here are the
> instructions as I was told..
>
> 1) Copy the old database over
> 2) run database_upgrade script
> 3) run repligard to repair missing guids
>
>
> The site works.. we are able to add new stories to the site.. the problem
> is that no other users can login except for the admin.
My guess is you've enabled sitegroups. When copying over a 1.2.5 database and
running database-upgrade, everything will be in SG0, and only a person with
root rights ('admin') can log in.
> Also, when I try to
> make changes to groups they do not work. I.e. I can create a new user, but
> I am unable to add them to a group. In one case I removed all users from a
> group, and I am now unable to add anyone back to the group..
You'll have to move everything into a new sitegroup. The attached script will
do this when ran against your database. The entire database will be moved to
sg1. The other option is to compile midgard without sitegroups, in which case
everything should work as before without changes.
Emile
UPDATE article SET sitegroup=1;
UPDATE blobs SET sitegroup=1;
UPDATE element SET sitegroup=1;
UPDATE event SET sitegroup=1;
UPDATE eventmember SET sitegroup=1;
UPDATE file SET sitegroup=1;
UPDATE grp SET sitegroup=1;
UPDATE host SET sitegroup=1;
UPDATE image SET sitegroup=1;
UPDATE member SET sitegroup=1 WHERE gid<>0;
UPDATE page SET sitegroup=1;
UPDATE pageelement SET sitegroup=1;
UPDATE pagelink SET sitegroup=1;
UPDATE person SET sitegroup=1 WHERE id<>0;
UPDATE preference SET sitegroup=1;
UPDATE record_extension SET sitegroup=1;
UPDATE snippet SET sitegroup=1;
UPDATE snippetdir SET sitegroup=1;
UPDATE style SET sitegroup=1;
UPDATE topic SET sitegroup=1;
INSERT INTO sitegroup (id,name,realm,admingroup,sitegroup) VALUES (1,'sg1', 'sg1',0,0);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
