I see that others have had problems with this over at http://commons.acquia.com, so I figured I'd open an issue for the specific problem.

Problem: On the /stream page, nothing shows up in the Activity Stream. Not your own status updates, nothing from your groups, etc... Nothing - just the "There are no visible status updates." message below the update window. I should note that when you add a status update, the system appears to accept it (later confirmed by looking in the database).

What I've Tried:
- I'm having the same trouble on an upgrade from 1.7 AND from a clean install...
- I followed the instructions to Clear the Cache and Re-Generate (http://network.acquia.com/book/export/html/1766907)
- I also double-checked user permissions for the Actiivty Stream (all fine)

Still - "There are no visible status updates"

I saw that people mentioned this issue related to non-English installations, but I installed the default set 2.0 GA. And, I should mention that if/when I try to confirm my language setting (/admin/settings/language), it just shows me the /admin/settings page...

Any ideas? Thanks!

Comments

dwongu’s picture

dwongu commented
Category: support » bug
ezra-g’s picture

ezra-g commented
Status: Active » Postponed (maintainer needs more info)

Thanks for the bug report. I'm unable to reproduce this issue on a fresh install of Commons 2.0 downloaded from Acquia.com.

In order to help me track down the cause of this problem, I have several questions :)

a) Can you provide the exact steps you took to reproduce? Please list which Commons feature modules you enabled during the install process.
By default, you should end up on the /stream page after the Commons installation finishes.

b) Do you have any notable errors in the dblog at admin/reports/dblog?
c) Where did you download Commons?
d) How did you extract the Commons tarball?
e) What operating system, webserver and database version and browser are you running?

And, I should mention that if/when I try to confirm my language setting (/admin/settings/language), it just shows me the /admin/settings page...

You need to enable the core Locale module to access these settings.

dwongu’s picture

dwongu commented

Hi Ezra,
Thanks for the follow-up. I'll go ahead and answer your questions one-by-one...

a) Can you provide the exact steps you took to reproduce? Please list which Commons feature modules you enabled during the install process.

I simply downloaded the latest version from Acquia, extracted the tarball, and uploaded to the server. I switched the perms for sites/default and settings.php and visited the root dir to run the installer. The installer ran without a hitch or single error, later confirmed at /reports/status.

As far as modules - I just left everything on as defaults in the installer (I believe that everything was checked except the Acquia Network opt-in).

By default, you should end up on the /stream page after the Commons installation finishes.

Yep, I did. (on both installations...) First thing I did (logged in as Admin) was attempt a status update and pressed "share". The ajax- spinner spins, and disappears, leaving the "There are no visible status updates." text.

So, then I checked out admin/user/permissions and made sure to give access to pretty much everything related to Activity Log and Facebook Statuses for all permission types. Still no status updates.

I also followed the docs for upgrading from 1.7 to 2.0, clearing the cache and regenerating - but still no luck.

b) Do you have any notable errors in the dblog at admin/reports/dblog?

Good thinking. It looks like, when I post a status update, there are four "unknown column" errors that appear... (Sorry to post them all here, but - figured they might help...)

Location http://grow.relylocal.com/stream
Unknown column 'grow_activity_log_templates.pid' in 'IN/ALL/ANY subquery' query: SELECT COUNT(*) FROM (SELECT activity_log_messages.mid AS mid FROM grow_activity_log_messages activity_log_messages LEFT JOIN grow_activity_log_templates activity_log_templates ON activity_log_messages.tid = activity_log_templates.tid WHERE (activity_log_templates.display_type = 'web') AND (activity_log_messages.stream_owner_type = 'user') AND (activity_log_messages.stream_owner_id = 1) AND (grow_activity_log_templates.pid NOT IN (SELECT pid FROM grow_activity_log_disabled_types WHERE uid = 1)) AND ( viewer_id = 0 OR viewer_id = 1 OR (viewer_id < 0 AND viewer_id <> -1) ) ) count_alias in /home/relylocal/public_html/grow/profiles/drupal_commons/modules/contrib/views/includes/view.inc on line 746.

