| Project: | Activity Stream |
| Version: | 5.x-1.2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
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.
Comments
#1
I am getting the same error. Also some strange behavior. Activity stream content shows up in views and then doesn't
#2
Are there any errors in the Drupal log? It sounds like perhaps the nodes aren't being created.
#3
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"
#4
I get the same errors.
#5
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.
#6
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.
#7
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.
#8
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.
#9
Thanks for the sql command.
FYI it was a new install not an upgrade.
Thanks again your module rocks
Phil
#10
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.
#11
Make sure the temp directory set in your Drupal settings is writable by the web server.
#12
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.