WPBook just imports the first Comment

@ombre8 With debugging enabled, wpbook will try to create a debug.txt file in your /wp-content/plugins/wpbook/ folder – do you see one there?

If you do, can you post it somewhere we can look at it?

@ombre8 – doesn’t look like a full url – where is the debug file uploaded?

Do you know if the timezone is set correctly on your server, and the timezone selected in WordPress?

Very helpful, thanks.

it finds 4 “interesting” posts:
2010-12-08 09:05:55 : How many meta_posts found? 4

That is four posts with entries in the post_meta table from WPBook.

The first one which has comments is post 683, here:

2010-12-08 09:05:57 : Examining a meta_post, post ID is 683, meta key = _wpbook_user_stream_id
2010-12-08 09:05:57 : FBcomments, fbsql is SELECT time,text,fromid,xid,post_id FROM comment WHERE post_id='userid_10150346504900224' AND time > '0' ORDER BY time ASC
2010-12-08 09:05:58 : FBcommentslist is Array
2010-12-08 09:05:58 : Number of comments for this post- 13
2010-12-08 09:05:58 : Inside comment, comment[time] is 1291672070, comment[fromid] is 1142498917
2010-12-08 09:05:58 : Getting author info, fbsql is SELECT name,url FROM profile WHERE id = '1142498917'
2010-12-08 09:05:58 : fbuserinfo is an array, count is 1
2010-12-08 09:05:58 : In fb_user, name is Chris Wagner, url is http://www.facebook.com/chris.curacao
2010-12-08 09:05:58 : comment[time] was 1291672070, gmt offset is 1, local_time is 1291675670

But that entry ends right at that point – the next line is:
2010-12-08 09:19:32 : Cron Running

which is the next cron run. This happens multiple times.

I can see we are getting to line 282 in wpbook_cron.php, which writes out:

$debug_string=date("Y-m-d H:i:s",time())." : comment[time] was $comment[time], gmt offset is ". get_option('gmt_offset') .", local_time is $local_time   \n";

What we don’t do, though, is get to the next debug statement at line 316, which would say:

$debug_string=date("Y-m-d H:i:s",time())." : Posted comment with timestamp $time, id $my_id, approval $wpbook_comment_approval \n";

So the comment is not successfully imported, as far as WPBook is concerned, which is I guess why it keeps trying to reimport the same comment.

Something is critically failing between fetching the comment and trying to post it to WordPress – failing so much that the cron run just ends and then waits to run again.

But you said the comment does get inserted, so we are getting past line 311:

$my_id = wp_insert_comment($data);

Or at least some of that statement successfully executes – maybe it fails midprocess, but without throwing an error?

Can you point me to what his comment was, on which post in Facebook, and where it shows on your WordPress blog?

@ombre8 if I created a version of wpbook_cron.php with more debugging in it, could you run it for me?

I think we have isolated through your debug.txt file the problem down to a very specific set of calls between lines 311 and 316.

I’ll add more debug code in there and update here once it is ready for testing.