Cyprus & Global Jobs

Connecting Job Seekers and Recruiters in Cyprus

Database Error

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Employee.lang' in 'where clause'

SQL Query: SELECT `Employee`.`id`, `Employee`.`user_id`, `Employee`.`category_id`, `Employee`.`nationality_id`, `Employee`.`country_id`, `Employee`.`title`, `Employee`.`name`, `Employee`.`email`, `Employee`.`website`, `Employee`.`gender`, `Employee`.`birthday`, `Employee`.`driving_licence`, `Employee`.`driving_category`, `Employee`.`marital_status`, `Employee`.`children`, `Employee`.`address`, `Employee`.`town`, `Employee`.`phone`, `Employee`.`mobile`, `Employee`.`accept_sms`, `Employee`.`fax`, `Employee`.`education_level`, `Employee`.`education`, `Employee`.`employment_hours`, `Employee`.`em_fulltime`, `Employee`.`em_parttime`, `Employee`.`em_seasonal`, `Employee`.`em_remote`, `Employee`.`em_freelance`, `Employee`.`expected_salary`, `Employee`.`salary_currency`, `Employee`.`salary_type`, `Employee`.`available_start`, `Employee`.`available_start_asap`, `Employee`.`available_end`, `Employee`.`experience`, `Employee`.`personal_motivation`, `Employee`.`cv_document`, `Employee`.`cv_document_dir`, `Employee`.`created`, `Employee`.`updated`, `Employee`.`active`, `Nationality`.`id`, `Nationality`.`created`, `Nationality`.`updated`, `Nationality`.`active`, `EmployeeCategory`.`id`, `EmployeeCategory`.`category_id`, `EmployeeCategory`.`employee_id`, `EmployeeCity`.`id`, `EmployeeCity`.`city_id`, `EmployeeCity`.`employee_id`, `EmployeeLanguageRelation`.`id`, `EmployeeLanguageRelation`.`employee_id`, `EmployeeLanguageRelation`.`language_id`, `EmployeeLanguageRelation`.`speak`, `EmployeeLanguageRelation`.`read`, `EmployeeLanguageRelation`.`write`, `EmployeeLanguageRelation`.`created`, `EmployeeLanguageRelation`.`updated` FROM `theglobc_cyprus`.`employees` AS `Employee` LEFT JOIN `theglobc_cyprus`.`nationalities` AS `Nationality` ON (`Employee`.`nationality_id` = `Nationality`.`id`) LEFT JOIN `theglobc_cyprus`.`employee_categories` AS `EmployeeCategory` ON (`EmployeeCategory`.`employee_id` = `Employee`.`id`) LEFT JOIN `theglobc_cyprus`.`employee_cities` AS `EmployeeCity` ON (`EmployeeCity`.`employee_id` = `Employee`.`id`) LEFT JOIN `theglobc_cyprus`.`employee_language_relations` AS `EmployeeLanguageRelation` ON (`EmployeeLanguageRelation`.`employee_id` = `Employee`.`id`) WHERE `Employee`.`lang` = 'eng' AND `Employee`.`active` = 1 AND NOT (`Employee`.`title` IS NULL) AND `EmployeeCategory`.`category_id` = '5-development' GROUP BY `Employee`.`id` LIMIT 10

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

  • CORE/Cake/Model/Datasource/DboSource.php line 458PDOStatement->execute(array)
  • CORE/Cake/Model/Datasource/DboSource.php line 424DboSource->_execute(string, array)
  • CORE/Cake/Model/Datasource/DboSource.php line 665DboSource->execute(string, array, array)
  • CORE/Cake/Model/Datasource/DboSource.php line 1077DboSource->fetchAll(string, boolean)
  • CORE/Cake/Model/Model.php line 2902DboSource->read(Employee, array)
  • CORE/Cake/Model/Model.php line 2874Model->_readDataSource(string, array)
  • APP/Model/AppModel.php line 650Model->find(string, array, null, null)
  • CORE/Cake/Controller/Component/PaginatorComponent.php line 196AppModel->find(string, array)
  • APP/Plugin/Jobboard/Controller/EmployeesController.php line 481PaginatorComponent->paginate(string)
  • [internal function]EmployeesController->index(string, string)
  • CORE/Cake/Controller/Controller.php line 490ReflectionMethod->invokeArgs(EmployeesController, array)
  • CORE/Cake/Routing/Dispatcher.php line 185Controller->invokeAction(CakeRequest)
  • CORE/Cake/Routing/Dispatcher.php line 160Dispatcher->_invoke(EmployeesController, CakeRequest, CakeResponse)
  • APP/webroot/index.php line 92Dispatcher->dispatch(CakeRequest, CakeResponse)