Support » Plugins and Hacks » [Plugin : Wordbooker] Bug reports

  • If people are having problems with my Wordbooker plugin rather than just voting saying its “broken” can you please post some information and I’ll look into it.

    I know that it doesn’t play well with some other Facebook plugins down to the fact that they are using old and obsolete versions of the Facebook API client libraries which don’t support the methods this plugin uses. Unfortunately there isn’t a lot I can do about that.

Viewing 15 replies - 31 through 45 (of 85 total)
  • Iva

    (@supersonicsquirrel)

    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. 馃檪

    waiting

    (@waiting)

    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,

    Steve

    (@steveatty)

    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?

    waiting

    (@waiting)

    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,

    Steve

    (@steveatty)

    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

    waiting

    (@waiting)

    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

    Steve

    (@steveatty)

    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

    waiting

    (@waiting)

    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();
                                    }

    Steve

    (@steveatty)

    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?

Viewing 15 replies - 31 through 45 (of 85 total)
  • The topic ‘[Plugin : Wordbooker] Bug reports’ is closed to new replies.