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
