I recently tried the 5.4 upgrade (failed due to a sql problem) so restored to the previous days backup (both sql and the entire home directory [partial restore didnt work either]).

The site works, however, I cannot access sitemap nor add any new pages. The sitemap gives an error "page not found at that address" whilst trying to add page goes ok, till you select the page type and it just doesnt "click".

Is there something else I should be aware of when restoring a backup?

I've cleared cache both for the site and locally.