Comments attached to wrong posts from LiveJournal import
Hi there, I’m hoping someone can help me with a perplexing problem. I’ve got a LiveJournal blog (paulobrian.livejournal.com) I’m trying to import into WordPress at superverbose.wordpress.com. The importer brings in the posts brilliantly, but stumbles on the comments. It brings them all in, but frequently the first comment on a given post has been randomly attached to a different post altogether, turning both the comment and its replies into non sequiturs.
For instance, someone replied to a post called “Good Answers addendum”, but the importer attached the comment to a post called “The Office Season 3.” Subsequent “Good Answers addendum” comments are attached to the proper post. Interestingly, when I look at comments in the dashboard, they are properly threaded in chronological order — it’s just that some of them are on the wrong posts. I’ll also note that I recently did a different livejournal import (from dantewilson.livejournal.com to ballofgenius.wordpress.com) and that worked flawlessly, with none of this comment confusion.
I tried deleting all posts and re-importing from LJ, but had the same issue. Help?
The blog I need help with is superverbose.wordpress.com.
Not to worry. Staff will assist you and I have flagged this thread for their attention.
Sorry for the trouble, we’re looking into this!
Thanks so much for the super-quick response!
Any progress on this? If it helps, I’ve observed that all the comments that were imported onto the wrong entries were imported as “anonymous” — they look to be comments made on my LJ blog by people without LJ accounts.
It wouldn’t be terribly hard to fix manually if there were a way of reassigning a comment to a different entry, but I can’t seem to find such a mechanism on wordpress.com. Please let me know if I can help in any way. I’d be willing to produce a list of misassigned comments and where they should go, if someone was able to fix the issue on the back end.
Not yet, we’re still working on this. Sorry for the delay!
Good to know it’s still active. Thanks for the update!
@paulobrian, I’m sorry about the very long delay here. We’ve investigated the issue, but it turns out that we cannot reproduce it on our end. We could help you assign the comments to the proper posts if you could provide a list aligning them.
As for the list, what might be best would be a list of either numeric post IDs (available when hovering over the Edit link in the post listing screen) or post urls and, for each post, a list of comments that are misassigned and should be assigned to it. Ideally, the comment list would be a list of numeric comment IDs, but if that proves too onerous, we can certainly work with other uniquely identifying data (combination of date and first few words of the comment, for example).
If you remain willing to build such a list, you could save it as a draft among your posts and then reply here to let us know it’s there. We could then try to remap the posts for you. Thanks!
Thanks so much for circling back around on this! I really appreciate it, especially when I see the volume of help requests that comes into this forum. I will definitely do as you suggest: make up a list, save it as a draft on superverbose.wordpress.com, and post here to let you know it’s ready.
I am experiencing this exact problem. I’m trying to bring 11 years’ worth of LJ posts into WordPress. All the entries (about 1300 or so) are coming in, but many of the comments–about half of them, it seems–come in attached to the wrong posts. For example, most of the comments belonging to the last few months’ worth of posts are coming in attached to a post from 2008!
I’ve re-run the import multiple times and it continues to do this.
Comments that are attached to the wrong post are usually erroneously listed as being made by “anonymous.” Some of these posts are from people with LiveJournal accounts, some are not. (Some of them are even comments that I have posted!)
Some, but not all, of the comments that come in attached to the wrong posts end up “pending” rather than “approved”.
There is no rhyme or reason to the posts that the comments end up getting assigned to; they don’t get assigned to posts that are, for example, one or ten or a hundred posts away from the proper post. However, it is always consistent. If I delete the entire database and re-run the import 10 times, all 10 times the same comments will be attached to the wrong posts and they will be attached to the same posts.
Dates, times, and content of the comments always get imported correctly. Post authors, post numbers, and post thread numbers always get imported incorrectly.
There is no relationship between the correct post number of a comment that is imported incorrectly and the comment’s thread number (for example, I had thought that perhaps commets were getting assigned, say, to post 80632 if their parent comment number was 80632, but that does not seem to be the case).
I can give specific examples of the data being returned from LiveJournal and the data as WordPress importer sees it. In one example, a comment is coming in from LiveJournal with the following information:
But when the import plugin parses the comments, if I look in $matches in the part of the plugin that examines the XML of the comments, for some reason it’s coming back with
Everything else (the comment body and so on) is OK. I don’t know if there’s a subtle error in the regex (I suck at regex!) or if it’s not starting correctly at the header of this particular comment or what. When this comment is imported, it also ends up pending rather than approved.
Like I said, the failures are consistent. This particular comment ALWAYS ends up assigned to jitemid 238112.
Recent comments seem more prone to this problem than older comments. My blog has about 21,000 comments, about 1,000 of which end up attached to the wrong post and pending rather than approved, and another several thousand of which end up approved but still attached to the wrong post.
@franklinveaux what’s the URL of your blog? is it a WordPress.com blog or WordPress.org self-hosted blog?
It’s a WordPress.org self-hosted blog using WordPress 3.5. The WP blog is at blog.franklinveaux.com and the original LJ version is at tacit.livejournal.com.
Unfortunately we won’t be able to help you out since these are the forums for WordPress.com blogs. I recommend you post here instead:
Hello Happiness Engineers. Now it’s my turn to apologize for delay — I had a number of deadlines to hit recently. Anyway, as you requested, I’ve saved a draft post on superverbose.wordpress.com containing a list of posts and the comments that should correctly be associated with them. Thanks very much for your help!
Thanks. I’ve added your request back to our queue, and we’ll work on this some more as soon as we’re able.
The topic ‘Comments attached to wrong posts from LiveJournal import’ is closed to new replies.