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