Location http://grow.relylocal.com/stream
Unknown column 'grow_activity_log_templates.pid' in 'IN/ALL/ANY subquery' query: SELECT activity_log_messages.mid AS mid, activity_log_templates.tid AS activity_log_templates_tid, activity_log_messages.aids AS activity_log_messages_aids, activity_log_messages.created AS activity_log_messages_created, activity_log_messages.last_updated AS activity_log_messages_last_updated, activity_log_messages.stream_owner_id AS activity_log_messages_stream_owner_id, activity_log_messages.stream_owner_type AS activity_log_messages_stream_owner_type, activity_log_messages.viewer_id AS activity_log_messages_viewer_id, activity_log_messages.target_id AS activity_log_messages_target_id, activity_log_messages.target_type AS activity_log_messages_target_type, activity_log_messages.acting_uid AS activity_log_messages_acting_uid, activity_log_messages.cached AS activity_log_messages_cached, activity_log_templates.rule AS activity_log_templates_rule, activity_log_templates.action_label AS activity_log_templates_action_label, activity_log_templates.template AS activity_log_templates_template, activity_log_templates.group_template AS activity_log_templates_group_template, activity_log_templates.group_summary AS activity_log_templates_group_summary, activity_log_templates.collapse_method AS activity_log_templates_collapse_method, activity_log_templates.pid AS activity_log_templates_pid, activity_log_templates.eval_input AS activity_log_templates_eval_input, activity_log_templates.resources AS activity_log_templates_resources, activity_log_templates.cacheable AS activity_log_templates_cacheable, activity_log_templates.display_type AS activity_log_templates_display_type FROM grow_activity_log_messages activity_log_messages LEFT JOIN grow_activity_log_templates activity_log_templates ON activity_log_messages.tid = activity_log_templates.tid WHERE (activity_log_templates.display_type = 'web') AND (activity_log_messages.stream_owner_type = 'user') AND (activity_log_messages.stream_owner_id = 1) AND (grow_activity_log_templates.pid NOT IN (SELECT pid FROM grow_activity_log_disabled_types WHERE uid = 1)) AND ( viewer_id = 0 OR viewer_id = 1 OR (viewer_id < 0 AND viewer_id <> -1) ) ORDER BY activity_log_messages_last_updated DESC LIMIT 0, 20 in /home/relylocal/public_html/grow/profiles/drupal_commons/modules/contrib/views/includes/view.inc on line 772.

Location http://grow.relylocal.com/stream?ts=1315367092599
Unknown column 'grow_activity_log_templates.pid' in 'IN/ALL/ANY subquery' query: SELECT COUNT(*) FROM (SELECT activity_log_messages.mid AS mid FROM grow_activity_log_messages activity_log_messages LEFT JOIN grow_activity_log_templates activity_log_templates ON activity_log_messages.tid = activity_log_templates.tid WHERE (activity_log_templates.display_type = 'web') AND (activity_log_messages.stream_owner_type = 'user') AND (activity_log_messages.stream_owner_id = 1) AND (grow_activity_log_templates.pid NOT IN (SELECT pid FROM grow_activity_log_disabled_types WHERE uid = 1)) AND ( viewer_id = 0 OR viewer_id = 1 OR (viewer_id < 0 AND viewer_id <> -1) ) ) count_alias in /home/relylocal/public_html/grow/profiles/drupal_commons/modules/contrib/views/includes/view.inc on line 746.

