How to get tweets imported

The tweets are updated by running the cron. If you don't have your site set up to periodically run the cron.php file the tweets will not update (unless you run the cron manually each time from admin/reports/status )

I'm having the same problem. I don't actually do any posting to the site from Drupal. I'm currently only using it to pull in existing tweets. When I run cron, I'm not seeing any new statuses imported. I must be doing something wrong, but I'm just not sure what it is.

Wait, I think we did get statuses on the automated cron run today. Weird.

Well, it's not pulling mine in whether cron runs automatically or manually.

I'm having the same problem. It sends the status to Twitter, but it is not importing anything running a manual cron. I'm also going to the view and testing the user argument and its not working.

I've got mine to work by taking out the twitter login under the global settings. I only have one user so I thought that would be best. I added it to the user settings edit twitter account. After running CRON it brought the updates.

That didn't work for me...

Note: I am able to post Twitter updates just fine.

Mine posted Twitter updates just wouldn't pull the twitter messages to drupal site. It only fetches updates after a cron run. The only other thing I did was remove the argument from the view, because I only have one twitter user for the site. I'm not sure if I actually had to remove the argument, because I did that while troubleshooting them not displaying. Hope that helps.

I don't have any arguments defined. Am I the only one experiencing this bug?

I was having a similar issue, able to post but not have it import. In fact, it would list the account under the Twitter page, but it wouldn't even import the icon.

Having read the messages above, I removed the account name from the Twitter config page. When I returned to the Twitter pane on account page, it prompted me for an account as though none had been loaded before. I put in the account information, and this time it loaded the picture and my tweets.

Went back to the global Twitter config and put the account information back in there. I'll have to see if everything continues to work properly.

Seems like it's getting the account information mixed up somehow, which is especially bizarre in my case since I was using the same account in both places.

It looks like using a custom view does not pick up on new tweets.
Using the view that came with the module, new tweets show up as soon as cron is run.
I modified the view to use my username as a default value.

I'm having the same problem - custom view not importing new tweets

Same here, latest DEV version. Tested everything, and it's still just not quite working right. It imports when it's being created for the first time, or the import is checked when FIRST adding the account, but not after that.

Scratch that....

I fixed the problem when comparing my custom view to the default one.... the only things that I had left out was the argument (dont need it in my case) and the sort criteria.

As soon as I add in to sort by twitter: created time, whoa! there they are... so it was importing my tweets, just hiding them somewhere odd in the list of tweets.

I got same error with 6.x-2.4, so I finally installed 6.x-2.x-dev. It didn't work fine neither (only imported one event), but at least this time I got an error running cron that guided the to solve the problem. It only imports one tweet because there is a bad definition in table "twitter": twitter_id is defined as BIGINT UNSIGNED, and twitter IDs are negative (as least as the function get them) so it assigns a 0 to the first one; and the others fail because it tries to assign a zero and then new inserts fail as duplicated. You just need to change twitter_id to signed (easy to do through phpmyadmin for example) and it will work sharp.

Greetings

I tried changing twitter_id using phpmyadmin, but "signed" isn't a choice for me. I'm kind of stuck still, thanks.

In my PHPmyadmin, twitter_id is VARCHAR and attributes field is blank. "signed" is not an option there.
Changed it to BIGINT and it didn't make any difference.

Here's what resolved it for me:
1. Went to Twitter module settings, removed global account, saved
2. Set up account just for site Twitter feeds, called it Liveblog
3. Set up Liveblog useracct to use the site Twitter account.. (entered Twitter acct & pwd in profile)
4. Deleted my custom Tweets view and switched to the default
5. Since I'm using Quicktabs, I put the Liveblog UID in my quicktab as an argument... I'm sure this could be done in the View itself if you wanted to.

This works find for getting Tweets imported... but of course, there was then no global account for my editors to post tweets to.

6. Went back to Twitter mod. settings and put same Twitter acct info that Liveblog acct. is using.

So far, new Twitter posts show up almost immediately and new nodes fed to Twitter show up in the View when I run cron.

So it's all working for me now as long as I use a uid-argument View. So the short version of this post is probably this: "Tweet views absolutely require uid argument." But I can't quite prove that.

OK, it stopped working. As far as I can tell, neither custom or non-custom views import tweets.

Edit: removed Twitter account from Drupal account ("Liveblog")
Configured another Drupal accout for the Twitter.
Changed the argument UID in the Quicktab.
All the tweets updated. But my money say they'll stay as they are until I repeat these steps with another account. So... no idea why this is behaving this way.

+1
6.x-2.5
Cron successfully brings the tweets into the database. Views (global and user) display nothing.

