rollback.You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"Ae" AND `price` > "0" AND ( (opendate <= '2024-09-08 14:42:55' OR opendate...' at line 1object(mysqli_sql_exception)#8 (8) { ["message":protected]=> string(228) "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"Ae" AND `price` > "0" AND ( (opendate <= '2024-09-08 14:42:55' OR opendate...' at line 1" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(1064) ["file":protected]=> string(63) "/var/www/vhosts/4-bridal.jp/public_html/libs/class.DataBase.php" ["line":protected]=> int(150) ["trace":"Exception":private]=> array(5) { [0]=> array(3) { ["file"]=> string(63) "/var/www/vhosts/4-bridal.jp/public_html/libs/class.DataBase.php" ["line"]=> int(150) ["function"]=> string(12) "mysqli_query" } [1]=> array(5) { ["file"]=> string(64) "/var/www/vhosts/4-bridal.jp/public_html/ctrl/class.ControlDB.php" ["line"]=> int(227) ["function"]=> string(5) "Query" ["class"]=> string(8) "DataBase" ["type"]=> string(2) "->" } [2]=> array(5) { ["file"]=> string(64) "/var/www/vhosts/4-bridal.jp/public_html/ctrl/class.ControlDB.php" ["line"]=> int(65) ["function"]=> string(8) "getLimit" ["class"]=> string(9) "ControlDB" ["type"]=> string(2) "->" } [3]=> array(5) { ["file"]=> string(68) "/var/www/vhosts/4-bridal.jp/public_html/template/category/header.php" ["line"]=> int(193) ["function"]=> string(8) "getTable" ["class"]=> string(9) "ControlDB" ["type"]=> string(2) "->" } [4]=> array(4) { ["file"]=> string(60) "/var/www/vhosts/4-bridal.jp/public_html/engagement/index.php" ["line"]=> int(12) ["args"]=> array(1) { [0]=> string(68) "/var/www/vhosts/4-bridal.jp/public_html/template/category/header.php" } ["function"]=> string(12) "require_once" } } ["previous":"Exception":private]=> NULL ["sqlstate":protected]=> string(5) "42000" }
Invalid query: Whole query: SELECT * FROM 4cb_product_tbl a WHERE ('name' IS NOT NULL AND `status` = "1" AND `category_id` = "204" AND `design_id` "Ae" AND `price` > "0" AND ( (opendate <= '2024-09-08 14:42:55' OR opendate IS NULL) ) AND ( (closedate >= '2024-09-08 14:42:55' OR closedate IS NULL) ) ) ORDER BY `priority` DESC , `registdate` DESC , `id` DESC