You have an error in your SQL syntax

[serg5777]

Please help me solve the problem. This problem happens every day. Thank you.

Code Select Expand

....Фев 04, 2012 - 10:48 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 8 AND aid NOT IN (28) ) OR (keywords like '%фотомодели; модели;Victoria Secret%' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-119' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-119' at line 4

Фев 04, 2012 - 17:47 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 8 AND aid NOT IN (28) ) OR (keywords like '%фотомодели; модели;Victoria Secret%' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-119' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-119' at line 4

Фев 04, 2012 - 17:47 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 8 AND aid NOT IN (28) ) OR (keywords like '%фотомодели; модели;Victoria Secret%' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-119' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-119' at line 4

Фев 04, 2012 - 22:17 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 5 AND aid NOT IN (28) ) OR (keywords like '%актрисы; голливуд; девушки %' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-18' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-18' at line 4

Фев 04, 2012 - 22:41 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 21 AND aid NOT IN (28) ) OR (keywords like '%эротика; голые; обнаженные%' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-133' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-133' at line 4

Фев 05, 2012 - 06:50 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 43 AND aid NOT IN (28) ) OR (keywords like '%русские машины;ваз;лада%' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-6' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-6' at line 4
2012-02-05 03:36:01 - Unable to connect to database: Unknown MySQL server host 'db01.hostline.ru' (2)

Фев 05, 2012 - 09:18 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 8 AND aid NOT IN (28) ) OR (keywords like '%фотомодели; модели;Victoria Secret%' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-58' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-58' at line 4

Фев 05, 2012 - 10:09 - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM cpg15x_pictures AS r
WHERE ((aid = 19 AND aid NOT IN (28) ) OR (keywords like '%музыка; music; клипы; рок%' AND aid NOT IN (28) ))AND approved='YES'
ORDER BY pid ASC
LIMIT 0 ,-9' in include/functions.inc.php on line 1305 the following error was encountered:
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 '-9' at line 4

[serg5777]

up! 

[serg5777]

up 2 

[serg5777]

Help 

[Αndré]

Instead of spamming the board you should have searched the board for that issue, or at least read our board rules. There are already some threads dealing with negative SQL limits. Thanks to your behavior you have to search for them yourselves.