Error when running cron "Unknown column 'entities' in 'field list'" [#2623578]

I'm seeing this error in the log after updating to 7.x-5.11 from 7.x-5.8:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities' in 'field list': UPDATE {twitter} SET twitter_id=:db_update_placeholder_0, screen_name=:db_update_placeholder_1, created_time=:db_update_placeholder_2, text=:db_update_placeholder_3, source=:db_update_placeholder_4, in_reply_to_status_id=:db_update_placeholder_5, in_reply_to_user_id=:db_update_placeholder_6, in_reply_to_screen_name=:db_update_placeholder_7, truncated=:db_update_placeholder_8, entities=:db_update_placeholder_9 WHERE ( (twitter_id = :db_condition_placeholder_0) ); Array ( [:db_update_placeholder_0] => xxxxxxxx [:db_update_placeholder_1] => xxxxxxxx [:db_update_placeholder_2] => xxxxxxx [:db_update_placeholder_3] => @xxxxxxx - #Bureaucrats drive you round the bend & make you cross? #M23Law & #InYourDefence defend #motorists & common sense. [:db_update_placeholder_4] => <a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a> [:db_update_placeholder_5] => xxxxxxxxxxxx [:db_update_placeholder_6] => xxxxxxxx [:db_update_placeholder_7] => xxxxxx [:db_update_placeholder_8] => 0 [:db_update_placeholder_9] => a:4:{s:8:"hashtags";a:4:{i:0;a:2:{s:4:"text";s:11:"Bureaucrats";s:7:"indices";a:2:{i:0;i:19;i:1;i:31;}}i:1;a:2:{s:4:"text";s:6:"M23Law";s:7:"indices";a:2:{i:0;i:79;i:1;i:86;}}i:2;a:2:{s:4:"text";s:13:"InYourDefence";s:7:"indices";a:2:{i:0;i:93;i:1;i:107;}}i:3;a:2:{s:4:"text";s:9:"motorists";s:7:"indices";a:2:{i:0;i:115;i:1;i:125;}}}s:7:"symbols";a:0:{}s:13:"user_mentions";a:1:{i:0;a:5:{s:11:"screen_name";s:15:"xxxxxxx";s:4:"name";s:19:"xxxxxxx";s:2:"id";i:302158354;s:6:"id_str";s:9:"302158354";s:7:"indices";a:2:{i:0;i:0;i:1;i:16;}}}s:4:"urls";a:0:{}} [:db_condition_placeholder_0] => xxxxxxxx ) in twitter_status_save() (line 244 of /sites/all/modules/twitter/twitter.inc).

Would really love some help on this

Comments

Comment #1

26 November 2015 at 11:30

gMaximus created an issue. See original summary.

Comment #2

gMaximus CreditAttribution: gMaximus commented 26 November 2015 at 11:32

Issue summary:

View changes

Comment #3

pixelsweatshop CreditAttribution: pixelsweatshop commented 16 May 2016 at 18:17

Priority:

Normal

» Major

Seeing this as well.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entities' in 'field list': INSERT INTO {twitter} (twitter_id, screen_name, created_time, text, source, in_reply_to_status_id, in_reply_to_user_id, in_reply_to_screen_name, truncated, entities) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 732270401875648512 [:db_insert_placeholder_1] => ABFoodBanks [:db_insert_placeholder_2] => 1463421843 [:db_insert_placeholder_3] => RT @CityFortSask: A delegation from the Fort Sask Food Gathers Society has approached Council to ask for land to build a new food bank. #FSCM [:db_insert_placeholder_4] => <a href="http://twitter.com" rel="nofollow">Twitter Web Client</a> [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => a:4:{s:8:"hashtags";a:1:{i:0;a:2:{s:4:"text";s:4:"FSCM";s:7:"indices";a:2:{i:0;i:136;i:1;i:140;}}}s:7:"symbols";a:0:{}s:13:"user_mentions";a:1:{i:0;a:5:{s:11:"screen_name";s:12:"CityFortSask";s:4:"name";s:17:"City of Fort Sask";s:2:"id";i:465677445;s:6:"id_str";s:9:"465677445";s:7:"indices";a:2:{i:0;i:3;i:1;i:16;}}}s:4:"urls";a:0:{}} ) in twitter_status_save() (line 254 of /sites/all/modules/twitter/twitter.inc).

Comment #4

tevans CreditAttribution: tevans commented 1 June 2016 at 22:20

Did you run the update scripts? I only ask because I just came across this same error after upgrading and realized I derped and forgot to run update.php. That fixed it immediately :)