#2 2.5 Stand-Alone Bug

[Anonymous]

There is a missing column (company) in the jobaccounts
table which causes any listing of the job to crash, i.e.

Error in query: SELECT jobpro_joblisting.designation,
jobpro_joblisting.jcode,
jobpro_jobdepartment.department,
jobpro_joblocation.location, jobpro_jobsalary.salary,
jobpro_joblisting.responsibilities,
jobpro_joblisting.qualifications, jobpro_joblisting.cname,
jobpro_joblisting.cmail, jobpro_joblisting.posted,
jobpro_joblisting.hits, jobpro_jobaccounts.company
FROM jobpro_jobdepartment, jobpro_joblisting,
jobpro_joblocation, jobpro_jobsalary,
jobpro_jobaccounts WHERE jobpro_jobdepartment.id =
jobpro_joblisting.fk_department AND
jobpro_joblocation.id = jobpro_joblisting.fk_location AND
jobpro_jobsalary.id = jobpro_joblisting.fk_salary AND
jobpro_joblisting.cname = jobpro_jobaccounts.user AND
jobpro_joblisting.jcode = '2'. Unknown
column 'jobpro_jobaccounts.company' in 'field list'