Location http://grow.relylocal.com/stream?ts=1315367092599
Unknown column 'grow_activity_log_templates.pid' in 'IN/ALL/ANY subquery' query: SELECT activity_log_messages.mid AS mid, activity_log_templates.tid AS activity_log_templates_tid, activity_log_messages.aids AS activity_log_messages_aids, activity_log_messages.created AS activity_log_messages_created, activity_log_messages.last_updated AS activity_log_messages_last_updated, activity_log_messages.stream_owner_id AS activity_log_messages_stream_owner_id, activity_log_messages.stream_owner_type AS activity_log_messages_stream_owner_type, activity_log_messages.viewer_id AS activity_log_messages_viewer_id, activity_log_messages.target_id AS activity_log_messages_target_id, activity_log_messages.target_type AS activity_log_messages_target_type, activity_log_messages.acting_uid AS activity_log_messages_acting_uid, activity_log_messages.cached AS activity_log_messages_cached, activity_log_templates.rule AS activity_log_templates_rule, activity_log_templates.action_label AS activity_log_templates_action_label, activity_log_templates.template AS activity_log_templates_template, activity_log_templates.group_template AS activity_log_templates_group_template, activity_log_templates.group_summary AS activity_log_templates_group_summary, activity_log_templates.collapse_method AS activity_log_templates_collapse_method, activity_log_templates.pid AS activity_log_templates_pid, activity_log_templates.eval_input AS activity_log_templates_eval_input, activity_log_templates.resources AS activity_log_templates_resources, activity_log_templates.cacheable AS activity_log_templates_cacheable, activity_log_templates.display_type AS activity_log_templates_display_type FROM grow_activity_log_messages activity_log_messages LEFT JOIN grow_activity_log_templates activity_log_templates ON activity_log_messages.tid = activity_log_templates.tid WHERE (activity_log_templates.display_type = 'web') AND (activity_log_messages.stream_owner_type = 'user') AND (activity_log_messages.stream_owner_id = 1) AND (grow_activity_log_templates.pid NOT IN (SELECT pid FROM grow_activity_log_disabled_types WHERE uid = 1)) AND ( viewer_id = 0 OR viewer_id = 1 OR (viewer_id < 0 AND viewer_id <> -1) ) ORDER BY activity_log_messages_last_updated DESC LIMIT 0, 20 in /home/relylocal/public_html/grow/profiles/drupal_commons/modules/contrib/views/includes/view.inc on line 772.

c) Where did you download Commons?

http://network.acquia.com/downloads/drupal-commons/
- Originally the day it came out, then again this morning...

d) How did you extract the Commons tarball?

The first time I used StuffIt, but today, I just used the MacOs... Then, FTP using Fetch in binary mode... I thought about asking my host to extract at the command line for me, but read from many users that that wasn't necessary (and since I didn't receive any other errors...)

e) What operating system, webserver and database version and browser are you running

Apache/2.2.3 (CentOS)
Mysql 5.0.77
PHP 5.3.8

Locally, I'm running Mac OSX (Lion), using primarily Firefox 6.0.1, but also Chrome and Safari for testing...

One other random thing - I'm not seeing any "sessions" table in my db (via phpmyadmin, at least). Has this changed since the older (Drupal 5.x) days?

I'll admit - I'm stuck. Thanks for any help you can offer! ;^>

ezra-g’s picture

ezra-g commented

Thanks for the information, @dwongu!

I need to take a closer look at the error, but initially: Does your site use database table prefixes?

Could you paste the output of a SHOW TABLES; query here?

Thanks!

dwongu’s picture

dwongu commented

Hi @ezra-g,

Yep, we used the prefix grow_ during the install process.

Here's the output of SHOW TABLES...

