#8 Unknown column 'nuke_jobaccounts.company

[Michael Soracchi]

ERROR nuke_jobaccounts.company filed does not exist

The Table name is correct there is just no filed with that
name in the table.

It is true there is no attribute called company in the
jobaccounts table.
*****************************************
Is the SQL select statement wrong?
or
Is the attribute supposed to be in the jobaccounts table
and the field is just missing?
*****************************************

Is there code in the app to update and manage the
jobaccounts.company table if that is in fact missing?

SELECT nuke_joblisting.designation,
nuke_joblisting.jcode, nuke_jobdepartment.department,
nuke_joblocation.location, nuke_jobsalary.salary,
nuke_joblisting.responsibilities,
nuke_joblisting.qualifications, nuke_joblisting.cname,
nuke_joblisting.cmail, nuke_joblisting.posted,
nuke_joblisting.hits, nuke_jobaccounts.company FROM
nuke_jobdepartment, nuke_joblisting, nuke_joblocation,
nuke_jobsalary, nuke_jobaccounts WHERE
nuke_jobdepartment.id = nuke_joblisting.fk_department
AND nuke_joblocation.id = nuke_joblisting.fk_location
AND nuke_jobsalary.id = nuke_joblisting.fk_salary AND
nuke_joblisting.cname = nuke_jobaccounts.user AND
nuke_joblisting.jcode = '2'

[Tim Rice]

Logged In: YES
user_id=601701

Same error here. Added a company column to the joblisting table and everything works fine. I'm still not sure where the company column gets entered, though...