Severity: Notice
Message: Undefined index: user_id
Filename: models/Job_model.php
Line Number: 127
Backtrace:
File: /home/umano/test/application/models/Job_model.php
Line: 127
Function: _error_handler
File: /home/umano/test/application/controllers/Job.php
Line: 411
Function: get_fav_list
File: /home/umano/test/index.php
Line: 315
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/umano/test/system/core/Exceptions.php:272)
Filename: core/Common.php
Line Number: 571
Backtrace:
File: /home/umano/test/application/models/Job_model.php
Line: 160
Function: query
File: /home/umano/test/application/controllers/Job.php
Line: 411
Function: get_fav_list
File: /home/umano/test/index.php
Line: 315
Function: require_once
Error Number: 1064
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 ') as t' at line 6
SELECT count(*) as count_rows FROM (SELECT vac.id, 1 AS in_fav_list, vac.apply_email, vac.viewed, vac.content_1 as content, vac.title_1 as title, vac.category_id, vac.company_id, vac.city_id, vac.salary_min, vac.salary_max, vac.publish_date, vac.expired_date, cities.title_1 as city_title, categories.title_1 as category_title, companies.logo, companies.title_1 as company_title from fav_list as fav LEFT JOIN vacancies as vac on vac.id = fav.vacancy_id LEFT JOIN cities on cities.id=vac.city_id LEFT JOIN categories on categories.id=vac.category_id LEFT JOIN companies on companies.id=vac.company_id WHERE fav.vacancy_type=1 AND ) as t
Filename: models/Job_model.php
Line Number: 160