Module installed, Added Flicker API Key. Put usernames for flickr, delicious, & last.fm. Cron ran and downloaded nodes. I can go to content and see them. They are not showing up on my profile page and when I go into the node I get the following error.

* warning: Invalid argument supplied for foreach() in /var/www/ontheoffbeatcom/modules/node/node.module on line 561.
* warning: implode() [function.implode]: Bad arguments. in /var/www/ontheoffbeatcom/modules/node/node.module on line 565.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /var/www/ontheoffbeatcom/includes/database.mysql.inc on line 172.

It does have the information, just shows the error also. I'm running 5.10 Drupal.

CommentFileSizeAuthor
#3 SQLActivityStreamErrors.txt41.11 KBhalo1982

Comments

shunshifu’s picture

shunshifu commented

I am getting the same error. Also some strange behavior. Activity stream content shows up in views and then doesn't

akalsey’s picture

akalsey commented
Status: Active » Postponed (maintainer needs more info)

Are there any errors in the Drupal log? It sounds like perhaps the nodes aren't being created.

halo1982’s picture

halo1982 commented
StatusFileSize
new SQLActivityStreamErrors.txt41.11 KB

I'm getting the same error. Nodes are being created, but everytime cron runs I get this error and in the block view and /user/*/stream both show "no activities"

rleatherwood’s picture

rleatherwood commented
Category: support » bug

I get the same errors.

akalsey’s picture

akalsey commented

In order to troubleshoot this, someone's going to have to answer the question I asked above: Are there any errors in the Drupal log? It sounds like perhaps the nodes aren't being created.

shunshifu’s picture

shunshifu commented

Here's the error in my drupal log

Unknown column 'changed' in 'field list' query: INSERT into activitystream (nid, module, guid, link, data, changed) VALUES (56,'activitystream_digg', '44bf7aa744db6b42a0912b076651e923','http://digg.com/world_news/Children_Should_be_Seen_Not_Heard','a:2:{s:7:\"favicon\";s:27:\"http://digg.com/favicon.ico\";s:9:\"feedtitle\";s:26:\"digg / shunshifu / history\";}', 1222664707) in /home/buzzbar3/public_html/includes/database.mysql.inc on line 172.

akalsey’s picture

akalsey commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

After upgrading any modules, it's important to run /update.php

That's how modules notify Drupal about changes to their database tables. Until you've run it, you're not done updating a module.

Run update.php and this issue will go away.

akalsey’s picture

akalsey commented
Status: Closed (won't fix) » Active

It looks like the current release of Activity Stream doesn't create this column on the initial install, just on update.

A new release will be out in an hour or two with a fix. In the meantime you can run this database command to fix the problem...

ALTER TABLE {activitystream} ADD COLUMN `changed` int(11) NOT NULL default '0';

Replace {activitystream} with the name of your activity stream table (It's probably just "activitystream" unless you have a database table prefix set up in Drupal.

shunshifu’s picture

shunshifu commented
Status: Active » Postponed (maintainer needs more info)

Thanks for the sql command.

FYI it was a new install not an upgrade.

Thanks again your module rocks

Phil

shunshifu’s picture

shunshifu commented

but now cron stalls out. After running it several times I get this

* warning: fopen(/tmp/93caf0a01efc24afc31a50578960d556.spc) [function.fopen]: failed to open stream: Permission denied in /home/buzzbar3/public_html/sites/all/modules/activitystream/activitystream_feed/simplepie.inc on line 8254.
* user warning: /tmp/93caf0a01efc24afc31a50578960d556.spc is not writeable in /home/buzzbar3/public_html/sites/all/modules/activitystream/activitystream_feed/simplepie.inc on line 1769.
* warning: fopen(/tmp/15f713f0d4ea57ee1c2a48a2c4ceb2ee.spc) [function.fopen]: failed to open stream: Permission denied in /home/buzzbar3/public_html/sites/all/modules/activitystream/activitystream_feed/simplepie.inc on line 8254.
* user warning: /tmp/15f713f0d4ea57ee1c2a48a2c4ceb2ee.spc is not writeable in /home/buzzbar3/public_html/sites/all/modules/activitystream/activitystream_feed/simplepie.inc on line 1769.
* warning: fopen(/tmp/9820087052eb05930a6d370aa5166f45.spc) [function.fopen]: failed to open stream: Permission denied in /home/buzzbar3/public_html/sites/all/modules/activitystream/activitystream_feed/simplepie.inc on line 8254.
* user warning: /tmp/9820087052eb05930a6d370aa5166f45.spc is not writeable in /home/buzzbar3/public_html/sites/all/modules/activitystream/activitystream_feed/simplepie.inc on line 1769.

akalsey’s picture

akalsey commented

Make sure the temp directory set in your Drupal settings is writable by the web server.

akalsey’s picture

akalsey commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

This is fixed in 5.x-1-3. See http://drupal.org/node/315296

Users that installed 1.2 should uninstall Activity Stream (including running the uninstaller found by clicking on the "Uninstall" tab at the top of the modules page). They should then install this version instead.

Users who upgraded to 1.2 from a previous version are unaffected by this issue and do not need to upgrade.