I'm getting these three warnings on some pages (eg. when I go on /user/1/edit/twitter):

user warning: Unknown column 'uid' in 'where clause' query: SELECT * FROM twitter_account WHERE uid = 1 in /public_html/sites/all/modules/twitter/twitter.module on line 213.

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 /public_html/sites/all/modules/views/includes/view.inc on line 705.

user warning: Unknown column 'twitter_account.uid' in 'on clause' query: SELECT twitter.twitter_id AS twitter_id, 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, 5 in /public_html/sites/all/modules/views/includes/view.inc on line 731.

The {twitter_account} table doesn't have a uid field, but a twitter_uid field.

How can I solve this?
There are no update available for Twitter: have you changed the field name recently?

Thanks in advance, Giovanni

Comments

Antinoo’s picture

Antinoo commented
Status: Active » Closed (fixed)

I was getting also other errors, so I deleted the v6.x-3.x-dev and installed the last stable release, and now it all works good.

I think the dev release is completely unusuable at the moment.

I'll close this issue.

LynnS’s picture

LynnS commented

I am getting this error on 2.6, not 3.

karlmc15’s picture

karlmc15 commented

you installed other version of twitter, and then install orther version

fix this:

- uninstall twitter module
- go phpmyadmin:
+delete 3 table :twitter twitter_account , and :-?? i dont remember its may be twitter_...??
+search in phpmyadmin,on your database with key:"twitter", and delete all record not used... it dangeruted <===:X

-re-install new twitter module

it work for me:P

nice day

trentwyman’s picture

trentwyman commented

I was able to resolve my error within Drupal without going to PhpMyAdmin.
Here are the steps that resolved the error for me.

1) I disabled the Twitter module(s) from the Modules List page (/admin/build/modules/).
2) I then clicked the "Uninstall" tab shown at the top of the Modules List page (/admin/build/modules/uninstall/).
3) On the Uninstall page, I checked the box next to "Twitter" within the "Uninstall" column and then clicked the "Uninstall" button.
4) Next, I re-enabled the Twitter module(s) on the Modules List page (/admin/build/modules/).
5) Finally, I restored the settings for Twitter posting (/admin/settings/twitter/).