RE: JahiaPageNotFoundException's on 4.0.4 Upgrade

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