WordPress.org

Ready to get started?Download WordPress

Forums

Wordbooker
Not working with FB (25 posts)

  1. gonz00
    Member
    Posted 1 year ago #

    I pressed "Reset Status"

    Notice shown "Wordbooker needs to be set up" and "Authorzie Wordbooker" Button.

    So, pressed "Authorize Wordbooker"

    "Reload page" apperas and pressed that button

    Finally: on status section I can't see ma page only this:

    Status ( )

    (Thu Jan 1, 1:00 am).

    Wordbooker is able to connect to Facebook

    So, I can;t authorize my blog and fanpage with Wordbooker :(

    Also Wordbooker says that mysql tables are not exists - but under phpmyadmin they are exists.

    Any help ?

    http://wordpress.org/extend/plugins/wordbooker/

  2. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    If Wordbooker doesn't think they exist then it wont work. Can you post the suppport information and also confirm what tables you say phpmyadmin says are there

    Is this a new install?

  3. gonz00
    Member
    Posted 1 year ago #

    It was upgraded version. Every time I am reloading page it shows following status (but tables in MYSQL exists !!!):

    Please provide the following information about your installation:
    Wordbooker: 2.1.24
    Wordbooker Code Base: 2.1.24 R00 - Some Kind of Wizard
    Wordbooker ID: 254577506873
    Wordbooker Schema: 5.6
    WordPress: 3.4.2
    Table prefix: wp_
    PHP: 5.2.14
    PHP Memory Limit: 256M
    PHP Memory Usage (MB): 54.75
    JSON Encode: PHP
    JSON Decode: PHP
    Curl Status: Curl is available and can access Facebook - All is OK ( Response Time was : 0.425426959991 seconds )
    Curl Version: 7.21.1
    JSON Version: 1.2.1
    SimpleXML library: 0.1 (provided by PHP)
    HTTP Output Character Encoding: pass
    Internal PHP Character Encoding: UTF-8
    MySQL: 5.0.51a
    Server : Apache/2
    Active Plugins :
    Akismet ( 2.5.6 )
    Clicky for WordPress ( 1.4.2.1 )
    Contact Form 7 ( 3.3.1 )
    Easy Stats ( 1.0 )
    Advanced YouTube Embed Plugin - Embed Plus ( 2.1.9 )
    FancyBox for WordPress ( 3.0.2 )
    GD Star Rating ( 1.9.20 )
    Google Analytics for WordPress ( 4.2.8 )
    Google XML Sitemaps ( 3.2.8 )
    Helion Widgets Pro ( 1.1.2 )
    InfiniteWP - Client ( 1.1.2 )
    Page Tagger ( 0.4.2 )
    POST2PDF Converter ( 0.4.2 )
    External Links ( 4.0.6 )
    Shortcode Manager ( 1.2.5 )
    Dagon Design Sitemap Generator ( 3.15 )
    Social Slider ( 7.4.7 )
    Subscribe To Comments ( 2.1.2 )
    upPrev ( 3.3.10 )
    WordPress SEO ( 1.2.8.7 )
    WP-Ban ( 1.60 )
    WPMS Mobile Edition ( 0.4 )
    WPtouch ( 1.9.42 )

    Wordbooker Table Status :
    ERROR : table 'wp_wordbooker_errorlogs' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_postlogs' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_userdata' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_userstatus' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_postcomments' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_process_queue' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_fb_friends' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_fb_friend_lists' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page

  4. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    Was it an upgrade from a 1.x version? If it was then did you follow the upgrade process?

    The tables names have not changed in the 2.x release

  5. gonz00
    Member
    Posted 1 year ago #

    Frankly I can say that I dont know. Every time I saw in wordpress panel to upgrade it I did it.
    I use Wordbookr for ages :)

  6. gonz00
    Member
    Posted 1 year ago #

    Each time I reset status I can do always the same steps.

    On FB account I have few fanpages controlled with WordBooker plugin.

  7. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    OK - well something has gone wrong - have you changed anything in your wordpress configuration like changing the table structure?

    What tables does phpmyadmin report as existing...?

  8. gonz00
    Member
    Posted 1 year ago #

    No, I dont change anything - I am not good with it.

    Tables are shown here: http://tinypic.com/r/5l8hhc/6 - they are still exists but wordbookers says - they are not.

  9. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    Can you try deactivating and then reactivating the plugin from the plugins menu...... something has gone very wrong somewhere...

  10. gonz00
    Member
    Posted 1 year ago #

    I did it many many many times :)

    May be there is a problem with another plugin which blocks wordbooker ?

  11. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    Have you changed anything on the database? (changed the user you are connecting to the database as for example)

    Can you check your PHP error logs?

    Wordbooker is not seeing its own tables so it can never work..

  12. gonz00
    Member
    Posted 1 year ago #

    I know WB doesn;t see them, even more - I have removed them and reactivated WB plugin - still the same.

    What should I look in the php log ?

    edit: ok .. error log is disabled. I will try on the weekend to see if there's any issue.

  13. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    So you deleted them and it put them back?

    You're looking for errors related to the database - especially anything to do with calls involving "select count(*) from"

  14. gonz00
    Member
    Posted 1 year ago #

    Mai be it is a time to change my server ;)

    I will come back after weekend.

  15. gonz00
    Member
    Posted 1 year ago #

    It works !~

    1. Deleted WB tables
    2. Deactivated and Activated plugin
    3. Set up all to defaults
    4. Resetted and refreshed status

    And it worked !

  16. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    Very odd - something must have upset something somewhere...

  17. gonz00
    Member
    Posted 1 year ago #

    But problem solved .. .for this time :)

  18. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    Well no-one else has ever reported it - so I'm wonderingg if it was a glitch on your server like it running out of database connections.

  19. flyden
    Member
    Posted 1 year ago #

    I have a similar problem.
    Installed Wordbooker.
    Connected to my FB account (used to administer a number of clients pages).
    Reload Page worked ok.
    But User Level Settings will only give me the option to post to Personal Wall?
    It does not recognise any other pages that I Administer?
    Also the Status section only displays unpopulated brackets ( ) with no name or avatar.
    But does state 'Wordbooker appears to be configured and working just fine'.....

    I assume FB (Admin Pages) allows incoming connections from more than one Wordbooker source?

    Help please

  20. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    Can you post your support information?

    Also if you set the diagnostic level (in the advanced settings) to Show everything it should show you a lot of messages related to Cache Refresh... can you post those.

    If its a lot then please take it over to the Wordbooker Support forums at:

    http://wordbooker.tty.org.uk/supportforums/

  21. flyden
    Member
    Posted 1 year ago #

    Thanks Steve, see below as requested:

    Please provide the following information about your installation:
    Wordbooker: 2.1.24
    Wordbooker Code Base: 2.1.24 R00 - Some Kind of Wizard
    Wordbooker ID: 254577506873
    Wordbooker Schema: 5.6
    WordPress: 3.5
    Table prefix: wp_
    PHP: 5.2.13
    PHP Memory Limit: 256M
    PHP Memory Usage (MB): 24.75
    JSON Encode: PHP
    JSON Decode: PHP
    Curl Status: Curl is available and can access Facebook - All is OK ( Response Time was : 2.0228319168091 seconds )
    Curl Version: 7.20.0
    JSON Version: 1.2.1
    SimpleXML library: 0.1 (provided by PHP)
    HTTP Output Character Encoding: pass
    Internal PHP Character Encoding: UTF-8
    MySQL: 5.0.51a
    Server : Microsoft-IIS/7.0
    Active Plugins :
    WooDojo ( 1.3.0 )
    WooSidebars ( 1.2.0 )
    WooThemes Updater ( 1.0.1 )

    Wordbooker Table Status :
    ERROR : table 'wp_wordbooker_errorlogs' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_postlogs' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_userdata' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_userstatus' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_postcomments' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_process_queue' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_fb_friends' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page
    ERROR : table 'wp_wordbooker_fb_friend_lists' is missing ! - Please Deactivate and Re-activate the plugin from the Plugin Options Page

  22. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    Hmm - it looks like its lost sight of your tables.. can you follow the instruction its suggesting you try..... which is to go the plugins page and de-activate the plugin then re-activate it....

  23. Steve
    Member
    Plugin Author

    Posted 1 year ago #

  24. flyden
    Member
    Posted 1 year ago #

    Ok, thanks Steve, I've resolved it.
    One of my developers decided in his wisdom to use a SQL Server database rather than MySQL in order to simplify our backups. Worked fine with everything else but WB obviously doesn't like the structure!? Reverted to MySQL, started again and all appears ok now.
    Any comment on SQL Server btw? It would be useful for us on installations that already have this in place?
    Cheers, D.

  25. Steve
    Member
    Plugin Author

    Posted 1 year ago #

    That might explain it - there were a couple of mysql calls using a specific php function in the version you were using - the patched version doesn't use them, it uses the wpdb constructs to make DB calls so it should work.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.