forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: serg5777 on February 05, 2012, 10:15:36 am

Title: You have an error in your SQL syntax
Post by: serg5777 on February 05, 2012, 10:15:36 am

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

Code: [Select]

....Фев 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

Title: Re: You have an error in your SQL syntax
Post by: serg5777 on February 06, 2012, 04:32:36 pm

up!  :)

Title: Re: You have an error in your SQL syntax
Post by: serg5777 on February 08, 2012, 05:05:17 pm

up 2  :)

Title: Re: You have an error in your SQL syntax
Post by: serg5777 on February 11, 2012, 12:21:22 pm

Help  ;)

Title: Re: You have an error in your SQL syntax
Post by: Αndré on February 24, 2012, 04:10:32 pm

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.