DB Error: syntax error
DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -2 [message] => DB Error: syntax error [userinfo] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [nativecode=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 products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7] [backtrace] => Array ( [0] => Array ( [file] => /var/www/toproset.dk/pear/DB.php [line] => 748 [function] => PEAR_Error [class] => PEAR_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => DB Error: syntax error [1] => -2 [2] => 1 [3] => 1024 [4] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [nativecode=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 products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7] ) ) [1] => Array ( [file] => /var/www/toproset.dk/pear/PEAR.php [line] => 541 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -2 [1] => 1 [2] => 1024 [3] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [nativecode=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 products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7] ) ) [2] => Array ( [file] => /var/www/toproset.dk/pear/DB/common.php [line] => 500 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #13 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => toproset2011 [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => toproset [password] => Top2011Roset [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => toproset2011 ) ) [type] => -> [args] => Array ( [0] => [1] => -2 [2] => [3] => [4] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [nativecode=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 products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /var/www/toproset.dk/pear/DB/mysql.php [line] => 776 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #13 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => toproset2011 [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => toproset [password] => Top2011Roset [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => toproset2011 ) ) [type] => -> [args] => Array ( [0] => -2 [1] => [2] => [3] => [4] => 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 products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7 ) ) [4] => Array ( [file] => /var/www/toproset.dk/pear/DB/mysql.php [line] => 228 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #13 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => toproset2011 [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => toproset [password] => Top2011Roset [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => toproset2011 ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /var/www/toproset.dk/pear/DB/common.php [line] => 1146 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #13 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => toproset2011 [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => toproset [password] => Top2011Roset [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => toproset2011 ) ) [type] => -> [args] => Array ( [0] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos ) ) [6] => Array ( [file] => /var/www/toproset.dk/pear/DB/common.php [line] => 1596 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #13 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => toproset2011 [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => toproset [password] => Top2011Roset [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => toproset2011 ) ) [type] => -> [args] => Array ( [0] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos ) ) [7] => Array ( [file] => /var/www/toproset.dk/productSingle.php [line] => 149 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #13 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => toproset2011 [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => toproset [password] => Top2011Roset [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => toproset2011 ) ) [type] => -> [args] => Array ( [0] => SELECT variants.id AS var_id, variants.pic_1, variants.product_id, variants.refno FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id) WHERE products.id = AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0 AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1') AND products.number_of_layers = '0' ORDER BY variants.pos ) ) ) [callback] => )