DB Error: syntax error
DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -2 [message] => DB Error: syntax error [userinfo] => SELECT DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [nativecode=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 '-12,12' at line 18] [backtrace] => Array ( [0] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [nativecode=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 '-12,12' at line 18] ) ) [1] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [nativecode=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 '-12,12' at line 18] ) ) [2] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/pear/DB/common.php [line] => 495 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #15 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => ritoni3 [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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [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] => ritoni3 [password] => dfglkj435 [protocol] => tcp [hostspec] => 127.0.0.1 [port] => [socket] => [database] => ritoni3 ) ) [type] => -> [args] => Array ( [0] => [1] => -2 [2] => [3] => [4] => SELECT DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [nativecode=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 '-12,12' at line 18] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/pear/DB/mysql.php [line] => 776 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #15 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => ritoni3 [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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [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] => ritoni3 [password] => dfglkj435 [protocol] => tcp [hostspec] => 127.0.0.1 [port] => [socket] => [database] => ritoni3 ) ) [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 MariaDB server version for the right syntax to use near '-12,12' at line 18 ) ) [4] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/pear/DB/mysql.php [line] => 228 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #15 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => ritoni3 [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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [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] => ritoni3 [password] => dfglkj435 [protocol] => tcp [hostspec] => 127.0.0.1 [port] => [socket] => [database] => ritoni3 ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/pear/DB/common.php [line] => 1135 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #15 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => ritoni3 [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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [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] => ritoni3 [password] => dfglkj435 [protocol] => tcp [hostspec] => 127.0.0.1 [port] => [socket] => [database] => ritoni3 ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 ) ) [6] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/pear/DB/common.php [line] => 1572 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #15 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => ritoni3 [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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [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] => ritoni3 [password] => dfglkj435 [protocol] => tcp [hostspec] => 127.0.0.1 [port] => [socket] => [database] => ritoni3 ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 ) ) [7] => Array ( [file] => /www/ritoni.info/root.sport.ritoni.com/index.php [line] => 55 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #15 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => ritoni3 [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 DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 [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] => ritoni3 [password] => dfglkj435 [protocol] => tcp [hostspec] => 127.0.0.1 [port] => [socket] => [database] => ritoni3 ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT article.id, article.code, article.name_bg AS name, article.pic_1, article.price, article.price_wholesale, article.description_bg AS description, article.category_id /*,LOWER(pc.name_bg) AS category_name*/ FROM article WHERE hot_offer='checked' AND edate =0 ORDER BY code DESC, name LIMIT -12,12 ) ) ) [callback] => )