How to reproduce:

  1. Set up Twitter module and get it to where it imports a user's tweets.
  2. Verify that tweets are present in Drupal twitter table with phpmyadmin.
  3. Create new tweet.
  4. Verify that new tweet really exists in Tweetdeck.
  5. Run cron in Drupal.
  6. Check twitter table with phpmyadmin.

phpmyadmin shows that the twitter table has no updates, and there are no cron errors.

Clearly there is some failure here. Shoudn't the module record failures to the site log?

CommentFileSizeAuthor
#63 tweet-correct-user-652164-63.patch436 bytesmichaek
#39 matt_p.jpg9.74 KBfattmox

Comments

aren cambre’s picture

Have logged out, logged back in, ran cron again, and still no updates.

In case it matters, the site only has one user (me).

mrmeech’s picture

Same for me -- this was working correctly for months and now i'm experiencing the symptoms listed here. Maybe something in the Nov. 13th API update broke this module? http://apiwiki.twitter.com/REST+API+Changelog

jboeger’s picture

Same for me... tweets have not updated for 4 weeks. dannybarnes.com

aren cambre’s picture

Title: Fails to import new tweets, shows no error » Module doesn't import new tweets, shows no errors
Priority: Normal » Critical

Raising profile. This is essential functionality.

ianreeves’s picture

I'm getting same problem too.

danny englander’s picture

I am having the same issue

NoRandom’s picture

Subscribing.

kahunacohen’s picture

Same here. I thought it was just me.

wiifm’s picture

same here, subscribing

caraiba’s picture

Until the issue is not solved, I found one way to deal of this.
You go to user's account, delete his/her twitter account(s) (aka: /user/xxxx/edit/twitter) and add the twitter account(s) back again. It is working for me (I have just one twitter account).

kahunacohen’s picture

That doesn't work. I tried that. It works the first time you do it, but then doesn't update after that.

filiptc’s picture

Same here. I did get "400 Bad Request" a couple times in the watchdog though, which I haven't been able to link to any action on my part.

Tried suggested approach of #10 unsuccessfully.

kahunacohen’s picture

Is someone maintaining this module? This seems to have come up in early dec.

I'm tempted to start hacking on it :)

aren cambre’s picture

walkah committed some code 5 days ago. I emailed him recently through his contact form here but haven't heard back.

kaakuu’s picture

Subscribing.

aren cambre’s picture

Could this issue be related to #574556: Global account's tweets don't appear? I'm leaning no but interested in second opinions.

NoRandom’s picture

