[Plugin : Wordbooker] Bug reports

So, I should look out for that? Nice!

And I wonder how you guessed that I was testing it on a Facebook (fan) page, but well, so is the life, full of mysteries.

My other concern is, when comment fetching works again, as I use Intense Debate to handle my comments, will that cause any additional issues?

Thanks for your prompt response. ??

Hello,
I am having problems because the posts are not being published on Facebook and I have this error on my logs:

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 onetime_data,facebook_error,secret,session_key,user_ID FROM wp_wordbook_userdata WHERE user_ID = made by do_action_ref_array, call_user_func_array, check_and_publish_future_post, wp_publish_post, wp_transition_post_status, do_action, call_user_func_array, wordbooker_publish, wordbooker_get_userdata

I have made by myself the query via command-line and:

mysql> SELECT onetime_data,facebook_error,secret,session_key,user_ID FROM wp_wordbook_userdata WHERE user_ID = ;
ERROR 1064 (42000): 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

mysql> SELECT onetime_data,facebook_error,secret,session_key,user_ID FROM wp_wordbook_userdata WHERE user_ID = 1 ;
+————–+—————-+——–+———————————————+———+
| onetime_data | facebook_error | secret | session_key | user_ID |
+————–+—————-+——–+———————————————+———+
| N; | N; | N; | s:35:”cXXXXXXXXXXb3e89c459b6f8dc4-1115178997″; | 1 |
+————–+—————-+——–+———————————————+———+
1 row in set (0.00 sec)

I have modified the facebook_error field here ;D

As I could trace, it looks $user_id has not a value, but if I have checked with var_dump ($user_id)

function wordbooker_get_userdata($user_id) {
var_dump ($user_id);
global $wpdb;
$sql=’SELECT onetime_data,facebook_error,secret,session_key,user_ID FROM ‘ . WORDBOOKER_USERDATA . ‘ WHERE user_ID = ‘ . $user_id ;

and what I obtain is:

int(1) string(1) “1” int(1) int(1) string(1) “1”

So it looks the content is ‘1’ -> So it should be OK

I am using:

# Wordbooker: 1.7.7
# Wordbooker Schema: 3
# Facebook PHP API: PHP5
# JSON library: PHP
# SimpleXML library: PHP
# WordPress: 2.9.2
# PHP: 5.1.6
# MySQL: 5.0.82sp1
# Server : Microsoft-IIS/5.0 -> In fact is apache 2.X but, I faked it
# Active Plugins :
Add To Facebook ( 1.4.3 )
WordPress Exploit Scanner ( 0.95 )
FD Feedburner Plugin ( 1.42 )
Login LockDown ( v1.5 )
Official StatCounter Plugin ( 1.4 )
Secure WordPress ( 0.8.2 )
SI CAPTCHA Anti-Spam ( 2.2.9 )
Tweet Blender ( 3.1.2 )
Tweet This ( 1.6.1 )
WordPress Database Backup ( 2.2.2 )
WP HTTP Compression ( 1.0 )
WP Security Scan ( 2.7.1.2 )
WP-SWFObject ( 2.3 )

Any help would be appreciated. Best regards,

Can you go into the options page and do a refresh on your status and see what happens there?

Also what were you doing to get that error?

Hi Steve,

after patching DB with the ALTER Table sentence I have found before in this post, it goes even far

2010-04-06 13:58:53 Prueba. Perdón RSS Post option : wordbook_advanced_diagnostics on
2010-04-06 13:58:54 Prueba. Perdón RSS Post option : wordbook_status_id -100
2010-04-06 13:58:55 Prueba. Perdón RSS Posting as user : 1
2010-04-06 13:58:56 Prueba. Perdón RSS Calling wordbooker_fbclient_publishaction
2010-04-06 13:58:57 Prueba. Perdón RSS Getting the rest of the images
2010-04-06 13:58:58 Prueba. Perdón RSS setting image array to be only post images.
2010-04-06 13:58:59 Prueba. Perdón RSS Getting the Excerpt
2010-04-06 13:59:00 Prueba. Perdón RSS Calling wordbooker_fbclient_publishaction_impl

But it finally it doesn’t publish the post. If I force to change my status, it works!… but If I publish something new, it does not…

UPDATE: I have been testing, and it does not work as it should. It is able to change my status (with the link to the blog) but it is not able to create a new wall entry…

Please let me know what I could provide you to help me. Regards,

What happens after:

2010-04-06 13:59:00 Prueba. Perdón RSS Calling wordbooker_fbclient_publishaction_impl

There should be a lot more diagnostic information

Here you have another piece of logs:

2010-04-06 14:50:07 la última y nos vamos Getting the Excerpt
2010-04-06 14:50:08 la última y nos vamos Calling wordbooker_fbclient_publishaction_impl
2010-04-06 14:50:09 la última y nos vamos Read Full link being used
2010-04-06 14:50:10 la última y nos vamos posting to personal wall and fan wall (if available)
2010-04-06 14:50:11 la última y nos vamos posting to personal wall with action link

but it does not post on Facebook wall

There should be more than that

I would expect to see things like:

Publish to Personal wall result

And it should all finish off with a “All Done” message

so… what do you think I could test? I have tried to disable Wordbooker and enable it again (regenerating the one-time code for Facebook), but still crashes on the same point ??

As far as I see, the “All Done” message should appear when wordbooker_fbclient_facebook_finish starts.

return wordbooker_fbclient_facebook_finish($wbuser, $result,$method, $error_code, $error_msg, $postid,$result2, $error_code2, $error_msg2);

In my case it crashes in:

list($result, $error_code, $error_msg, $method,$result2, $error_code2, $error_msg2) = wordbooker_fbclient_publishaction_impl($fbclient, $post_data);

Just before:

try {
                                $result2 = $fbclient->stream_publish($message, json_encode($attachment),json_encode($action_links),null,$wordbooker_post_options["wordbook_page_post"]);
                                wordbooker_debugger("Publish to Fan wall result : ",$result2,$post->ID) ;
                                                }
                                        catch (Exception $e) {
                                        $error_code2 = $e->getCode();
                                        $error_msg2 = $e->getMessage();
                                }

It crashing somewhere in here:

try {
				$result = $fbclient->stream_publish($message,json_encode($attachment), json_encode($action_links));
			wordbooker_debugger("Publish to Personal wall result : ",$result,$post->ID) ;
				}
					catch (Exception $e) {
					$error_code = $e->getCode();
					$error_msg = $e->getMessage();
				}

And given that you don’t get the “Publish to Personal wall result ” message it would suggest that the stream_publish call is failing.

Do you have anything in the error logs if you turn off diagnostics? Is there anything in your php error log?

Steve,

I have a multi-author blog. All authors are on Facebook. When another of the authors posts an article it shows up on Facebook as a post to my wall and with me as the author (since I’m the blog admin), not theirs. How do I ensure the actual author is “getting credit” for his work?

Have you set the blog level option “Post as” to “current user”?

Right now, they’re set as, “Unless changed, Posts will be published on the Facebook belonging to : Current user.” No matter who’s posting , on Facebook it shows up as the admin –me.

OK I’ll look at that tomorrow.

When they go to the edit post screen what name is the wordbooker posting options showing?

There’s a drop-down list but the only choice reads “admin (you).”

So have they associated their Wordbook accounts with FB?