http://www.sharpos-world.co.uk/cpg/index.phpThe gallery was updated to 1.5.8 about a week ago. I'm not getting any error messages as I browse the gallery, but when I checked my backup files the only one that didn't match was the database.log file - there was a big difference in size. Looking at the file there have been many entries added since the upgrade.
Tried searching for answers but no success so far. Ran a "repair" on the database earlier this evening, just to see if that helped, but have had 2 more entries since then, as follows:-
Nov 22, 2010 at 08:34 PM - 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 cpg143_pictures AS r
INNER JOIN cpg143_albums AS a ON a.aid = r.aid
WHERE (r.aid = 437) AND (1 OR keywords like '%/qm%') AND r.aid NOT IN (90, 100, 280, 308, 642, 643)
AND approved = 'YES'
AND hits > 0
ORDER BY hits ASC, pid DESC
LIMIT 0 ,-320' in include/functions.inc.php on line 1600 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 '-320' at line 8
---
Nov 22, 2010 at 08:51 PM - 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 cpg143_pictures AS r
INNER JOIN cpg143_albums AS a ON a.aid = r.aid
INNER JOIN cpg143_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 1 AND 2) AND r.aid NOT IN (90, 100, 280, 308, 642, 643)
AND approved = 'YES'
AND hits > 0
ORDER BY hits ASC, pid DESC
LIMIT 0 ,-631' in include/functions.inc.php on line 1600 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 '-631' at line 8
---
Had a look at functions.inc.php line 1600:-
$result = cpg_db_query($query);
Any ideas please?