I get the following error on a clean install of Drupal 6:
user warning: Table 'froginab_wony.station_dj' doesn't exist query: SELECT n.nid, n.title FROM node n INNER JOIN station_dj d ON n.nid = d.program_nid WHERE d.uid = 1 ORDER BY n.title in /usr/home/froginab/domains/rochambeaurecords.com/public_html/modules/station/schedule/station_schedule.module on line 462.
The table mentioned indeed does not exist. I'm not sure if this is a fault with my install or in general...?
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | station_340992.patch | 4.84 KB | drewish |
Comments
Comment #1
drewish commentedno, it's that the 6.x update is still a total work in progress. i've just committed some more fixes so hopefully that'll have hit this particular bug.
Comment #2
refreshingapathy commentedThat's what I figured. I wanted to throw up a development version just to play around with it a bit. I'll update to the newer version and see what happens. Thanks!
Comment #3
drewish commentedokay i'm going to mark this fixed. re-open if that's not hte case.
Comment #4
refreshingapathy commentedFresh install - still get the error, but a slightly higher line number this time.
user warning: Table 'froginab_wony.station_dj' doesn't exist query: SELECT n.nid, n.title FROM node n INNER JOIN station_dj d ON n.nid = d.program_nid WHERE d.uid = 1 ORDER BY n.title in /usr/home/froginab/domains/rochambeaurecords.com/public_html/modules/station/schedule/station_schedule.module on line 505.
Comment #5
drewish commentedah, thanks for following up. i've committed the attached fix.
Comment #6
refreshingapathy commentedFixes this problem with the new patch. Thanks!
Comment #7
ddysart commentedDon't know if this is related, but I'm getting the following error after enabling the schedule module:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=1 AND n.status = 1' at line 1 query: SELECT n.nid, n.title FROM node n INNER JOIN content_ f ON n.vid = f.vid WHERE f.=1 AND n.status = 1 in D:\Projects\test.wmse.org\drupal-6.8\sites\all\modules\station\schedule\station_schedule.module on line 506.
If this is separate, I'll open a new issue, but there seems to be only a table alias and no field in the first part of the where clause.
Comment #8
drewish commentedi think it's separate... it's a problem with the views support. i need to hack on it some more.
Comment #9
ddysart commentedit might not be - my whole install is borked (the modules page give me an error in some core files). I'll try re-installing, and if i see the error again, I open an new issue.