[Plugin: WPBook Lite] Comments not importing

Resolved GNaschenweng
(@gnaschenweng)

12 years, 3 months ago

Running WPBook Lite and FB comments are not importing:

2012-01-08 12:29:04 : Cron Running
2012-01-08 12:29:04 : Access token is AAAE0JLVa0OYBANyaXbYIk1qxx9mxbHuoreqJGRyKn3SfMOvupwDtGwlLYUNr7bOZAS4PzRcEefPE7ZAbrnXlaJIMmkWmIZD
2012-01-08 12:29:04 : Getting posts, SQL was Select ID FROM blog_posts WHERE post_date BETWEEN ‘2012-01-04 12:29:04’ AND ‘2012-01-08 12:29:04’
2012-01-08 12:29:04 : How many posts to consider? 118
2012-01-08 12:29:04 : How many meta_posts found? 2
2012-01-08 12:29:04 : Examining a meta_post, post ID is 1293, meta key = _wpbook_page_stream_id
2012-01-08 12:29:04 : FBcomments, fbsql is SELECT time,text,fromid,xid,post_id FROM comment WHERE post_id=’246953252044167_247081402031352′ AND time > ‘0’ ORDER BY time ASC
2012-01-08 12:29:04 : FBcommentslist is 1
2012-01-08 12:29:04 : Number of comments for this post- 0
2012-01-08 12:29:04 : Examining a meta_post, post ID is 1293, meta key = _wpbook_page_stream_time
2012-01-08 12:29:04 : Skipping meta key _wpbook_page_stream_time
2012-01-08 12:29:04 : How many meta_posts found? 2
2012-01-08 12:29:04 : Examining a meta_post, post ID is 1207, meta key = _wpbook_page_stream_id
2012-01-08 12:29:04 : FBcomments, fbsql is SELECT time,text,fromid,xid,post_id FROM comment WHERE post_id=’246953252044167_247494668656692′ AND time > ‘1326008816’ ORDER BY time ASC
2012-01-08 12:29:04 : FBcommentslist is 1
2012-01-08 12:29:04 : Number of comments for this post- 0
2012-01-08 12:29:04 : Examining a meta_post, post ID is 1207, meta key = _wpbook_page_stream_time
2012-01-08 12:29:04 : Skipping meta key _wpbook_page_stream_time
2012-01-08 12:29:04 : How many meta_posts found? 2
2012-01-08 12:29:04 : Examining a meta_post, post ID is 1319, meta key = _wpbook_page_stream_id
2012-01-08 12:29:04 : FBcomments, fbsql is SELECT time,text,fromid,xid,post_id FROM comment WHERE post_id=’246953252044167_247068155366010′ AND time > ‘0’ ORDER BY time ASC
2012-01-08 12:29:05 : FBcommentslist is 1
2012-01-08 12:29:05 : Number of comments for this post- 0
2012-01-08 12:29:05 : Examining a meta_post, post ID is 1319, meta key = _wpbook_page_stream_time
2012-01-08 12:29:05 : Skipping meta key _wpbook_page_stream_time

http://wordpress.org/extend/plugins/wpbook-lite/

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

Plugin Author John Eckman
(@johneckman)

12 years, 3 months ago

Hmm. Not sure what’s happening here.

These two lines are the critical ones, repeated in couple of places in the debug output:

2012-01-08 12:29:05 : FBcommentslist is 1
2012-01-08 12:29:05 : Number of comments for this post- 0

The first line comes from line 201 of wpbook_lite_cron.php, where the results of an FQL query using the Facebook API are retrieved and assigned to an array, which is meant to be printed out to the debug file but instead we just get “1.”

The second line comes from line 210 of the same file, where the count of comments in that array is output.

So somehow WPBook Lite is getting a response it doesn’t properly interpret from the FB API.

Will be looking into this

Plugin Author John Eckman
(@johneckman)

12 years, 3 months ago

@gnaschenweng are you comfortable changing php files?

If you could change line 201 of wpbook_lite_cron.php from:

$debug_string=date("Y-m-d H:i:s",time())." : FBcommentslist is ". print_r($fbcommentslist) . "\n";

To:

$debug_string=date("Y-m-d H:i:s",time())." : FBcommentslist is ". print_r($fbcommentslist,true) . "\n";

