Янв 10, 2011 - 21:27 - 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, UNIX_TIMESTAMP(msg_date) AS msg_date, msg_body, author_id, msg_author, msg_id
FROM cpg15x_comments AS c
INNER JOIN cpg15x_pictures AS r ON r.pid = c.pid
INNER JOIN cpg15x_albums AS a ON a.aid = r.aid
WHERE (1)
AND author_id = '20'
AND r.approved = 'YES'
AND c.approval = 'YES'
ORDER BY msg_id ASC
[b]LIMIT 0 ,-5[/b]' in include\functions.inc.php on line 1455 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 '-5' at line 10
Янв 13, 2011 - 00:44 - 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 = 119 ) OR (keywords like '%Шашлык_и_тапочки%' ))AND approved='YES'
ORDER BY filename DESC, pid DESC
[b]LIMIT 0 ,-6[/b]' in include\functions.inc.php on line 1306 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
А у меня на последнем релизе (1.5.12) вот такие ошибки в логах и их много. В какой момент они вылезли неизвестно, но в каждой из них ругается на отрицательное значение в выделенном фрагменте. Подскажите, пожалуйста, в чём дело?