WordPress.org

Ready to get started?Download WordPress

Forums

WPBook Lite
[resolved] Comments not importing (8 posts)

  1. GNaschenweng
    Member
    Posted 2 years 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/

  2. johneckman
    Member
    Plugin Author

    Posted 2 years 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

  3. johneckman
    Member
    Plugin Author

    Posted 2 years 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

  4. GNaschenweng
    Member
    Posted 2 years 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?

  5. johneckman
    Member
    Plugin Author

    Posted 2 years 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.

  6. markandrewkato
    Member
    Posted 2 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

  7. johneckman
    Member
    Plugin Author

    Posted 2 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?

  8. markandrewkato
    Member
    Posted 2 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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic