Error importing from blogger (blogspot) to WordPress

Today I created a fresh WordPress blog and tried to import an existing blog from blogger (blogspot). Everything worked is it should and all posts were converted, however all of the imported posts got extra characters in them that wasn’t in the original blog. The post title and the post content all got an ’>’ in them in the first position. Like: ”>This a a post title” amd ”>This is the content”.

To clean this up you can run the following sql-commands against the wordpress database:

update wp_posts SET post_title = TRIM(LEADING '>' FROM post_title)   WHERE post_title LIKE '>%'
update wp_posts SET post_content = TRIM(LEADING '>' FROM post_content)  WHERE post_content LIKE '>%'

Lämna ett svar

Din e-postadress kommer inte publiceras. Obligatoriska fält är märkta *

Denna webbplats använder Akismet för att minska skräppost. Lär dig hur din kommentardata bearbetas.