Hi All,
After installing the module and adding a twitter feed and facebook rss feed I keep getting these errors after running cron job. Does anyone have any suggestions for me? Thanking you all in advanced

# ser warning: Unknown column 'changed' in 'field list' query: SELECT nid, changed FROM activitystream WHERE guid = 'c2ddeb746d2ac5ba7c846134aea3d8d3' in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.
# user warning: Unknown column 'changed' in 'field list' query: INSERT into activitystream (nid, module, guid, link, data, changed) VALUES (29,'activitystream_twitter', 'c2ddeb746d2ac5ba7c846134aea3d8d3','http://twitter.com/clintjb/statuses/940216104','a:2:{s:7:\"favicon\";s:30:\"http://twitter.com/favicon.ico\";s:9:\"feedtitle\";s:17:\"Twitter / clintjb\";}', 1222756425) in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.
# user warning: Unknown column 'changed' in 'field list' query: SELECT nid, changed FROM activitystream WHERE guid = 'a4ccc9bc69731aefd2bb528bb059b95e' in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.
# user warning: Unknown column 'changed' in 'field list' query: INSERT into activitystream (nid, module, guid, link, data, changed) VALUES (30,'activitystream_twitter', 'a4ccc9bc69731aefd2bb528bb059b95e','http://twitter.com/clintjb/statuses/940204815','a:2:{s:7:\"favicon\";s:30:\"http://twitter.com/favicon.ico\";s:9:\"feedtitle\";s:17:\"Twitter / clintjb\";}', 1222756425) in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.
# user warning: Unknown column 'changed' in 'field list' query: SELECT nid, changed FROM activitystream WHERE guid = 'b041bb9180acad8de978197462390216' in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.
# user warning: Unknown column 'changed' in 'field list' query: INSERT into activitystream (nid, module, guid, link, data, changed) VALUES (31,'activitystream_feed', 'b041bb9180acad8de978197462390216','http://www.facebook.com/minifeed.php?status&id=544541246#1222753856','a:2:{s:7:\"favicon\";s:35:\"http://www.facebook.com/favicon.ico\";s:9:\"feedtitle\";s:35:\"Clint Birds Facebook Status Updates\";}', 1222756425) in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.
# user warning: Unknown column 'changed' in 'field list' query: SELECT nid, changed FROM activitystream WHERE guid = '25944a9fe6d279474b6fadbacad46e28' in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.
# user warning: Unknown column 'changed' in 'field list' query: INSERT into activitystream (nid, module, guid, link, data, changed) VALUES (32,'activitystream_feed', '25944a9fe6d279474b6fadbacad46e28','http://www.facebook.com/minifeed.php?status&id=544541246#1222753245','a:2:{s:7:\"favicon\";s:35:\"http://www.facebook.com/favicon.ico\";s:9:\"feedtitle\";s:35:\"Clint Birds Facebook Status Updates\";}', 1222756425) in C:\xampp\htdocs\tank\includes\database.mysql.inc on line 172.

Comments

akalsey’s picture

akalsey commented
Status: Active » Closed (duplicate)

Duplicate of #299534: Getting sql error on node pages

This was a bug that's fixed in the latest release. You'll need to completely uninstall Activity Stream and reinstall it. See http://drupal.org/node/299534#comment-1036720 for details and instructions.

jinky32’s picture

jinky32 commented

I'm having this problem too with the latest version of drupal 6. the link above shows a page talking about 5.x-1-3.

can anyone help?

akalsey’s picture

akalsey commented

Yes, as that issue says, this is fixed in 5.x-1.3. Users that installed 1.2 should uninstall it and install 1.3 instead.

So to solve your issue, uninstall 1.2 and then install 1.3.

jinky32’s picture

jinky32 commented

sorry if i'm being dumb, but I'm using drupal 6 - I only see 6.x-1.0-beta1.

OK, sorted by using the patch here http://drupal.org/node/308431