I just moved my station's site. I didn't disable the module during the move and it wasn't working properly after the move. I disabled all the components, re-enabled, and things seemed okay, except for programs. The programs are still there and they appear in the schedule, but station/programs shows nothing scheduled or unscheduled. Any advise on correcting this?

Here's a log entry:

Unknown column `drpl_station_schedule.program_nid` in `where clause` query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, station_program.genre AS station_program_genre FROM drpl_node node LEFT JOIN drpl_station_schedule station_schedule ON node.nid = station_schedule.program_nid LEFT JOIN drpl_station_program station_program ON node.vid = station_program.vid WHERE (node.type IN (`program`)) AND (node.status = `1`) AND (drpl_station_schedule.program_nid IS NOT NULL) AND (UPPER(node.title) NOT LIKE UPPER(`%The Five O\` Clock Frank%`)) AND (UPPER(node.title) NOT LIKE UPPER(`%Indie music%`)) ORDER BY node_title ASC LIMIT 0, 50 in /home/username/drupal/includes/database.mysql.inc on line 172.

Comments

drewish’s picture

drewish commented

did you copy all the tables over? also did you use the same version of the module? you might want to make sure you ran the update.php script.

thumb’s picture

thumb commented

Yes, all tables are present and I did use the same version of the module. I sure I ran the right update.php. I have a little time to work on this and am sure I'll get it worked out this weekend.

Schedule's are now nodes, right?

thumb’s picture

thumb commented
Status: Active » Closed (fixed)

Everything is okay after upgrading to 5.x-1.5 and rebuilding station/programs/scheduled view.