Hi Stéphane, My Jahia database runs on SQL Server. I am not sure how to translate the update statements in your script to something that SQL Server understands (I'm just a poor Oracle/Java developer who sort of ended up with SQL Server admin tasks on the side).
Do you perhaps have a version of this script in the SQL Server dialect? Thanks, Max. ________________________________________ From: Stéphane Croisier [mailto:[EMAIL PROTECTED] Sent: vrijdag 22 december 2006 12:34 To: install_list@jahia.org Subject: 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