In the view preview area, all three (tweets, block, page) say that no query was run. I haven't looked yet, but I wonder if one of the views plugins/handlers wasn't correctly switched to 'twitter_id'.

Now that you mention it, when I was building custom Views for the tweets... (and even when I just attempted to tweak the default a bit), when I tried to preview the changes, I would get "no query was run."
Didn't occur to me that the problem could be related. Maybe we're looking at a Views integration issue then.

Same here. Using poormanscron every 5 mins but twitter updates do not appear regularly. Seems like sometimes they show, other times they dont...

Having same issue using arguments or not. Nothing shows. Also I used Panels to show the Tweets "block" and also tried to use custom views to do this in the same page also.

At that page I get this error: user warning: Unknown column 'twitter_account.uid' in 'on clause' query:

now, when I look in the Db, I see table 'twitter_account' but the field with closest name is "twitter_uid"

I tried to remove the twitter_ from the field name and the error disappears, but still no messages get pulled.

:(

I think I have the solution so far:

change the table as mentioned before, add an argument of user name and include "All" of not found, then in my panels page, use the "page" view.

So far, so good.

Hi All,
After days of frustration, I discovered a module call 'poormanscron' http://drupal.org/project/poormanscron executes cron every 60min. Seem to work.

I'm just chiming in. The first time I previewed the view, it pulled in my first tweet. Subsequently, it does nothing. Doesn't pick up the profile image or any tweets other than that first one. This happens both with my custom view and an edited clone. Also, it doesn't seem to have anything to do with the global account.

OK, this may be pilot error. I deleted the twitter account under my user profile because "import" wouldn't stay checked. I then added the account again and it added with import checked and the profile image OK.

I've been having these same problems, using Twitter 6.x-2.6. I'm going to try the various solutions proposed here.
UPDATE: I figured out my problem. When I ran cron, the status report told me the simplepie.inc file was missing from FeedAPI.

"Obtain the !simplepie package from http://simplepie.org/downloads and copy simplepie.inc to the parser_simplepie directory."

I uploaded the file to the parser_simplepie folder in the FeedAPI module and all seems well... just need to keep running cron!

This issue may reflect two misconceptions.

First, a global username and account at admin/settings/twitter just tells Drupal what to use to connect to Twitter. That alone does not get tweets imported.

To get tweets, you must associate one of your users to a Twitter account. This can be configured at My account > Edit > Twitter accounts (user/id/edit/twitter). Then you must run cron. After cron is run, the tweets are put in a table, and they can then be queried from Views.

Second, tweets are not imported until cron is run.

In my case, I have a site with only 1 user (me), so I edited my user's account to add the twitter settings (again, user/id/edit/twitter). I just entered a username and selected the Import selection. Then I ran cron, and my tweets showed up.

Marked this issue as "needs review." If others agree with this finding, probably should be marked as "by design."

#652164: Module doesn't import new tweets, shows no errors--a more directed version of portions of this issue.

When I edit my user account, and go to the twitter accounts tab, the import checkbox is unchecked. If I check it and save, the checkbox gets cleared. It's not letting me set the import checkbox.

This comment http://drupal.org/node/410284#comment-2343572 works great for me.

Thanks Aren Cambre.

Oskar

In case it helps anyone else, himerus' solution worked for me.

Running cron updates my tweets (fingers crossed!)

I would like the tweets to be updated close to real-time for my views twitter feed.
Is the only way to achieve this to schedule a cron run every minute?
Are there consequences of running cron so often?

Thank you!

Interesting how the obvious gets left out. What didn't occur to me was that I needed to "add" the user name of the person I wanted to follow. It doesn't just know who you are following based on who you set up to follow at twitter. You must add them again in your My Account area.

I will attach a patch later, but here's what I have found. In the database, the field for a "protected" acocunt is a boolean integer field. Twitter returns a text "true/false". For some reason, sometimes mysql imports the "true" as "0". We should do a better check for the "protected" field.

Hello malbert75,

i need to show all recent tweets in my blog...

how can i get from twitter..

i installed twitter_pull module, i can get single user posts but i need all tweets..

if we can pls help me...

Thanks,
John

Everybody:

* Check you're running cron.
* If you're importing a protected account, you may want to edit the view to show protected tweets.
* Have a look in the {twitter} table to see if you're getting tweets saved.

#38: Yes, we either need to cast when saving the a/c or make the schema and twitteruser match more closely. Patch from here applies with a little fuzz. I can't find an existing issue for that, the patch above is from #780712: Port twitter to Drupal 7.

#39 You should refer to the twitter_pull module for help on that module.