Hi there,

i've got a mysql error on the url /station/programs ...
maybe i do/did something wrong, but i tried the 'stable' version and the dev version. both comes with this error.

    * user warning: Unknown table 'radio_station_schedule' in where clause query: SELECT count(node.nid) FROM radio_node node LEFT JOIN radio_station_schedule station_schedule ON node.nid = station_schedule.program_nid LEFT JOIN radio_station_program station_program ON node.vid = station_program.vid WHERE (node.type IN ('program')) AND (node.status = '1') AND (radio_station_schedule.program_nid IS NOT NULL) in /home/radio/domains/MYDOMAIN.com/public_html/includes/database.mysql.inc on line 172.

    * user warning: Unknown table 'radio_station_schedule' 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 radio_node node LEFT JOIN radio_station_schedule station_schedule ON node.nid = station_schedule.program_nid LEFT JOIN radio_station_program station_program ON node.vid = station_program.vid WHERE (node.type IN ('program')) AND (node.status = '1') AND (radio_station_schedule.program_nid IS NOT NULL) ORDER BY node_title ASC LIMIT 0, 50 in /home/radio/domains/MYDOMAIN.com/public_html/includes/database.mysql.inc on line 172.

i took a look in the mysql database and the tables are present, so what's the error?

Thanks

Andreas

CommentFileSizeAuthor
#5 station_210966.patch826 bytesdrewish

Comments

CyberCore’s picture

i forgott to say:

Drupal Version 5.6

Views 5.x-1.6

any ideas?

drewish’s picture

Category: support » bug
Priority: Critical » Normal

humm, looks like a problem with the table prefixing...

drewish’s picture

Status: Active » Needs review

try this out and let me know if it helps. you'll probably need to clear your views cache for the change to stick.

CyberCore’s picture

didn't see any files? or patches? sorry i'm new here.

drewish’s picture

StatusFileSize
new826 bytes

no, i just forgot to attach the patch

CyberCore’s picture

it works. no more mysql errors.

thank you.

if there where more errors, when i put in data, i'll cry.

so nice work and thanks.

drewish’s picture

Status: Needs review » Fixed

great, committed to DRUPAL-5.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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