[Plugin: WPBook] Comments not importing

  • Resolved animeout

    (@animeout)


    13 years, 11 months ago

    Hello

    I am using WPBook and installed it today to my WordPress 3.4 (selfhosted)

    Everything seems to work right now except any and all comments features.

    The WPBook isnt importing any comments at all.

    Here is the debug file

    2012-06-18 20:07:16 : Cron Running
2012-06-18 20:07:16 : Access token is AAAExxIawsWgBAHnUZCZBNfaUcwntC3ypqIvhUmbAXqqMXhEvePfztNdWXUDGWvFvSK1MLvrD18cahTazZB91wfvUKxoWRoDCnjUZCUSGrxKkFY4ZAFfKX
2012-06-18 20:07:19 : Getting posts, SQL was Select ID FROM wp_posts WHERE post_date BETWEEN '2012-06-15 20:07:19' AND '2012-06-18 20:07:19'
2012-06-18 20:07:19 : How many posts to consider? 26
2012-06-18 20:15:06 : Cron Running
2012-06-18 20:15:06 : Access token is AAAExxIawsWgBAHnUZCZBNfaUcwntC3ypqIvhUmbAXqqMXhEvePfztNdWXUDGWvFvSK1MLvrD18cahTazZB91wfvUKxoWRoDCnjUZCUSGrxKkFY4ZAFfKX
2012-06-18 20:15:06 : Getting posts, SQL was Select ID FROM wp_posts WHERE post_date BETWEEN '2012-06-15 20:15:06' AND '2012-06-18 20:15:06'
2012-06-18 20:15:06 : How many posts to consider? 26
2012-06-18 20:15:29 : Cron Running
2012-06-18 20:15:29 : Access token is AAAExxIawsWgBAHnUZCZBNfaUcwntC3ypqIvhUmbAXqqMXhEvePfztNdWXUDGWvFvSK1MLvrD18cahTazZB91wfvUKxoWRoDCnjUZCUSGrxKkFY4ZAFfKX
2012-06-18 20:15:32 : Getting posts, SQL was Select ID FROM wp_posts WHERE post_date BETWEEN '2012-06-15 20:15:32' AND '2012-06-18 20:15:32'
2012-06-18 20:15:32 : How many posts to consider? 26
2012-06-18 20:17:03 : Cron Running
2012-06-18 20:17:03 : Access token is AAAExxIawsWgBAHnUZCZBNfaUcwntC3ypqIvhUmbAXqqMXhEvePfztNdWXUDGWvFvSK1MLvrD18cahTazZB91wfvUKxoWRoDCnjUZCUSGrxKkFY4ZAFfKX
2012-06-18 20:17:04 : Getting posts, SQL was Select ID FROM wp_posts WHERE post_date BETWEEN '2012-06-15 20:17:04' AND '2012-06-18 20:17:04'
2012-06-18 20:17:04 : How many posts to consider? 26


    Also in my error_log of wordpress, I have these errors of same thing again and again whenever WPBook or cron of WPBook runs

    [18-Jun-2012 20:55:52 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query SELECT ID, post_title, post_excerpt FROM wp_posts  WHERE post_status = 'publish' AND post_type = 'post' AND post_password ='' AND post_date_gmt < '2012-06-18 20:55:52'   ORDER BY post_date DESC LIMIT 0,  made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/wpbook/theme/index.php'), wp_recent_posts
[18-Jun-2012 20:57:39 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query SELECT ID, post_title, post_excerpt FROM wp_posts  WHERE post_status = 'publish' AND post_type = 'post' AND post_password ='' AND post_date_gmt < '2012-06-18 20:57:39'   ORDER BY post_date DESC LIMIT 0,  made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/wpbook/theme/index.php'), wp_recent_posts

    My Details :-

    FB App – http://apps.facebook.com/indiaanimeclub/
    FB Group I am testing it in – http://www.facebook.com/groups/172667812789195/
    My Blog URL – http://blog.indiaanimeclub.com/

    I have also tried and used CORECONTROL to run the cron manually to test the comments but it simply didnt worked.

    Configuration/settings of plugin I think are correct
    Facebook Permissions are as follows :-

    read_stream – yes
    publish_stream – yes
    manage_pages – yes
    user_groups – yes

    Awaiting some guidance

    Thanks

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

Viewing 1 replies (of 1 total)
  • Plugin Author John Eckman

    (@johneckman)

    13 years, 10 months ago

    Hmm. That’s a new one to me.

    The SQL error seems to be referring to the ‘recent posts’ function, not the import comments routine.

    The access token does seem to be a short-lived on, expired at 1340053200 (Mon, 18 Jun 2012 21:00:00 GMT) – depending on your timezone it may have already been expired?

    It looks like the cron import fails immediately after the How Many Posts to Consider line – about line 153 in wpbook_cron.

    But that isn’t happening because it found no metaposts to consider or we would expect to see “No posts to examine” as the next line in the debug file.

    The next line after “how many posts to consider” in the debug *should* be “How many meta_posts found?”

    Does your post_meta table contain entries which have a meta_key that looks like “_wpbook_page_stream_id” or “_wpbook_profile_stream_id”?

    It almost looks the the running script just runs out of memory – is there anything in the php error log corresponding to when cron ran?

Viewing 1 replies (of 1 total)

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