hi,
i just installed the v6 dev on drupal 6.8 and it doesnt seem to have created all the needed tables; i get this error on my homepage:

* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'where clause' query: SELECT COUNT(*) FROM (SELECT 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 or 1 = 1)) AND (DATE_FORMAT(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), '%Y-%m-%d\T%H') <= '2008-12-13T03') ) count_alias in /var/www/drupal6/sites/all/modules/views/includes/view.inc on line 697.
* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'field list' query: SELECT 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 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 or 1 = 1)) AND (DATE_FORMAT(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), '%Y-%m-%d\T%H') <= '2008-12-13T03') ORDER BY node_data_field_station_playlist_date_field_station_playlist_date_value DESC LIMIT 0, 10 in /var/www/drupal6/sites/all/modules/views/includes/view.inc on line 723.

CommentFileSizeAuthor
#4 station_346479.patch3.54 KBdrewish
#3 station_346479.patch1.21 KBdrewish
#2 station_346479.patch0 bytesdrewish

Comments

jjbarrows’s picture

jjbarrows commented

oops, sorry, that error was at the station-->playlsits page. the error reported at the homepage is:

* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'field list' query: SELECT 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_data_field_station_playlist_date.nid AS node_data_field_station_playlist_date_nid, node.type AS node_type 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 or 1 = 1)) AND (DATE_FORMAT(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), '%Y-%m-%d\T%H') > '2008-12-13T03') ORDER BY node_data_field_station_playlist_date_field_station_playlist_date_value DESC in /var/www/drupal6/sites/all/modules/views/includes/view.inc on line 727.
* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'where clause' query: SELECT COUNT(*) FROM (SELECT 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 or 1 = 1)) AND (DATE_FORMAT(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), '%Y-%m-%d\T%H') <= '2008-12-13T03') ) count_alias in /var/www/drupal6/sites/all/modules/views/includes/view.inc on line 697.
* user warning: Unknown column 'node_data_field_station_playlist_date.field_station_playlist_dat' in 'field list' query: SELECT 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_data_field_station_playlist_date.nid AS node_data_field_station_playlist_date_nid, node.type AS node_type 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 or 1 = 1)) AND (DATE_FORMAT(FROM_UNIXTIME(node_data_field_station_playlist_date.field_station_playlist_date_value), '%Y-%m-%d\T%H') <= '2008-12-13T03') ORDER BY node_data_field_station_playlist_date_field_station_playlist_date_value DESC LIMIT 0, 10 in /var/www/drupal6/sites/all/modules/views/includes/view.inc on line 723.
* user warning: Table 'drupal6.station_playlist' doesn't exist query: SELECT COUNT(nid) FROM station_playlist sp WHERE sp.program_nid = 9 in /var/www/drupal6/sites/all/modules/station/playlist/station_playlist.module on line 87.

drewish’s picture

drewish commented
Component: Other » Playlists
Status: Active » Needs work
StatusFileSize
new station_346479.patch0 bytes

Was this an upgrade or a clean installation? I think all the correct tables are being created it's just that some of the code is still referering to tables and columns that have been removed. The attached patch should fix the last error you listed in comment #2.

Which version of the date module do you have installed?

drewish’s picture

drewish commented
StatusFileSize
new station_346479.patch1.21 KB

last patch was empty.

drewish’s picture

drewish commented
Status: Needs work » Fixed
StatusFileSize
new station_346479.patch3.54 KB

I've committed the attached which should fix some of it. I think the other problems are views and date related. Make sure you've got the latest versions of both installed.

Please re-open the issue if you're still seeing the problem.

jjbarrows’s picture

jjbarrows commented

cheers! installed the new version of station and fixed the errors (i already had uptodate version of everything else)

drewish’s picture

drewish commented

great! i just rolled an unstable release to make testing easier: http://drupal.org/node/347649
it includes this fix.

Status: Fixed » Closed (fixed)

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