A PHP Error was encountered

Severity: Warning

Message: pg_escape_literal(): Failed to escape

Filename: postgre/postgre_driver.php

Line Number: 345

Backtrace:

File: /home/devppk/public_html/application/modules/vacancy/models/Vacancy_models.php
Line: 28
Function: where

File: /home/devppk/public_html/application/modules/vacancy/controllers/Vacancy.php
Line: 34
Function: get_paged_record

File: /home/devppk/public_html/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: pg_query(): Query failed: ERROR: syntax error at or near "ORDER" LINE 10: ORDER BY "created_at" DESC ^

Filename: postgre/postgre_driver.php

Line Number: 242

Backtrace:

File: /home/devppk/public_html/application/modules/vacancy/models/Vacancy_models.php
Line: 30
Function: get

File: /home/devppk/public_html/application/modules/vacancy/controllers/Vacancy.php
Line: 34
Function: get_paged_record

File: /home/devppk/public_html/index.php
Line: 292
Function: require_once

Database Error

A Database Error Occurred

Error Number:

ERROR: syntax error at or near "ORDER" LINE 10: ORDER BY "created_at" DESC ^

SELECT "v"."id" as "id_v", "v"."title", "v"."all_major" as "major", "v"."worktime" as "worktime", "i"."description" AS "industry", "d"."description" as "degree", "v"."remarks", "v"."open_date", "v"."close_date", "v"."position_numbers", "v"."created_at", "v"."cmp_company_id", "c"."name" AS "company", "c"."image" as "foto", "v"."qualification" as "kualifikasi" FROM "vcn_vacancy" "v" JOIN "cmp_company" "c" ON "v"."cmp_company_id" = "c"."id" LEFT JOIN "rf_industry" "i" ON "i"."id"="v"."rf_industry_id" LEFT JOIN "rf_degree" "d" ON "d"."id"="v"."rf_degree_id" WHERE "is_published" = '1' AND "is_open" = '1' AND "v"."close_date" >= '2024-03-19' AND "c"."id" = ORDER BY "created_at" DESC

Filename: modules/vacancy/models/Vacancy_models.php

Line Number: 30