Posted by cookiesunshinex on May 31, 2009 at 9:14am
Jump to:
| Project: | Station |
| Version: | 6.x-2.x-dev |
| Component: | Programs |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
I found that I could not view days of the schedule week if I was not logged in (anonymous). I got a 404.
I also found that I could not view a scheduled program on a schedule. I got a 404.
I went into the permissions and unchecked the access all programs and access all schedules for the anonymous roles (and other roles I have defined). I then clicked Save configuration, and then I went in an re-checked them, and saved the configuration again, and logged out.
This fixed the issue.
Comments
#1
Humm... which permission did you have set before the upgrade? 'access all programs' and 'access all schedules' aren't permissions provided by any of the station modules.
Roles with 'access content' permission are granted 'view station playlist content', 'view station program content', and view station schedule content' permissions as part of the upgrade.
I wonder if there's a permissions cache that needs to get cleared before those changes in the upgrade take effect. If you run the upgrade again (I'm assuming you're doing this on a test machine) could you try just saving the permissions form without making any changes and see if that has any effect?
#2
You are correct it was the "view station program content" and "view station schedule content" roles.
I also had similar behavior on some of my block titles. There were a couple of blocks whose titles didn't appear properly until I simply edited and save them. Totally unrelated to station module, but worth a mention.
#3
cookiesunshinex, do you have a pre-upgrade backup you can test my theory out on?
#4
I just created a new issue that I believe is similar to this one for 5.x-2.1
http://drupal.org/node/482148
Any help?
Let me know if you need more info. I would be happy to provide. This is severely affecting our listener's ability to view info about our shows.
Thanks,
-Mark
#5
This seems to be fixed in 6.x latest dev release after upgrading from 5.x to 6.x.
I did not have to save the permissions again like I did with the dev from 4 or 5 days ago.
#6
OK, this is weird. After going through several things on my site, putting the finishing touches on a bunch of minor issues after the upgrade.
I logged out and tested it again, and was unable to click on any of the days of the week on the schedule.
Simply editing User Access and saving DID NOT work.
I unchecked view station program content and view station schedule content and saved, and then re-checked them and then saved again and it still does not work.
So anonymous and authenticated users are not able to access the days of the week.
:(
#7
Since I haven't seen any issues updates in the past few days, I decided to play around with this a little bit.
I just upgraded my development site to the latest dev version (6.x-2.x-dev 2009-Jun-23) of the station module. When logged out (anonymous), I have no problem viewing the days of the week.
I applied the same update to my production site. However, on my production site, I still cannot view the days of the week when logged out. The sites are identical, so I'm wondering where the problem could be.
1. SQL database?
2. View?
3. ACL permissions?
How do you suggest that I go about fixing the issue for the production site?
1. I tried disabling the station-schedule module and re-enabling it, but it did nothing.
2. I tried unchecking, and then re-checking permissions for anonymous "view station program content" and "view station schedule content" but no luck.
I believe we can close this issue as it doesn't seem to be the module itself, it seems to be my particular site.
I tried running station-schedule update 6001 (using update.php) and I got these errors:
user warning: Duplicate entry 'field_station_program_dj-station_program' for key 1 query: INSERT INTO content_node_field_instance (field_name, type_name, weight, label, widget_type, widget_settings, display_settings, description, widget_module, widget_active) VALUES ('field_station_program_dj', 'station_program', 1, 'DJs', 'userreference_autocomplete', 'a:5:{s:18:\"autocomplete_match\";N;s:4:\"size\";N;s:12:\"reverse_link\";i:0;s:13:\"default_value\";a:1:{i:0;a:2:{s:3:\"uid\";N;s:14:\"_error_element\";s:59:\"default_value_widget][field_station_program_dj][0][uid][uid\";}}s:17:\"default_value_php\";N;}', 'a:5:{s:5:\"label\";a:1:{s:6:\"format\";s:5:\"above\";}s:6:\"teaser\";a:1:{s:6:\"format\";s:7:\"default\";}s:4:\"full\";a:1:{s:6:\"format\";s:7:\"default\";}i:0;a:1:{s:6:\"format\";s:5:\"above\";}s:5:\"token\";a:1:{s:6:\"format\";s:7:\"default\";}}', 'Enter the names of users you\'d like to add as DJs. The users must be members of the DJs role.', 'userreference', 1) in /home/jungle/public_html/includes/common.inc on line 3422.
The following queries were executed
station_schedule module
Update #6001
* INSERT INTO {content_field_station_program_dj} (nid, vid) SELECT n.nid, n.vid FROM {station_dj} f INNER JOIN {node} n ON f.program_nid = n.nid WHERE NOT EXISTS ( SELECT * FROM {content_field_station_program_dj} t WHERE f.program_nid = t.nid)
* UPDATE {content_field_station_program_dj} t INNER JOIN {station_dj} f ON t.nid = f.program_nid SET t.field_station_program_dj_uid = f.uid
Update #6002
* No queries
#8
It's possible that this bug is the same/related as this:
http://drupal.org/node/529998
(provides a possible solution)
Richard
#9
I figured out that this was my installation. My SQL tables were messed up.
I did a database check with phpmyadmin and found several tables screwed up, so I repaired them.
I then deleted all program and schedule data, disabled and uninstalled the station module.
I had to manually remove some of the station views afterwards.
I then found that there were still several tables in the database relating to station, so I manually deleted them.
After all of that, I downloaded the latest dev version of station, enabled it, and started from scratch.
All is fine now. No problems viewing days of the week when logged out.