Thanks jiri. I tried many things when I got the 500 error occurring for no obvious reason. What worked was changing the permissions of about 1/2 my site (I got nervous about security half way through and stopped the process). Cheers.
Glad I found this thread because all the documentation and various tutorials I read about moving blogs didn’t mention this issue. I had to move a blog to a local server (that was for display and didn’t have an internet connection).
I eventually found the SQL query I needed to run was
UPDATE wp_posts set post_content=REPLACE(post_content, 'www.mydomain.co.uk/', 'localhost/mylocaldomain_directory/')
Hope that might help others.
So glad I found your answer productetc… have spent hours nutting around this question. Deactivated Adhesive plugin and now all is well.
The prov/next still work with AStickyPostOrderER
