RE: Problem assigning rights to WebDav folder in Jahia 4.1 NOT JahiaPageNotFoundException's on 4.0.4 Upgrade

Still the same NPE or another one?

At 13:21 25.01.2007, you wrote:

>It's been a while since my last post (I have been kept busy), but
>unfortunately, trying to use a file from a public WebDav folder on my
>Jahia 4.1.1 server still causes exceptions.
>
>Running the SQL scripted posted by Stephane on the database (we use SQL
>Server BTW - see my other post for my translation of the script to MSSQL
>dialect) did not solve the issue.
>
>So.... what am I to try next?
>
>Max.
>
>
> > -----Original Message-----
> > From: Hirschfeld, Max [mailto:[email protected]]
> > Sent: vrijdag 22 december 2006 17:25
> > To: [email protected]
> > Subject: RE: Problem assigning rights to WebDav folder in Jahia 4.1
>NOT
> > JahiaPageNotFoundException's on 4.0.4 Upgrade
> >
> > BTW, below is my attempt to make a SQL server equivalent of the script
> > to fix the problem with the WebDav rights. I am not sure if it is
>right
> > (please advise):
> >
> > use jahia41dev
> >
> > select distinct object_id into tmp_sl2_all from
> > jahia_sl2_permissions,jahia_sl2_uri where subject_id=uri_id and
> > uri_string='all';
> >
> > select distinct object_id into tmp_sl2_authenticated from
> > jahia_sl2_permissions,jahia_sl2_uri where subject_id=uri_id and
> > uri_string='authenticated';
> >
> > select distinct object_id into tmp_sl2_unauthenticated from
> > jahia_sl2_permissions,jahia_sl2_uri where subject_id=uri_id and
> > uri_string='unauthenticated';
> >
> > delete jahia_sl2_permissions from jahia_sl2_permissions, jahia_sl2_uri
> > where subject_id=uri_id and uri_string='nobody' and object_id in
>(select
> > object_id from tmp_sl2_all);
> >
> > delete jahia_sl2_permissions from jahia_sl2_permissions, jahia_sl2_uri
> > where subject_id=uri_id and uri_string='user' and object_id in (select
> > object_id from tmp_sl2_authenticated);
> >
> > delete jahia_sl2_permissions from jahia_sl2_permissions, jahia_sl2_uri
> > where subject_id=uri_id and uri_string='guest' and object_id in
>(select
> > object_id from tmp_sl2_unauthenticated);
> >
> > update jahia_sl2_permissions
> > set subject_id = u1.uri_id
> > from jahia_sl2_permissions p, jahia_sl2_uri u1 , jahia_sl2_uri u2
> > where p.subject_id =u2.uri_id
> > and u1.uri_string  ='all'
> > and u2.uri_string  ='nobody'
> > and u1.namespace   =u2.namespace;
> >
> >
> > update jahia_sl2_permissions
> > set subject_id=u1.uri_id
> > from jahia_sl2_permissions p, jahia_sl2_uri u1 , jahia_sl2_uri u2
> > where p.subject_id=u2.uri_id
> > and u1.uri_string   = 'authenticated'
> > and u2.uri_string   = 'user'
> > and u1.namespace    = u2.namespace
> >
> > update jahia_sl2_permissions
> > set subject_id = u1.uri_id
> > from jahia_sl2_permissions p, jahia_sl2_uri u1 , jahia_sl2_uri u2
> > where p.subject_id=u2.uri_id
> > and u1.uri_string='unauthenticated'
> > and u2.uri_string='guest'
> > and u1.namespace=u2.namespace;
> >
> > drop table tmp_sl2_all;
> >
> > drop table tmp_sl2_authenticated;
> >
> > drop table tmp_sl2_unauthenticated;
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.410 / Virus Database: 268.17.10/651 - Release Date: 24.01.2007

- -- --- -----=[ scroisier at jahia dot com ]=---- --- -- -
Head of Products - Jahia Ltd, Route des Jeunes 9, 1227 Carouge (Switzerland)
Jahia : The Java Unified Web Platform
www.jahia.org - The Product Web Site
www.jahia.net - The Community Web Site
www.jahia.com - The Commercial Services Company 


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.17.11/652 - Release Date: 25.01.2007