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;
