Just created my first program and put it in the schedule, but when I go to the program page, (although it renders) I get the following:

* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'field list' query: SELECT DISTINCT(node.nid) AS nid, node_data_field_station_playlist_date.field_station_playlist_date_value AS node_data_field_station_playlist_date_field_station_playlist_date_value, node.type AS node_type, node.vid AS node_vid FROM node node LEFT JOIN content_type_station_playlist node_data_field_station_playlist_date ON node.vid = node_data_field_station_playlist_date.vid WHERE ((node.type in ('station_playlist')) AND (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) AND (node_data_field_station_playlist_date.field_station_program_nid = 62)) AND (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), SEC_TO_TIME(-18000)), '%Y-%m-%d\T%H') > '2009-09-03T11') ORDER BY node_data_field_station_playlist_date_field_station_playlist_date_value DESC in /home/cfbusine/public_html/sites/all/modules/views/includes/view.inc on line 759.
* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'where clause' query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid FROM node node LEFT JOIN content_type_station_playlist node_data_field_station_playlist_date ON node.vid = node_data_field_station_playlist_date.vid WHERE ((node.type in ('station_playlist')) AND (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) AND (node_data_field_station_playlist_date.field_station_program_nid = 62)) AND (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), SEC_TO_TIME(-18000)), '%Y-%m-%d\T%H') <= '2009-09-03T11') ) count_alias in /home/cfbusine/public_html/sites/all/modules/views/includes/view.inc on line 729.
* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'field list' query: SELECT DISTINCT(node.nid) AS nid, node_data_field_station_playlist_date.field_station_playlist_date_value AS node_data_field_station_playlist_date_field_station_playlist_date_value, node.type AS node_type, node.vid AS node_vid FROM node node LEFT JOIN content_type_station_playlist node_data_field_station_playlist_date ON node.vid = node_data_field_station_playlist_date.vid WHERE ((node.type in ('station_playlist')) AND (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) AND (node_data_field_station_playlist_date.field_station_program_nid = 62)) AND (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), SEC_TO_TIME(-18000)), '%Y-%m-%d\T%H') <= '2009-09-03T11') ORDER BY node_data_field_station_playlist_date_field_station_playlist_date_value DESC LIMIT 0, 10 in /home/cfbusine/public_html/sites/all/modules/views/includes/view.inc on line 755.

Comments

tim.plunkett’s picture

tim.plunkett
he/him
Primary language English
Location Philadelphia
commented

'field_station_playlist_dat' looks like a typo to me.
Not sure why it's kicking that out as an error, because the queries look solid.

The issue could be caused by changes you've made to the 'station_program_playlists' view, if you've altered it.

On further inspection, I'm 90% sure that this error is in someway related to #260798: Search playlist, since all three of your views errors can be traced back to station_playlist.module, specifically $block = $view->execute_display($display_id);

So, in short, try reverting the 'station_program_playlists' view back to its default state, and try again.
If you haven't changed it, try giving some more information.
Or if you're adventurous, install Devel and turn on backtrace debugging, which will give you tons of info.

mwoodwar’s picture

mwoodwar commented

Thanks Tim. I haven't changed any of the Views, but will check to make sure it is in 'default' view....I'm afraid I would have any idea of how to do the devel/debug thing...sorry

drewish’s picture

drewish commented
Status: Active » Fixed

Yeah I'm not sure why you'd get that error. Might have been the order that modules were installed or something like that. First thing I'd try is upgrading to the new release. If that doesn't help uninstall and re-install the station program module.

Status: Fixed » Closed (fixed)

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