Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 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 'AND par.is_active = 1' at line 1
The SQL being executed was: SELECT COUNT(*) FROM `cms_agro` LEFT JOIN `cms_agro_parser` `par` ON `cms_agro`.`parser_id` = `par`.`id` WHERE (disapper_date IS NULL or disapper_date >= "2024-03-28" ) AND status = 1 AND cms_agro.auction_type_id = 3 AND category_id = AND par.is_active = 1

Error Info: Array
(
    [0] => 42000
    [1] => 1064
    [2] => 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 'AND par.is_active = 1' at line 1
)
$_GET = [
    'auc' => 'upcoming-auctions',
    'cat' => 'Rice transplanter',
];