Plugin Author
Steve
(@steveatty)
If you turn diagnostics up to “Show Everything” you should see stuff displayed – you might need to check that if you’re a multi user blog that you are logged in as the user who is set to get diagnostic messages.
Ah thank you.
Now I see lots of stuff when I click comment handling.
Can you see what is going wrong? There are two posts which made their way to Facebook this week, one of these posts has four Facebook comments, but they do not reach my WordPress.
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Comment handling starting -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Processing comments for Martin Sebald -
Comment Processing (User Diag) 2012-03-10 13:56:04 Processing your comments -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Starting Incoming comment handling -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Blog posts with FB Posts against them : Select distinct fb_post_id from wp_wordbooker_postcomments where fb_comment_id is null and user_id=1 and blog_id=1 and in_out is null 1 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Starting comment handling for FB post 1521801696_3382525611551 -
Comment Processing (User Diag) 2012-03-10 13:56:04 Starting comment handling for FB post 1521801696_3382525611551 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Comments pulled from Facebook 0 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Finished comment handling for FB post 1521801696_3382525611551 -
Comment Processing (User Diag) 2012-03-10 13:56:04 Finished comment handling for FB post 1521801696_3382525611551 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Incoming comment handling completed -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Starting Outgoing comment handling -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Auto close comments 14 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Blog posts for comment handling : select distinct wp_post_id,fb_post_id from wp_wordbooker_postcomments where fb_comment_id is null and blog_id=1 and user_id=1 and in_out is null 1 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Starting comment handling for WP post 2202 1521801696_3382525611551 -
Comment Processing (User Diag) 2012-03-10 13:56:04 Starting comment handling for WP post 2202 1521801696_3382525611551 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Comments for processing : select comment_ID from wp_comments where comment_post_id=2202 and comment_approved=1 and comment_id not in (select wp_comment_id from wp_wordbooker_postcomments where wp_post_id=2202 and fb_post_id='1521801696_3382525611551' and user_id=1) and comment_post_id in (select ID from wp_posts WHERE comment_status='open') 0 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Finished comment handling for WP post 2202 1521801696_3382525611551 -
Comment Processing (User Diag) 2012-03-10 13:56:04 Finished comment handling for WP post 2202 1521801696_3382525611551 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Outgoing comment handling completed -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Completed comment processing for Martin Sebald In : 0 - Out : 0 -
Comment Processing (User Diag) 2012-03-10 13:56:04 Completed your comment processing In : 0 - Out : 0 -
Comment Processing (Admin Diag) 2012-03-10 13:56:04 Comment handling completed -
Plugin Author
Steve
(@steveatty)
Well the diagnostics show one post that it thinks it should be checking for comments on :
WP post 2202 FB post: 1521801696_3382525611551
Is that the post that it should be finding?
Well, no… Since installing Wordbooker, I posted three new posts. One of these (the first I posted since) is 2202.
The second and third were posted via Postie (wich grabs emails and posts them in the blog), the first was posted “normally” through the backend of WP.
I never changed the settings of Wordbooker after installing it, so every post should have the same settings.
Maybe a problem because of Postie? If yes, a Postie or Wordbooker issue?
How can I setup comments processing, even through editing the database directly? (I did edit the Postie posts to add categories and tags and did not see any other settings in the Wordbooker section though…)
Ok I found the difference.
The Postie posts have user_id 0 in the table wp_wordbooker_postcomments instead of “my” user_id 1 like the 2202 post which was normally posted through the backend of WP.
I changed from 0 to 1 and started the comments processing and here they are, all my Facebook comments.
Bug of Wordbooker or Postie?
BTW: Next to the three posts with the post id I was able to identify in this table are a lot of post id 0 rows. What are these for?
Plugin Author
Steve
(@steveatty)
Its probably because Postie isn’t populating the user_id properly, I don’t use it so I can’t comment on exactly what the problem is.
Those rows with post_id of 0 should have an in_out value of “stat” – its part of some stats work that I was implementing but its not complete yet.
Hm, well, I will open a thread for Postie then and link this thread there. Maybe you two developers can work something out.
The thing is that when posting via mobile phone for example, everything should work automaticly without doing manual work to the database for example – as the poster is not at home / at work in front of a computer.
About the rows with post_id 0: Thank you for the information, then I’m just ignoring these rows. 😉
Plugin Author
Steve
(@steveatty)
Seeing a trace from a post made via Postie might help work out why its getting a 0 value for the author but I’m confused because it looks like the posts are going to facebook which would imply that its found the right user ID somewhere along the line.
Plugin Author
Steve
(@steveatty)
And I think I’ve found it – its using the global user_ID variable which I guess isn’t set when postie is running.
Ah, great! And is it something you can fix in Wordbooker or is it a Postie thing where you cannot do anything about it?
Plugin Author
Steve
(@steveatty)
Downloaded, installed. Will try in the evening and get back to you. Thank you! 🙂
Great, it looks like Postie posts get a real user_id in the wp_wordbooker_postcomments table now, too. 🙂
I did not receive any comments on Facebook, yet, but I’m pretty sure that comments processing will work.
As soon as there are comments, I’ll be back here for 100% confirmation.
Thank you very much already! 🙂
