Issues with comment importing

JK
(@justin_k)

13 years ago

Now that the basics of pushing posts to Facebook seem to be mostly working, I’m finally trying to re-enable comment processing. Unfortunately, I’m hitting many problems in this regard as well… :/

First, after enabling the option (to pull comments), the next time I visited the Wordbooker settings page it took over 5 minutes to execute (server time, not slow internet connection). During this time my whole site was locked up, until the server ultimately killed the process. This only happened once so far, hasn’t happened again.

Next, I set “Process Comments” to every 15 minutes. I waited 15 minutes, periodically checking the panel and watching it count down. When it reached 0, rather than resetting the “Next Scheduled Fetch is in” to 15m, it wrapped to 24h: http://screencast.com/t/uER4fDlEsKCd

Finally – it never imported the expected comments. I verified that the post (which had been pushed by wordbooker) had its “pull comments from facebook for this post” checkbox checked, but the comments never came through (at the time that the “next scheduled fetch” wrapped from 0 back to 24). Some logs: http://screencast.com/t/lWmiRRab7Rs

http://wordpress.org/extend/plugins/wordbooker/

Viewing 11 replies - 1 through 11 (of 11 total)

Plugin Author Steve
(@steveatty)

13 years ago

The comments aren’t pulled when you visit the admin page so I’ve no idea why it did that. Comments are pulled on a cron schedule so it should happen in the back ground.

Sometimes it shows 24 when it means zero (i.e. its currently running). Not sure why getting the next execution time from the WP cron controls shows that.

You should get some comment diagnostics for each comment run – you’ve included one showing that its found posts to check but not what its actually doing with them.

How long do you keep posts open for comments? Wordbooker will use that window by default but in reality FB posts don’t usually get comments on them after a couple of weeks at most.

Thread Starter JK
(@justin_k)

13 years ago

>>The comments aren’t pulled when you visit the admin page so I’ve no idea why it did that. Comments are pulled on a cron schedule so it should happen in the back ground.

Dunno – but that’s what happened Maybe just a *ridiculously* coincidental server spike…

>>How long do you keep posts open for comments?

I never close them.

>>in reality FB posts don’t usually get comments on them after a couple of weeks at most.

I was testing a post that’d been pushed to FB about 3 hours earlier, and had been commented on (on FB) about 10 minutes earlier. So it’s definitely not an issue of oldness, if that’s what you’re getting at.

>>You should get some comment diagnostics for each comment run – you’ve included one showing that its found posts to check but not what its actually doing with them.

That was the end of the log. It just ran again a minute ago, here’s all the logs produced by the event:

**************

Comment Processing (User Diag) 2013-04-30 01:15:26 Blog posts with FB Posts against them : Select distinct fb_post_id from jk_wordbooker_postcomments where fb_comment_id is null and user_id=1 and blog_id=1 and in_out is null 42 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –
Comment Processing (User Diag) 2013-04-30 01:15:28 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’215851691826634_263412937070509′ 1 –

Plugin Author Steve
(@steveatty)

13 years ago

That looks like its stuck in a loop – or those 42 posts are the same one which shouldn’t happen.

I’m off to work so will try to look at it tonight.

Thread Starter JK
(@justin_k)

13 years ago

k

Plugin Author Steve
(@steveatty)

13 years ago

Actually its not a loop – its simply telling you that the post had a pile of comments to run against.

Can you turn the diagnostic level up to show everything?

Thread Starter JK
(@justin_k)

13 years ago

Can I email it somewhere? It’s ginormous.

Note that I did have it set on show everythign except cache diagnostics anyway.

Plugin Author Steve
(@steveatty)

13 years ago

wordbooker @ tty.org.uk will work. The problem is that I can’t see why this is happening – messages are missing which implies things aren’t happening when they should. Trying to troubleshoot this sort of problem is one of the reasons I’m still seriously thinking of abandoning the plugin and walking away from it.

Thread Starter JK
(@justin_k)

13 years ago

Sent

Plugin Author Steve
(@steveatty)

13 years ago

The odd thing is that that set of diagnostics looks OK… the in/out counts are zero (for some reason) but this:

Comment Processing (User Diag) 2013-05-02 10:15:43 Starting comment handling for FB post 3309143_10101563885198354 –
Comment Processing (User Diag) 2013-05-02 10:15:44 Comments pulled from Facebook 1 –
Comment Processing (User Diag) 2013-05-02 10:15:44 Found new comment for FB post 3309143_10101563885198354 from : Nadia Shaikh –
Comment Processing (User Diag) 2013-05-02 10:15:44 Blogs posts to send comment to : select distinct wp_post_id from jk_wordbooker_postcomments where fb_post_id=’3309143_10101563885198354′ 1 –
Comment Processing (User Diag) 2013-05-02 10:15:44 Incoming comments disabled for WP post 24324

shows the comment was found on FB – Wordbooker found the post it belonged to in your blog but post 24324 seems to be closed to comment handling…. Did you check that the comment handling was set on the post itself? If you change comment handling the changes only take effect on new posts so if you turn it on then do something with an old post it wont pick up comments unless you explicitly set it on the old post.

Thread Starter JK
(@justin_k)

13 years ago

Yes, it’s enabled.

http://screencast.com/t/SHPsHgFl
Plugin Author Steve
(@steveatty)

13 years ago
Very odd… I have no clue what is going on without adding even more debugging.

Its failing on this:
```
if (!isset($wordbooker_post_options['wordbooker_comment_get'])) {
	wordbooker_debugger("Incoming comments disabled for WP post ".$wp_post_row->wp_post_id,' ',-3,9);
	continue ;
}
```

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Issues with comment importing’ is closed to new replies.