DB Error: syntax error
DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -2 [message] => DB Error: syntax error [userinfo] => SELECT news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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 '-15, 15' at line 22] [backtrace] => Array ( [0] => Array ( [file] => /home/vlastta/public_html/zona-news.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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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 '-15, 15' at line 22] ) ) [1] => Array ( [file] => /home/vlastta/public_html/zona-news.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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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 '-15, 15' at line 22] ) ) [2] => Array ( [file] => /home/vlastta/public_html/zona-news.com/pear/DB/common.php [line] => 495 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #5 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => vlaskhsj_vlastta [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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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] => vlaskhsj_vlastta [password] => vr^HQL,u@%?P [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => vlaskhsj_vlastta ) ) [type] => -> [args] => Array ( [0] => [1] => -2 [2] => [3] => [4] => SELECT news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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 '-15, 15' at line 22] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /home/vlastta/public_html/zona-news.com/pear/DB/mysql.php [line] => 776 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #5 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => vlaskhsj_vlastta [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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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] => vlaskhsj_vlastta [password] => vr^HQL,u@%?P [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => vlaskhsj_vlastta ) ) [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 '-15, 15' at line 22 ) ) [4] => Array ( [file] => /home/vlastta/public_html/zona-news.com/pear/DB/mysql.php [line] => 228 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #5 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => vlaskhsj_vlastta [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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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] => vlaskhsj_vlastta [password] => vr^HQL,u@%?P [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => vlaskhsj_vlastta ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /home/vlastta/public_html/zona-news.com/pear/DB/common.php [line] => 1135 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #5 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => vlaskhsj_vlastta [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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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] => vlaskhsj_vlastta [password] => vr^HQL,u@%?P [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => vlaskhsj_vlastta ) ) [type] => -> [args] => Array ( [0] => SELECT news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 ) ) [6] => Array ( [file] => /home/vlastta/public_html/zona-news.com/pear/DB/common.php [line] => 1572 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #5 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => vlaskhsj_vlastta [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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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] => vlaskhsj_vlastta [password] => vr^HQL,u@%?P [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => vlaskhsj_vlastta ) ) [type] => -> [args] => Array ( [0] => SELECT news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 ) ) [7] => Array ( [file] => /home/vlastta/public_html/zona-news.com/categories.php [line] => 131 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #5 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => vlaskhsj_vlastta [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 news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 [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] => vlaskhsj_vlastta [password] => vr^HQL,u@%?P [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => vlaskhsj_vlastta ) ) [type] => -> [args] => Array ( [0] => SELECT news.id, news.name_bg AS name, news.description_bg AS description, news.excerpt_bg AS excerpt, news.pic, news.video_id, news.post_year, news.post_month, news.post_day, news.seen, news.publishdate, (SELECT count(id) FROM vlastta_zn_comments WHERE edate = 0 AND news_id = news.id) AS comments FROM vlastta_news AS news, vlastta_news_to_categories AS ntc WHERE news.edate = 0 AND news.active = '1' AND news.id = ntc.news_id AND news.publishdate < 1524504584 AND ntc.category_id = '4' ORDER BY news.publishdate DESC LIMIT -15, 15 ) ) ) [callback] => )