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] =>
)