Title: [Plugin: WPBook] Comments not importing
Last modified: August 20, 2016

---

# [Plugin: WPBook] Comments not importing

 *  Resolved [animeout](https://wordpress.org/support/users/animeout/)
 * (@animeout)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wpbook-comments-not-importing/)
 * 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/](http://apps.facebook.com/indiaanimeclub/)
   
   FB Group I am testing it in – [http://www.facebook.com/groups/172667812789195/](http://www.facebook.com/groups/172667812789195/)
   My Blog URL – [http://blog.indiaanimeclub.com/](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/](http://wordpress.org/extend/plugins/wpbook/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [John Eckman](https://wordpress.org/support/users/johneckman/)
 * (@johneckman)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/plugin-wpbook-comments-not-importing/#post-2828573)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wpbook_eeeeee.svg)
 * [WPBook](https://wordpress.org/plugins/wpbook/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpbook/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpbook/)
 * [Active Topics](https://wordpress.org/support/plugin/wpbook/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpbook/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpbook/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [John Eckman](https://wordpress.org/support/users/johneckman/)
 * Last activity: [13 years, 10 months ago](https://wordpress.org/support/topic/plugin-wpbook-comments-not-importing/#post-2828573)
 * Status: resolved