iandevlin.com

Icon

A mixture of musings on web design & development, history, and life

Twitter Tools 2.0 and WordPress 2.8.6 Issues

I’ve been using Twitter Tools for a number of weeks now, automatically having some of my Twitter posts displayed on this blog. However I noticed today that they had stopped working. I knew that I had changed my Twitter password recently and realised that I had forgotten to change it in Twitter Tools. No problem, this can be resurrected easily enough I thought.

Except that it wasn’t.

Every time I entered the new password, and tried to test the connection, a message was being returned from Twitter first of all saying

Sorry, login failed. Error message from Twitter: This method requires authentication

and after a few attempts:

Sorry, login failed. Error message from Twitter: Rate limit exceeded. Clients may not make more than 150 requests per hour.

I couldn’t find anywhere on my Twitter account settings > connections panel to do this (and indeed there never was an indication here that Twitter Tools had access anyway). I tried to de-activate the plugin and re-activate it, but this didn’t help (hey it’s always worth a shot).

So like everyone else these days, I Googled it and found that many people have had the same issue recently. Each post I found had people suggesting different draconian methods of fixing the issue, different ones seemingly working for different people, but there was one difference : they were all for earlier versions of WordPress, and not the latest 2.8.6. Eventually I found one blog post by Shekhar Govindarajan on the integration between WordPress and Twitter whilst also providing a solution to the problem that I was having. I will post here what I did, taken from his suggestions:

  • Take note of your Twitter Tools settings
  • Deactivate and delete the Twitter Tools plugin
  • Take a backup of your database (just in case)
  • Delete all the Twitter Tools related options from the database table (the deletion above does not do this) from the WordPress options table, probably called wp_options which is the default setting, but it might have a different prefix, depending on your setup when you first installed and set up WordPress; using the following MySQL command:
    delete from wp_options where option_name like 'aktt%';
  • Reinstall the Twitter Tools plugin (I simply did this from the WordPress plugin dashboard) although Shekhar suggests downloading it and unzipping it yourself
  • Activate the plugin
  • Enter your Twitter username and password and test the connection. It should work fine (it did for me)
  • Set your settings back to whichever way you had them setup prior to deleting the plugin

Hopefully this will solve your problems, and thank Shekhar if it does!

http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/digg_24.png http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/reddit_24.png http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/stumbleupon_24.png http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/delicious_24.png http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/technorati_24.png http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/google_24.png http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/facebook_24.png http://www.iandevlin.com/blog/wp-content/plugins/sociofluid/images/twitter_24.png

Related posts:

  1. Firefox 3.6.3 losing login details
  2. Grid Focus – HTML5 WordPress Theme
  3. Chat Feature for World Land Trust

24 Responses

  1. Shekhar says:

    Thanks Ian for updating that the solution worked for you, I’m glad. Twitter Tools is a great plugin and its good to have it back, working!

  2. ian says:

    No problem, thanks to you!

  3. Mario Berges says:

    I actually didn’t have to delete anything from the database. What I did instead was to update my password in it by doing:

    update wp_options set option_value=’MY_NEW_PASSWORD’ where option_name=’aktt_twitter_password’;

    This worked for me.
    Thanks for posting this.

  4. ian says:

    Thanks for that Mario and definitely worth trying before going through the rigamarole of re-installing!

    However they’ve just released WordPress 2.9, so all this will either be redundant, or we’ll have to do it again! (in which case I’ll try your method first!)

  5. Pablo Faria says:

    Thanks! But I needed only to deactivate the plugin, delete the info from ‘wp_options’ and activate it (and set up) gain.

  6. ian says:

    Glad to hear it Pablo. It seems that different people have had different issues with it, but this is the one that worked for me at the time.

    Of course they’ve both moved on in versions now, and so far have been working fine together.

    Thanks for posting! :-)

  7. cg says:

    I’m sorry for asking this; however, I’m not sure what you mean by “using the following MySQL command:”

    can you explain how to do this?

    Thank you!

  8. ian says:

    Hi cg,

    One of the technologies that WordPress is based on is the MySQL database. This database can be queried using a lanuage called SQL.

    But to be honest, if you didn’t understand about that, you probably shouldn’t be messing about with SQL as you might damage your WordPress blog completely.

    What specific problems are you having, and I can try to help you more specifically?

    Ian

  9. cg says:

    When I attempt to test my Twitter login “Test Login Info”, I receive the following:

    Sorry, login failed. Error message from Twitter: This method requires authentication

    Every now and then I will get:

    Sorry, login failed. Error message from Twitter: Rate limit exceeded. Clients may not make more than 150 requests per hour.

    I verified ID and password. It has worked before because I made test posts. Then one day it just stopped.

    I’m running:
    Wordpress 2.8.6
    Twitter Tools 2.0

  10. ian says:

    Ah ok, sounds like exactly what happened me then, hence you’re here then obviously!

    To be honest I recommend you upgrade WordPress to the latest version 2.9.1 and Twitter Tools which is now on version 2.2.1. This should help clear up these issues and it’s always good to upgrade anyway.

  11. cg says:

    I will try that and report back. Thank you!

  12. ian says:

    No worries!

  13. David says:

    Great post and tip to you Mario..I went into the database without uninstalling and reset the password. Even though the password was correct. I reset the password, then it connected.

    Thanks!

  14. cg says:

    OK…I updated WP to 2.9.1 and TT to 2.2.1. I’m still getting the same message.

    “Sorry, login failed. Error message from Twitter: Rate limit exceeded. Clients may not make more than 150 requests per hour.”

    What software do I need to do in order to get into the DB?

  15. ian says:

    Sorry for the delayed response, I’ve been away.

    I would have thought the upgrade would have sorted it for you. Oh well.

    Where is your WordPress blog hosted? Do you have access to the machine itself or is it on wordpress.com?

  16. Amish says:

    THANK. YOU. SO. MUCH.

  17. cg says:

    I’m checking with our church because they are the account holder. I believe it’s either Go Daddy or 1&1. I know they did the install so it’s not the wordpress.com

  18. ian says:

    Ok, I’ll email you outside of this thread for now.

  19. [...] Por más que la gente anduvo preguntando en los foros de WordPress no obtuvo respuestas, empero yo sí y provino de un comentario bastante acertado que leí de Mario Berges en el blog de Ian Devlin. [...]

  20. [...] Por más que la gente anduvo preguntando en los foros de WordPress no obtuvo respuestas, empero yo sí y provino de un comentario bastante acertado que leí de Mario Berges en el blog de Ian Devlin. [...]

Leave a Reply