multiple twitter accounts causes confusion

it's possible that this is related to the problem reported here: #379678: No data added to {twitter_account} since that issue means that new twitter accounts are not added 100% correctly and in this case the delete of the not correctly created account does not remove the relevant row from the twitter_account (or twitter_user table - I can't recall) table.

Attached is a patch to dev that I claim will post to all Twitter accounts a user has where they've entered a password, but not (obviously) for those that don't have a password associated with them. (Adding a cross-reference to http://drupal.org/node/335459 )

Subscribing.

Updating the patch for 2.3. Takes into account whether the password is set for the account, so that it doesn't display an error if it fails for a password not being set (since it would definitely fail).

Updating for 2.4. This only modifies twitter.module: the twitter.inc modifications in the patch appear not to be necessary for this version.

Updating for 2.6. Adds some logic for the messages reported on successful post. It will only post a 'success' message to Drupal if there's a password set on the Twitter account. That is, since only an account with a password set can post to Twitter, it will not display a 'success' message for accounts without passwords in a user's settings.

This patch works very well for me so far. Thanks Richard.

subscribing

Still having the same problem as described above:

Add an account. Then delete the account and add another.
Drupal shows new account correctly on user page (the new account) but looking at the database tables I see the old account and all tweets from it and the old tweets from the deleted account are still there.

www.VortexVideBlog.com

patch at #6
is this still an issue in latest dev?

@robby.smith
I think so, or at least it is causing trouble for me running the latest release (by date, the beta 2 is the latest), I get multiple errors like:

user warning: Duplicate entry '0' for key 1 query: INSERT INTO d6_twitter (twitter_id, screen_name, created_at, created_time, text, source, truncated) VALUES (-10314781, 'Flipshotfilm', 'Mon Apr 26 10:05:19 +0000 2010', 1272276319, 'RT @voodoofilm RT @metroteknik: Diskettens dagar är nu officiellt räknade: Sista tillverkaren slutar sin försäljning http://bit.ly/8YAaEW', '<a href=\"http://www.htc.com\" rel=\"nofollow\">HTC Peep</a>', 0) in /users/home/spot/domains/flipshot.se/web/public/includes/common.inc on line 3477.

I did as the original poster did: First add one account, seeing it all work as it was supposed to, the deleting that account and adding a new Twitter account. It imports fine though. Edit: This is not an identical error but it looks to me to be the symptom of the same bug, somewhere...

I made a temporary solution that involved manually copying the twitter ID# into {twitter} table. Now the error message is gone.

I found this thread very useful.
However, there seem to be 2 conversations going on.
The patches that I applied made it possible for me to submit a single request and post the twitter post to multiple accounts.
The main post may not be directly related to this issue.
They appear to have a problem with deleting an account and adding a new one.
I hope this helps, I know that patch will help me.
Now I just need to find the corresponding patch that lets me select which of the multiple accounts I want the post to go to.

peace,
michael

sub

sub +1

Subscribing, greetings, Martijn

Is this only relevant for 6.x, or should it be fixed in the 7.x branch and backported?

7.x is effectively behind 6.x, as a lot of changes will need to be ported forward.

Hi
Could not find any work on this issue in the 6.x code base. Perhaps we should move this issue to 7.x to get fixed there and then backported to 6.x? This issue is about the same as #418784: Post to multiple twitter accounts

There will be some progress on this and other issues this Saturday, as we are doing a Spanish DrupalConTribute event, where all areas of the module (code, support, new features, documentation, tests) will be improved by a group of people.

http://groups.drupal.org/node/190074

Well, my Spanish is a bit rusty ;) but I was able to read some of it. This is fantastic news. Good luck with your code sprint :)

Related issue for comment http://drupal.org/node/356379#comment-2899174

http://drupal.org/node/1346744

Any luck @juampy?

Still relevant? Setting against a better version.

No progress in several months. Please re-open if you can contribute to this issue.