October 22, 2008 Comments Off on SeQueL
When migrating this blog from serendipity to wordpress, there was a cock-up in the migration module. The comments weren’t properly linked to the posts anymore. This might have been weird for the odd visitor visiting an older page.
Comments about the Quran were linked to my post about Schiphol-Rijk for example,… very strange. I knew there must be a solution with a single SQL statement in the database. And there was…
update wp_comments as wpc
set wpc.comment_post_ID =
select (wp_id from serendipity_entries where id = wpc.comment_post_id )
10 minutes research, 3 minutes writing, backup from wp_comments, check!
And that’s all it takes for the sequel of the upgrade… the final episode 😉