That should help us get better data back into the debug file from the FQL query

Thread Starter GNaschenweng
(@gnaschenweng)

12 years, 3 months ago

Hi there – after some time I did notice a few comments coming in and I think the problem is resolved.

One question though: I am using Disqus and although the FB comments are displayed in the WP commenting system, they don’t seem to import/sync into Disqus. Does WPBook_Lite do anything different to regular comments causing this?

Plugin Author John Eckman
(@johneckman)

12 years, 3 months ago

@gnaschenweng – glad to hear some comments did make it in.

Not sure how DISQUS integrates – but WPBook Lite saves comments directly into the WP Database – depending on where/how DISQUS is hooking the comments system that could be a problem.

Mark
(@markandrewkato)

12 years ago

Hi,

Same thing here, no comments are importing. Here’s the debug file.

2012-04-09 01:56:02 : Number of comments for this post- 0
2012-04-09 01:56:02 : Examining a meta_post, post ID is 529, meta key = _wpbook_group_stream_time
2012-04-09 01:56:02 : Skipping meta key _wpbook_group_stream_time
2012-04-09 02:19:35 : Cron Running
2012-04-09 02:19:35 : Access token is AAAEkbV4LZAHIBAP784ApBZCAjqe8YwGqkiUCmAnIEmSDEooVuJzWesnzhK0rCCRDnfG94D1cWQ4K823WO5zCUo0GMtGC6HJZAyFYlrtZAwZDZD
2012-04-09 02:19:35 : Getting posts, SQL was Select ID FROM wp_posts WHERE post_date BETWEEN ‘2012-03-30 02:19:35’ AND ‘2012-04-09 02:19:35’
2012-04-09 02:19:35 : How many posts to consider? 18
2012-04-09 02:19:35 : How many meta_posts found? 2
2012-04-09 02:19:35 : Examining a meta_post, post ID is 526, meta key = _wpbook_group_stream_time
2012-04-09 02:19:35 : Skipping meta key _wpbook_group_stream_time
2012-04-09 02:19:35 : Examining a meta_post, post ID is 526, meta key = _wpbook_group_stream_id
2012-04-09 02:19:35 : FBcomments, fbsql is SELECT time,text,fromid,xid,post_id FROM comment WHERE post_id=’286963812356_10150728514362357′ AND time > ‘0’ ORDER BY time ASC
2012-04-09 02:19:36 : FBcommentslist is Array
(
)

2012-04-09 02:19:36 : Number of comments for this post- 0
2012-04-09 02:19:36 : How many meta_posts found? 2
2012-04-09 02:19:36 : Examining a meta_post, post ID is 529, meta key = _wpbook_group_stream_id
2012-04-09 02:19:36 : FBcomments, fbsql is SELECT time,text,fromid,xid,post_id FROM comment WHERE post_id=’286963812356_10150728624022357′ AND time > ‘0’ ORDER BY time ASC
2012-04-09 02:19:37 : FBcommentslist is Array
(
)

2012-04-09 02:19:37 : Number of comments for this post- 0
2012-04-09 02:19:37 : Examining a meta_post, post ID is 529, meta key = _wpbook_group_stream_time
2012-04-09 02:19:37 : Skipping meta key _wpbook_group_stream_time

First, I added a new post in wordpress. It was successfully sent in facebook groups. Next, when I put a comment on the post IN facebook, the comments IN facebook are not imported into wordpress. Any help?

Thanks.

Mark

Plugin Author John Eckman
(@johneckman)

12 years ago

What is the privacy setting for your group?

Looks like it is getting an empty response to the FBSQL query where it tries to find comments on a post.

Can you find the ID of a post you know has comments, and look to see if those are ever mentioned in the log?

How long after you put the comment on the post in Facebook did you look for it in WordPress? Was that debug above created after you commented on the post?

Mark
(@markandrewkato)

12 years ago

I am very sorry John. It seems to be working now. It just takes too long for it to import the comment.

Last question, if I post to facebook, will it import on wordpress automatically? Or just wordpress to facebook? Same for comments.

Thank you very much John.

Mark

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

The topic ‘[Plugin: WPBook Lite] Comments not importing’ is closed to new replies.