object(PDOException)#47 (8) { ["message":protected]=> string(242) "SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND active=1 ORDER BY direct_order asc' at line 1" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "42000" ["file":protected]=> string(31) "/home/ecbase/lib/storage/db.php" ["line":protected]=> int(80) ["trace":"Exception":private]=> array(9) { [0]=> array(6) { ["file"]=> string(31) "/home/ecbase/lib/storage/db.php" ["line"]=> int(80) ["function"]=> string(7) "execute" ["class"]=> string(12) "PDOStatement" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [1]=> array(6) { ["file"]=> string(35) "/home/ecbase/lib/storage/dbWrap.php" ["line"]=> int(41) ["function"]=> string(8) "execstmt" ["class"]=> string(2) "db" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(PDOStatement)#42 (1) { ["queryString"]=> string(89) "SELECT * FROM item_public_order WHERE category_id= AND active=1 ORDER BY direct_order asc" } } } [2]=> array(6) { ["file"]=> string(42) "/home/ecbase/lib/storage/storageBridge.php" ["line"]=> int(55) ["function"]=> string(8) "doSelect" ["class"]=> string(6) "dbWrap" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(criteriaDb)#45 (15) { ["fields":protected]=> string(1) "*" ["where":protected]=> array(2) { [0]=> string(12) "category_id=" [1]=> string(8) "active=1" } ["group":protected]=> array(0) { } ["having":protected]=> bool(false) ["order":protected]=> array(1) { [0]=> string(16) "direct_order asc" } ["limit":protected]=> bool(false) ["offset":protected]=> bool(false) ["other":protected]=> bool(false) ["last_cnt_cond":protected]=> string(32) " WHERE category_id= AND active=1" ["joint":protected]=> array(1) { [0]=> string(3) "AND" } ["auto_esc":protected]=> int(0) ["abstraction":protected]=> int(0) ["datakey":protected]=> NULL ["proclist":protected]=> array(36) { [0]=> string(5) "equal" [1]=> string(9) "not_equal" [2]=> string(13) "alt_not_equal" [3]=> string(12) "greater_than" [4]=> string(9) "less_than" [5]=> string(13) "greater_equal" [6]=> string(10) "less_equal" [7]=> string(4) "like" [8]=> string(6) "like_l" [9]=> string(6) "like_r" [10]=> string(8) "not_like" [11]=> string(10) "not_like_l" [12]=> string(10) "not_like_r" [13]=> string(5) "ilike" [14]=> string(9) "not_ilike" [15]=> string(6) "custom" [16]=> string(12) "custom_equal" [17]=> string(8) "distinct" [18]=> string(11) "distinct_on" [19]=> string(2) "in" [20]=> string(6) "not_in" [21]=> string(3) "all" [22]=> string(4) "join" [23]=> string(10) "binary_and" [24]=> string(9) "binary_or" [25]=> string(3) "asc" [26]=> string(4) "desc" [27]=> string(6) "isnull" [28]=> string(9) "isnotnull" [29]=> string(12) "current_date" [30]=> string(12) "current_time" [31]=> string(17) "current_timestamp" [32]=> string(9) "left_join" [33]=> string(10) "right_join" [34]=> string(10) "inner_join" [35]=> string(7) "between" } ["proc_objlist":protected]=> array(1) { [0]=> string(6) "having" } } } } [3]=> array(6) { ["file"]=> string(47) "/home/itagaki/lib/item/itemPageStorageClass.php" ["line"]=> int(287) ["function"]=> string(8) "doSelect" ["class"]=> string(13) "storageBridge" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(criteriaDb)#45 (15) { ["fields":protected]=> string(1) "*" ["where":protected]=> array(2) { [0]=> string(12) "category_id=" [1]=> string(8) "active=1" } ["group":protected]=> array(0) { } ["having":protected]=> bool(false) ["order":protected]=> array(1) { [0]=> string(16) "direct_order asc" } ["limit":protected]=> bool(false) ["offset":protected]=> bool(false) ["other":protected]=> bool(false) ["last_cnt_cond":protected]=> string(32) " WHERE category_id= AND active=1" ["joint":protected]=> array(1) { [0]=> string(3) "AND" } ["auto_esc":protected]=> int(0) ["abstraction":protected]=> int(0) ["datakey":protected]=> NULL ["proclist":protected]=> array(36) { [0]=> string(5) "equal" [1]=> string(9) "not_equal" [2]=> string(13) "alt_not_equal" [3]=> string(12) "greater_than" [4]=> string(9) "less_than" [5]=> string(13) "greater_equal" [6]=> string(10) "less_equal" [7]=> string(4) "like" [8]=> string(6) "like_l" [9]=> string(6) "like_r" [10]=> string(8) "not_like" [11]=> string(10) "not_like_l" [12]=> string(10) "not_like_r" [13]=> string(5) "ilike" [14]=> string(9) "not_ilike" [15]=> string(6) "custom" [16]=> string(12) "custom_equal" [17]=> string(8) "distinct" [18]=> string(11) "distinct_on" [19]=> string(2) "in" [20]=> string(6) "not_in" [21]=> string(3) "all" [22]=> string(4) "join" [23]=> string(10) "binary_and" [24]=> string(9) "binary_or" [25]=> string(3) "asc" [26]=> string(4) "desc" [27]=> string(6) "isnull" [28]=> string(9) "isnotnull" [29]=> string(12) "current_date" [30]=> string(12) "current_time" [31]=> string(17) "current_timestamp" [32]=> string(9) "left_join" [33]=> string(10) "right_join" [34]=> string(10) "inner_join" [35]=> string(7) "between" } ["proc_objlist":protected]=> array(1) { [0]=> string(6) "having" } } } } [4]=> array(6) { ["file"]=> string(45) "/home/itagaki/lib/item/itemPageModelClass.php" ["line"]=> int(49) ["function"]=> string(19) "getListByCategoryId" ["class"]=> string(15) "itemPageStorage" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &bool(false) } } [5]=> array(6) { ["file"]=> string(49) "/home/itagaki/lib/object/itemPageListWebClass.php" ["line"]=> int(331) ["function"]=> string(19) "getListByCategoryId" ["class"]=> string(13) "itemPageModel" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &bool(false) } } [6]=> array(6) { ["file"]=> string(59) "/home/itagaki/www/htdocs/shopping/search/item_list/form.php" ["line"]=> int(14) ["function"]=> string(23) "itemPageDirectOrderSort" ["class"]=> string(15) "itemPageListWeb" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &bool(false) } } [7]=> array(4) { ["file"]=> string(28) "/usr/local/poison/aform4.php" ["line"]=> int(125) ["args"]=> array(1) { [0]=> string(59) "/home/itagaki/www/htdocs/shopping/search/item_list/form.php" } ["function"]=> string(7) "require" } [8]=> array(4) { ["file"]=> string(60) "/home/itagaki/www/htdocs/shopping/search/item_list/index.php" ["line"]=> int(70) ["args"]=> array(1) { [0]=> string(28) "/usr/local/poison/aform4.php" } ["function"]=> string(7) "require" } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "42000" [1]=> int(1064) [2]=> string(186) "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 'AND active=1 ORDER BY direct_order asc' at line 1" } } 商品一覧|鞄いたがき(ITAGAKI)
このページの先頭へ