grow_access
grow_actions
grow_actions_aid
grow_activity_log_action_names
grow_activity_log_disabled_types
grow_activity_log_events
grow_activity_log_messages
grow_activity_log_templates
grow_aggregator_category
grow_aggregator_category_feed
grow_aggregator_category_item
grow_aggregator_feed
grow_aggregator_item
grow_authmap
grow_batch
grow_blocks
grow_blocks_roles
grow_box
grow_boxes
grow_cache
grow_cache_block
grow_cache_content
grow_cache_filter
grow_cache_form
grow_cache_menu
grow_cache_page
grow_cache_rules
grow_cache_update
grow_cache_views
grow_cache_views_data
grow_comments
grow_contact
grow_content_field_content_images
grow_content_field_featured_content
grow_content_field_file
grow_content_field_group_sticky
grow_content_field_grouplink
grow_content_group
grow_content_group_fields
grow_content_node_field
grow_content_node_field_instance
grow_content_type_blog
grow_content_type_discussion
grow_content_type_document
grow_content_type_event
grow_content_type_group
grow_content_type_notice
grow_content_type_poll
grow_content_type_wiki
grow_context
grow_ctools_css_cache
grow_ctools_object_cache
grow_date_format_locale
grow_date_format_types
grow_date_formats
grow_digests
grow_facebook_status
grow_facebook_status_contexts
grow_facebook_status_tags
grow_fbsmp
grow_fbsmp_videos
grow_fbss_comments
grow_filefield_meta
grow_files
grow_filter_formats
grow_filters
grow_flag_content
grow_flag_counts
grow_flag_types
grow_flags
grow_flood
grow_freelinking
grow_history
grow_imagecache_action
grow_imagecache_preset
grow_invite
grow_invite_notifications
grow_menu_custom
grow_menu_links
grow_menu_router
grow_messaging_message_parts
grow_messaging_store
grow_node
grow_node_access
grow_node_comment_statistics
grow_node_counter
grow_node_revisions
grow_node_type
grow_notifications
grow_notifications_event
grow_notifications_fields
grow_notifications_queue
grow_notifications_sent
grow_og
grow_og_access_post
grow_og_aggregator_feed
grow_og_aggregator_item
grow_og_ancestry
grow_og_features
grow_og_invite
grow_og_notifications
grow_og_statistics
grow_og_subgroups
grow_og_uid
grow_password_policy
grow_password_policy_expiration
grow_password_policy_force_change
grow_password_policy_history
grow_password_policy_role
grow_permission
grow_poll
grow_poll_choices
grow_poll_votes
grow_profile_fields
grow_profile_values
grow_role
grow_rules_rules
grow_rules_sets
grow_search_dataset
grow_search_index
grow_search_node_links
grow_search_total
grow_semaphore
grow_sessions
grow_system
grow_term_data
grow_term_hierarchy
grow_term_node
grow_term_relation
grow_term_synonym
grow_term_user
grow_upload
grow_url_alias
grow_user_badges_badges
grow_user_badges_roles
grow_user_badges_user
grow_user_relationship_blocks
grow_user_relationship_type_roles
grow_user_relationship_type_roles_receive
grow_user_relationship_types
grow_user_relationships
grow_userpoints
grow_userpoints_badges
grow_userpoints_txn
grow_users
grow_users_roles
grow_variable
grow_views_display
grow_views_object_cache
grow_views_view
grow_vocabulary
grow_vocabulary_node_types
grow_watchdog
grow_wysiwyg
grow_wysiwyg_user

Here's the weird thing... When do run this output, I see the grow_sessions table (and can run queries at the command line), but it doesn't show up in the UI in phpmyadmin... (Never seen that before...)

Additionally - this isn't a production/live site... So, if you are interested, you can register, and I can set up your user as an admin if you need/want to poke around the /admin tools to make sure it isn't a setting?

http://grow.relylocal.com

Hope this helps! Thanks!

koancn’s picture

koancn commented

ezra-g is right, the problem is caused by installation with database table prefixes.
I had the same problem as dwongu,and I fixed it by reinstallation without database table prefixe.
Thanks!

ezra-g’s picture

ezra-g commented
Status: Postponed (maintainer needs more info) » Needs review

Thanks again for the fast response and detailed information. I've written a patch to the activity_log module - It would be great if you could review it! #1273288: Activity stream incompatible with table prefixes.

dwongu’s picture

dwongu commented

@ezra-g,
Nice work! The patch fixed it, instantly! (Once I figured out how/where to drop it...)

Thank you so much for your help! Seriously - nice work!

ezra-g’s picture

ezra-g commented

A similar fix was committed at #1273288: Activity stream incompatible with table prefixes from the one originally proposed - It would be great if folks could help verify that fix.

jbunyan’s picture

jbunyan commented

I had similar problem. I am using commons 2.0's status stream. Everything works great on my local server. When I uploaded the site to a live server, that's when problems came up. The log activity stream didn't show on the profile or groups page. If I change the option to show a view under the facebook status bar to something else, nothing shows up. The activity page and status stream page worked. So any status update or content creation would show on that page. I tried to regenerate the activity message and clear the cache but it didn't work. I'm thinking of uploading the newest version of the activity_log and see if that will fix it. Since the activity stream page works, I feel like there is an option that was disabled after I uploaded the site. The picture support and other options were disabled and I had to re-enable those options. So I'm not sure if there was an option that was disabled. I checked the permissions and views and they seem fine. I don't think my tables use any prefixes. Any ideas why the activity stream won't show up on the groups and profile page?

ezra-g’s picture

ezra-g commented
Status: Needs review » Fixed

I'm marking this as fixed since there's been a commit to activity_log.

If I change the option to show a view under the facebook status bar to something else

@jbunyan, this sounds like a separate issue. Please file a new issue so that we can look at it there. Thanks!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.