WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin : Wordbooker] Bug reports (86 posts)

  1. Steve
    Member
    Posted 4 years ago #

    Comment synching was always problematical and I know what is causing the problem with the current release, and indeed it might be fixed in the dev release available from the Wordbooker Facebook page.

    Comment handling is due for a complete re-write in 1.8 to handle things like comments on fan walls etc.

  2. Iva
    Member
    Posted 4 years ago #

    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. :)

  3. waiting
    Member
    Posted 4 years ago #

    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,

  4. Steve
    Member
    Posted 4 years ago #

    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?

  5. waiting
    Member
    Posted 4 years ago #

    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,

  6. Steve
    Member
    Posted 4 years ago #

    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

  7. waiting
    Member
    Posted 4 years ago #

    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

  8. Steve
    Member
    Posted 4 years ago #

    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

  9. waiting
    Member
    Posted 4 years ago #

    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();
                                    }
  10. Steve
    Member
    Posted 4 years ago #

    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?

  11. abatis
    Member
    Posted 3 years ago #

    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?

  12. Steve
    Member
    Posted 3 years ago #

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

  13. abatis
    Member
    Posted 3 years ago #

    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.

  14. Steve
    Member
    Posted 3 years ago #

    OK I'll look at that tomorrow.

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

  15. abatis
    Member
    Posted 3 years ago #

    There's a drop-down list but the only choice reads "admin (you)."

  16. Steve
    Member
    Posted 3 years ago #

    So have they associated their Wordbook accounts with FB?

  17. abatis
    Member
    Posted 3 years ago #

    I uploaded the wordbook plugin to my blog. How do they have separate accounts apart from the blog?

  18. Steve
    Member
    Posted 3 years ago #

    What do you mean?

  19. kellymarie2001
    Member
    Posted 3 years ago #

    I updated WordPress to 3.0 and was having some issues getting into my admin area. After uninstalling and reinstalling each plugin, Wordbooker is the only one that refuses to work. Basically what happens is the whole admin area stops working. Sorry, I'm not a developer and wish I could be more specific! Hopefully that will help figure out what I'm referring to. Any help would be appreciated!
    Thanks in advance, Kelly

  20. Steve
    Member
    Posted 3 years ago #

    "The Whole admin area stops working" doesn't really help me - do you mean the Wordbooker admin back end or what?

    I'm running on 3.0 and have no problems.

    Are you running any back end plugins?

  21. kellymarie2001
    Member
    Posted 3 years ago #

    Hi Steve, Thanks for getting back to me!

    I guess the best way to describe it is the WordPress admin area does not load in my browser. After I upload Wordbooker to my plugins folder via FTP, my dashboard stops loading and I can't make any posts for my blog. Once I delete the Wordbooker plugin from my FTP site, I have no problems.
    My server is all up to speed (in terms of php version, etc.) so I've crossed that off the list of potential issues.
    Hope that helps...Thanks!

  22. Steve
    Member
    Posted 3 years ago #

    OK it must be throwing an error somewhere. Can you check your PHP or Apache error logs and see if there is anything reported?

    What is odd is that if its not been activated its not doing anything....

  23. kellymarie2001
    Member
    Posted 3 years ago #

    It looks like the only errors I'm getting is for my wordpress theme, which may not apply. I'll give it a shot here anyways!
    PHP Warning: Invalid argument supplied for foreach() in /mnt/target02/347468/389164/www.mywebsiteurl.com/web/content/wp-content/themes/atahualpa/functions/bfa_ata_admin.php on line 459

  24. kellymarie2001
    Member
    Posted 3 years ago #

    Should I be looking for another type of error? I'm still having the same issues. Thanks!

  25. Steve
    Member
    Posted 3 years ago #

    I downloaded the atahulpa theme (version 3.4.9) and installed it and everything seems to be working OK,

    So when you've uploaded the plugin is it killing your entire blog backend before you even activate it?

  26. kellymarie2001
    Member
    Posted 3 years ago #

    With WordPress 3.0, I would start seeing issues as soon as I uploaded the Wordbooker plugin via FTP. I could log in to my admin area, but only saw a blank page in my browser.
    I just updated WordPress to 3.0.1, hoping that would solve the problem, but it didn't. This time, however, I installed the WordPress plugin via FTP and was able to view it listed in my Plugins directory in the WordPress admin area. As soon as I click "Activate", I get a blank screen in my browser and cannot edit or view any posts, pages, plugins or anything in my WordPress admin area. As soon as I delete the plugin via FTP, I have no problems.
    Feel free to email me directly at kellymarie2001@gmail.com and I can give you more specifics if needed!

    Thanks!

  27. Steve
    Member
    Posted 3 years ago #

    So what is being thrown in your php error logs because a blank screen implies a PHP error.

    Does your server meet the minimum PHP requirements (>5.0) for Wordbooker?

  28. Steve
    Member
    Posted 3 years ago #

    It has got to be something on your server that is causing problems - even if things like curl and fopen are blocked the plugin will install and activate - it just wont work.

    Is your site Echo Park Now?

    Any chances of some screen shots?

  29. briandickens
    Member
    Posted 3 years ago #

    First issue: When I post from Mars Edit 3, Wordbooker pushes the post to FB like it should. When I update a post that I've already published, Wordbooker sees it as a new post and reposts it to FB.

    Second Issue: My wife uses MS Writer to post from the PC. When she posts, Wordbooker doesn't put a post on Facebook. I need to go in an republish it manually to get to to show. I have wordbooker set to always publish new posts to my FB feed.

    Any ideas?

  30. Steve
    Member
    Posted 3 years ago #

    I'll look into the first problem - I'm changing how the app records that a post has been processed for version 2.

    Ms Writer - is that LiveWriter under a different name? If so LW seems to do some very odd things and doesn't play too well with WordPress.

Topic Closed

This topic has been closed to new replies.

About this Topic