Dave wrote:To unconfigure a "broken" portlet try this; Log on as a different user (one who the portlet is OK for), go to the portlet that is broken for the other user and select "Configure". Then grab that URL from the browser. Now log on as your "broken" user, and paste the URL into the browser. You should then be in the "Configure" screen. Go to General and select "Restore Defaults".
select id , name , is_default
where user_id = ( select user_id from srm_resources where unique_name = '<<resource id here>>' )
and view_code = ( select cast(id as char) from cmn_portlets where portlet_code = '<<portlet id here>>' )
order by id desc