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

Oups sorry was destinated to the other question 
regarding WebDAV file access issues

At 12:30 22.12.2006, you wrote:

>Please try thoses SQL requests on your DB (please backup first and test after)
>
>
>
>create table tmp_sl2_all as select distinct object_id from
>jahia_sl2_permissions,jahia_sl2_uri where subject_id=uri_id and
>uri_string='all';
>create table tmp_sl2_authenticated as select distinct object_id from
>jahia_sl2_permissions,jahia_sl2_uri where subject_id=uri_id and
>uri_string='authenticated';
>create table tmp_sl2_unauthenticated as select distinct object_id 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 p, jahia_sl2_uri u1 , jahia_sl2_uri u2 set
>p.subject_id=u1.uri_id 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 p, jahia_sl2_uri u1 , jahia_sl2_uri u2 set
>p.subject_id=u1.uri_id 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 p, jahia_sl2_uri u1 , jahia_sl2_uri u2 set
>p.subject_id=u1.uri_id 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;
>
>Perhaps this will help solve your issue
>Stéphane
>
>At 19:38 21.12.2006, you wrote:
>
>>Anyone have any idea what could be causing these exceptions?
>>
>>Thanks,
>>Tim
>>
>>
>>
>>
>>--
>>No virus found in this incoming message.
>>Checked by AVG Free Edition.
>>Version: 7.1.409 / Virus Database: 268.15.26/594 - Release Date: 20.12.2006
>
>
>No virus found in this outgoing message.
>Checked by AVG Free Edition.
>Version: 7.1.409 / Virus Database: 268.15.26/597 - Release Date: 21.12.2006



No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.15.26/597 - Release Date: 21.12.2006