Mafaz Mazeen - 2009-08-12

Error

MySQL Query Error : select a.`emp_number`, ifnull(a.`employee_id`, lpad(a.`emp_number`, 3, 0)), a.`emp_number`, a.emp_firstname, a.`emp_number`, a.emp_lastname, a.`emp_number`, d.estat_name, n.lang_code, n.lang_name from (((hs_hr_employee a left join hs_hr_empstat d on a.emp_status = d.estat_code) left join hs_hr_emp_language m on m.emp_number = a.emp_number ) left join hs_hr_language n on m.lang_code = n.lang_code) where c.edu_code = 'edu003' group by a.`emp_number`, ifnull(a.`employee_id`, lpad(a.`emp_number`, 3, 0)), a.`emp_number`, a.emp_firstname, a.`emp_number`, a.emp_lastname, a.emp_status, m.lang_code, m.emp_number

Technical Details

Unknown column 'c.edu_code' in 'where clause' MySQL Error # :1054

System Environment

    * OrangeHRM : 2.4.2
    * PHP : 5.2.5
    * MySQL Client : 5.0.45
    * Memory limit : 96M
    * Maximum session lifetime : 1440

Please note

The error was logged in the OrangeHRM log located in /home/myvibrac/public_html/orange/lib/logs/logDB.txt

If you are unable to resolve the problem please post the problem in OrangeHRM Forum