Query Error: SQLSTATE[HY093]: Invalid parameter number
Failed SQL: SELECT j.*,
c.name as company_name,
c.logo as company_logo,
cat.name_th as category_name,
cat.icon as category_icon
FROM jobs j
LEFT JOIN companies c ON j.company_id = c.id
LEFT JOIN job_categories cat ON j.category_id = cat.id
WHERE j.status = 'published'
AND (j.expires_at IS NULL OR j.expires_at > NOW()) AND (j.title_th LIKE :keyword
OR j.description_th LIKE :keyword
OR j.requirements_th LIKE :keyword
OR c.name LIKE :keyword) ORDER BY
CASE WHEN j.title_th LIKE :keyword_exact THEN 1 ELSE 2 END,
j.is_featured DESC,
j.is_urgent DESC,
j.published_at DESC LIMIT 20 OFFSET 0Params: Array
(
[:keyword] => %ช่างเชื่อม%
[:keyword_exact] => %ช่างเชื่อม%
)
Fatal error: Uncaught Exception: Query execution failed: SQLSTATE[HY093]: Invalid parameter number in /home/kensetsuco/domains/kensetsu.co/Core/Database.php:83
Stack trace:
#0 /home/kensetsuco/domains/kensetsu.co/Models/JobModel.php(435): Database->query()
#1 /home/kensetsuco/domains/kensetsu.co/Controllers/Front/JobController.php(137): JobModel->searchJobs()
#2 /home/kensetsuco/domains/kensetsu.co/Core/Router.php(584): JobController->search()
#3 /home/kensetsuco/domains/kensetsu.co/Core/Router.php(422): Router::callAction()
#4 /home/kensetsuco/domains/kensetsu.co/Core/Router.php(340): Router::matchRouteDefinitions()
#5 /home/kensetsuco/domains/kensetsu.co/Core/App.php(12): Router::dispatch()
#6 /home/kensetsuco/domains/kensetsu.co/public_html/index.php(29): App::run()
#7 {main}
thrown in /home/kensetsuco/domains/kensetsu.co/Core/Database.php on line 83