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
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | station_210966.patch | 826 bytes | drewish |
Comments
Comment #1
CyberCore commentedi forgott to say:
Drupal Version 5.6
Views 5.x-1.6
any ideas?
Comment #2
drewish commentedhumm, looks like a problem with the table prefixing...
Comment #3
drewish commentedtry this out and let me know if it helps. you'll probably need to clear your views cache for the change to stick.
Comment #4
CyberCore commenteddidn't see any files? or patches? sorry i'm new here.
Comment #5
drewish commentedno, i just forgot to attach the patch
Comment #6
CyberCore commentedit 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.
Comment #7
drewish commentedgreat, committed to DRUPAL-5.
Comment #8
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.