Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: You have an error in your SQL syntax  (Read 276159 times)

0 Members and 1 Guest are viewing this topic.

serg5777

  • Coppermine frequent poster
  • ***
  • Country: ru
  • Offline Offline
  • Gender: Male
  • Posts: 171
    • Широкоформатные обои для рабочего стола
You have an error in your SQL syntax
« 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
Logged

serg5777

  • Coppermine frequent poster
  • ***
  • Country: ru
  • Offline Offline
  • Gender: Male
  • Posts: 171
    • Широкоформатные обои для рабочего стола
Re: You have an error in your SQL syntax
« Reply #1 on: February 06, 2012, 04:32:36 pm »

up!  :)
Logged

serg5777

  • Coppermine frequent poster
  • ***
  • Country: ru
  • Offline Offline
  • Gender: Male
  • Posts: 171
    • Широкоформатные обои для рабочего стола
Re: You have an error in your SQL syntax
« Reply #2 on: February 08, 2012, 05:05:17 pm »

up 2  :)
Logged

serg5777

  • Coppermine frequent poster
  • ***
  • Country: ru
  • Offline Offline
  • Gender: Male
  • Posts: 171
    • Широкоформатные обои для рабочего стола
Re: You have an error in your SQL syntax
« Reply #3 on: February 11, 2012, 12:21:22 pm »

Help  ;)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: You have an error in your SQL syntax
« Reply #4 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.027 seconds with 20 queries.