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...?

CommentFileSizeAuthor
#5 station_340992.patch4.84 KBdrewish

Comments

drewish’s picture

no, 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.

refreshingapathy’s picture

That'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!

drewish’s picture

Status: Active » Fixed

okay i'm going to mark this fixed. re-open if that's not hte case.

refreshingapathy’s picture

Status: Fixed » Active

Fresh 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.

drewish’s picture

Status: Active » Fixed
StatusFileSize
new4.84 KB

ah, thanks for following up. i've committed the attached fix.

refreshingapathy’s picture

Fixes this problem with the new patch. Thanks!

ddysart’s picture

Don'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.

drewish’s picture

i think it's separate... it's a problem with the views support. i need to hack on it some more.

ddysart’s picture

it 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.

Status: Fixed » Closed (fixed)

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