I can't neither properly add my own twitter, I'm getting this error:

    * warning: parse_url(http:///account/verify_credentials.xml) [function.parse-url]: Unable to parse URL in /home/mysite/www/includes/common.inc on line 439.
    * warning: parse_url(http:///account/end_session) [function.parse-url]: Unable to parse URL in /home/mysite/www/includes/common.inc on line 439.
    * Twitter authentication failed. Please check your account name and try again.

...and I can't delete it.

Regards.

aren cambre’s picture

#17 appears to be different; please open a separate issue for it.

jeffreyvddb’s picture

I'm also having the same problem..

MadOverlord’s picture

Ditto... or should that be Twitto...

Installed first current, then dev versions (lots of SQL errors on running update.php, btw), entered default account info, no data being fetched from twitter, no errors.

Also when I went to the admin users twitter settings, I got this:

user warning: Unknown column 'twitter_account.uid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT twitter.twitter_id AS twitter_id FROM twitter twitter LEFT JOIN twitter_account twitter_account ON twitter.screen_name = twitter_account.screen_name LEFT JOIN users users ON twitter_account.uid = users.uid WHERE (twitter_account.protected = 0) AND (users.uid = 1) ) count_alias in /Applications/MAMP/htdocs/sites/all/modules/contrib/views/includes/view.inc on line 739.
user warning: Unknown column 'twitter_account.uid' in 'on clause' query: SELECT twitter.twitter_id AS twitter_id, twitter_account.profile_image_url AS twitter_account_profile_image_url, twitter.text AS twitter_text, twitter.created_time AS twitter_created_time FROM twitter twitter LEFT JOIN twitter_account twitter_account ON twitter.screen_name = twitter_account.screen_name LEFT JOIN users users ON twitter_account.uid = users.uid WHERE (twitter_account.protected = 0) AND (users.uid = 1) ORDER BY twitter_created_time DESC LIMIT 0, 10 in /Applications/MAMP/htdocs/sites/all/modules/contrib/views/includes/view.inc on line 765.

Oh, so bad news.

Uninstalled the module. Made sure no twitter tables using myPHPadmin. Reinstalled dev version. Set permissions. Set a default account -- only options available were global account and twitter import.

Ran cron multiple times, no joy. twitter and twitter_account tables remained empty.

Went to /user/1/edit/twitter and checked import and submitted. This did create a row in twitter_account.

Ran cron several times.

No tweets retrieved.

Sigh.

eddie123123’s picture

Subscribing.

zwhalen’s picture

This problem, I have it as well.

anarcat’s picture

Yawn. Same here. Nothing in the watchdog or anywhere, blocks don't appear, etc.

drein’s picture

same problem, but using the last stable version, twitters appears, but it is impossible to post.
instead with the latest 2.xdev, twitters doesn't appear, but it is possible to twit.

kahunacohen’s picture

Hmm, now I see that when I run cron, I get the updates, but only when I run cron.

danny englander’s picture

@kahunacohen - I just noticed that too, I remember reading about setting up cron to run on a set schedule. I know it's a work around but at least it would temporarily solve the problem. I think this also gives some clues as to a fix perhaps.

aren cambre’s picture

Running cron doesn't make a difference for me regardless of whether I invoke it with cron.php or admin/reports/status/run-cron. Additionally, I use poormanscron, so cron has run many times since I opened this issue.

Anonymous’s picture

Version: 6.x-2.6 » 6.x-2.x-dev
Issue tags: +completely broken

Subscribing since it's broken for me, too.

edcazini’s picture

Version: 6.x-2.x-dev » 6.x-2.6
Issue tags: -completely broken

Hi, solved mine just a few minutes ago. At first my twitter blocks (I enabled "all" & "user" tweets just to be sure), didn't even display in the designated sidebar.

Post #10 (thanks to caraiba) did the trick, but instead of trying to delete the twitter account entry already there (wasn't able to delete anyway after so many attempts), just add a new entry, you'll notice if it's successful since the un-deletable account will now reflect the correct twitter account.

To test #11, I ran CRON & my new tweets were retrieved. I'll do it again some other time & see if #11 do come true, I hope not. I also did the reverse, posting from my site to twitter & it was a success.

Anyways, my guess is that the "Global account" setting in admin/settings/twitter does not work. I'm just a kindergarten webdev so I can't follow the code chain.

Twitter 6.x-2.6
Cheers!

update: #11 did not occur

aren cambre’s picture

@EdCazini, what do you mean by "update: #11 did not occur"? Do you mean that it is in fact not fixed?

edcazini’s picture

@Aren, no, what I mean is "I did not encounter this issue" --> "works the first time you do it, but then doesn't update after that".

The module's working fine for me.

HelloStephanie’s picture

Also having this issue, subscribing.

andread’s picture

I had the same problem too. But I have fixed it with the following method:

I have done, like #10 : "You go to user's account, delete his/her twitter account(s) (aka: /user/xxxx/edit/twitter) and add the twitter account(s) back again." but every time I had to import my tweets, I had to delete and add the account again. (Which is not very useful, when you tweet more than 1 times a day...

So I enabled the user tweets block, but only for authenticated users, and on one exact page, which I know that nobody can access but me.

Now it is importing all tweets, into the "All Tweets" block. (Didn´t even have to run cron!!!)

I have to make some design changes, so it is not visible right now, but in some days you can check it out on: http://www.justfunwithkids.com

Hope it helps others....
Cheers,
Andrea Dóra

ZyanKLee’s picture

doesn't update at all. neither with 6.x-2.6 or with 6.x-2.x-dev yet

betz’s picture

I firstly had the same problem, but i found out that i used my twitter email address, not my username.
When using twitter username it works.

mossill’s picture

Does not work for me either. Posting to twitter works. But I can no import tweets.

aren cambre’s picture

Status: Active » Closed (won't fix)

Just an update--I emailed walkah (this module's maintainer) a few weeks ago per #14 above. If I understood him correctly, this problem should be fixed in this module's 3.0 release, which will have a revamped error handling system.

I am marking this as won't fix since the bug is not going to be fixed in the 2.x line. I'll email walkah again and ask him to confirm if this is accurate.

kaakuu’s picture

So may be till then download link should be taken off or content of #37 put on the first page prominently?

fattmox’s picture

StatusFileSize
new9.74 KB

SOLUTION
I also was having issues with this module. I would try and add an account and it would come back blank. Twitter tables were empty. I am using Drupal 6.15

Things I was doing wring:
Using the account email instead of the user (might be case sensitive too)
Set up the global account incorrectly and then tried to setup a user account which appears to break the add mechanism

How I figured it out:
Watched this video: http://gotdrupal.com/videos/drupal-twitter-module
Uninstalled Twitter module using Admin=>Modules=>Uninstall
Re-enabled the module
Followed instructions from Video

How this could have been avoided:
Some error output rather than just nothing happening.
I was actually able to break the module completely by setting it up incorrectly thereby having to uninstall/enable the module to fix it - some error checking in the code could prevent this. In reality I realize there's no money in it, but hey, this is open source. Anyone could do this... even me.

Thanks for the video Matt P.

candygirl777’s picture

Having the same problem as well - clearing the cache, running cron, nothing has worked so far - has anyone tried the 3.0 beta version yet?

danny englander’s picture

I can confirm that poormans cron is a work around, not a solution.

It only takes a few people navigating some pages on your site to trigger and update the twitter feed. For now I can live with this until the new version comes out and the issue is addressed.

djinc01’s picture

same issue... Tweets aren't being updated using Global Account. I was able to successfully import new tweets once with a manual cron run & clearing the cache, but that has ceased working.

aren cambre’s picture

Status: Closed (won't fix) » Active

I am reopening because of no apparent progress on the 3.x module in many months and #905508: Is this module supported?. Not clear what is going on.

Gilneas’s picture

Having a similar problem. Retweets do not appear. But normal tweets do.
Sometimes the error message "400 Bad Request" is written to log on cron run.

Is this a new or the same issue as described?

Did anyone test the 3.0-beta2 version of the module? - Is it a "stable enough to install"-version?

aren cambre’s picture

I've updated #905508: Is this module supported? with a more shrill request for this module's maintainers to step up and at least communicate a plan to us.

naught101’s picture

Version: 6.x-2.6 » 6.x-3.x-dev

This is still occurring for me in 6.x-3.0-beta3. Have a global user set up for user 3, import is selected, have run cron plenty, but user/3/tweets is empty, no errors, and twitter views are also empty.

The single row in the `twitter_users` table looks fine, but the `twitter` table is completely empty, even though there definitely have been tweets since the user was added.

edit: twitter user description and image are correctly downloaded. Have tried deleting and re-creating the account.

michaek’s picture

I also encountered this error a few weeks ago with the 6.3 dev release. One of my co-workers confirmed he had the same issue today. I have not had a chance to troubleshoot, but I will attempt to see what the problem is.

michaek’s picture

I'm not able to reproduce this currently, but I'll keep an eye on it.

naught101’s picture

I'm happy to try debugging, but I'm not familiar with the code, so pointers would be good.

michaek’s picture

This issue may be resolved - the best way to contribute to it is just to grab the current dev release and see if it works for you. If it doesn't, let me know by updating the issue, and I might be able to point you in the right direction. Thanks for pitching in!

naught101’s picture

No, doesn't work for me. Just updated to the latest -dev, updated the database, ran cron a few times, cleared all caches, and tried re-saving accounts. No joy. Any debugging directions would be helpful.

venusrising’s picture

This no longer works at all. Tweets never get updated anymore.

michaek’s picture

Hi, folks.

A good starting point is:

twitter_cron() - twitter.module line 103
twitter_fetch_user_timeline() - twitter.inc line 116

Hopefully we can determine if you're getting anything back from Twitter at all. Also, we can rule out quickly whether or not the system setting twitter_import is set to true. If not, nothing will happen upon cron, by design. :)

One other thing I would add is that Twitter (mysteriously) has two interfaces for adding apps for use with OAuth. One works correctly, one doesn't. Maybe that could make a difference here? #1164568: Posting problems? Link on settings page to twitter is wrong.

If you're just trying to read tweets (not write them) the module now supports that without OAuth, but the interface needs some work. To set up a Twitter account that way, you'd need to disable the OAuth module and re-create your twitter account in Drupal. #1133722: Showing tweets without authentication

Vector9’s picture

I just setup the twitter and Oauth modules, and was getting nothing after adding a twitter account to the user I wanted to associate the twitter account with.

Went to make a view, and set the filter to pull tweets from said user.

Nothing.

Looked in the database, and noticed that the twitter_account table had a uid value of 1 (the admin user I was logged in with) rather than 16 (the uid of the user I attached the twitter account to).

Looks like the twitter_account uid value is derived from the current logged in user, not the user that is being edited. I logged out as admin, logged in as intended twitter user, relinked the twitter account, and now everything works as intended.

michaek’s picture

Thanks, @Vector9 - it seems like part of what you're describing should be a new issue: the twitter account is associated with the wrong user.

naught101’s picture

ok, NOW we're getting somewhere.
I ran $ drush ev 'module_load_include("inc", "twitter"); print_r(twitter_fetch_user_timeline(310864529));', which is one of the twitter_ids from the {twitter_account} table, and now my {twitter} table is populated. I Confirmed this with a second account. So it looks like twitter_fetch_user_timeline() is not being called where it should, somewhere..

But tweets still don't show up on user/3/tweets

I'll keep poking around

naught101’s picture

Hrm.. I take that back, some tweets are appearing at user/3/tweets, but only for one account (the global one, attached to user1)

michaek’s picture

Interesting! I wish I could take part in this debugging right now! Currently engaged in baby-calming. :)

naught101’s picture

I'll be here all day (GMT+10), jump on IRC and ping me if you have ideas for what I should look at.

michaek’s picture

Sadly, it's bedtime for me - I'll check in tomorrow morning (GMT-5). Do the tweets have the wrong user id in the db? If not, maybe it's something to do with the view configuration?

neorg’s picture

Just subscribing.

Same problem here. No update of the timeline at all.

michaek’s picture

Hi, folks. Sorry to have dropped off for a while!

@naught101: Are you able to retrieve tweets successfully if you create the account on the admin user, when logged in as the admin user? I haven't been able to reproduce the error yet, so I'm still trying to identify where it occurs.

michaek’s picture

Status: Active » Postponed (maintainer needs more info)
StatusFileSize
new436 bytes

Here's a patch that ensures you're creating a Twitter account for the correct user (regardless of whether you're logged in as them or not). I'm also pushing this to dev.

Let me know if this resolves any of your issues - that should help me track down what's going on.

steinmb’s picture

Priority: Critical » Major

Is this still an issue with latest version?

naught101’s picture

Priority: Major » Critical

hi michaek, sorry for the long delay. side-tracked by other projects.

No, the latest version (with the above patch included) doesn't fix the problem. I updated, cleared cache, ran cron, no new tweets (newest was from when I last posted here). When I run the drush command in #56, I get all the recent tweets. Looks like twitter_fetch_user_timeline() isn't getting called when it should?

steinmb’s picture

Is this installation one you upgraded from Twitter 6.x-2.x? Have you tried to reinstall the module?

naught101’s picture

No, as I said in #46, this was originally a 3.x-beta3 install, upgraded from that.

steinmb’s picture

You forgot to answer this - have you tried to reinstall the module?

naught101’s picture

I just did now, exactly the same behaviour. No tweets until I manually run twitter_fetch_user_timeline(25027307).

naught101’s picture

Hrm. Ok, "Import Twitter statuses" was switched off by default, and after disable/uninstall/reinstall, I didn't turn it on again. I just turned it on, and tweets were pulled for a different account on cron. Not entirely sure if that means it's fixed. I'll keep an eye on this issue, and report back if it's still not working.

btw. Uninstalling twitter_post doesn't remove it's settings...

naught101’s picture

Status: Postponed (maintainer needs more info) » Fixed

Appears to be working as intended now. Thanks!

juampynr’s picture

As a conclusion for affected users: please upgrade to the latest stable beta and then review permissions and settings.

Cheers

steinmb’s picture

Regarding the uninstall bug you mention in #70, there is a pending patch for that #493766: Clean up variables on uninstall. Help us test/verify this so we can get this committed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.