When I select Station -> Program, I see the following in Red

* user warning: Unknown table 'station_schedule_item' in where clause query: SELECT count(node.nid) FROM node node LEFT JOIN station_program station_program ON node.vid = station_program.vid WHERE (node.type IN ('program')) AND (node.status = '1') AND (station_schedule_item.program_nid IS NOT NULL) in /home/skylinecomuk/public_html/drupal2/includes/database.mysql.inc on line 172.
* user warning: Unknown table 'station_schedule_item' 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 node node LEFT JOIN station_program station_program ON node.vid = station_program.vid WHERE (node.type IN ('program')) AND (node.status = '1') AND (station_schedule_item.program_nid IS NOT NULL) ORDER BY node_title ASC LIMIT 0, 50 in /home/skylinecomuk/public_html/drupal2/includes/database.mysql.inc on line 172.

My site details:

Drupal 5.3
Configuration file Protected
Cron maintenance tasks Last run 5 days 13 hours ago
You can run cron manually.
Database schema Up to date
File system Writable (public download method)
GD library 2.0 or higher
MySQL database 4.1.20
PHP 5.2.3
Unicode library PHP Mbstring Extension
Web server Apache/2.0.52 (CentOS)

Hosting: supanames.com
website: skyline.fm/drupal2 (currently trialling)

Comments

drewish’s picture

Status: Active » Closed (duplicate)

i'm pretty sure this is a duplicate of an existing issue: http://drupal.org/node/167632

please test out the patch attached to that issue.

therobyouknow’s picture

i just changed the code to use station_schedule instead and it worked