Okay, sorry for coming back on this solved thread, but after I removed that bits of code, in the log "database" appears some strange things:
2011年 03月 02日 04:45 AM - 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 cpg_pictures AS r
INNER JOIN cpg_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
ORDER BY r.pid ASC LIMIT 0 ,-2' in include/functions.inc.php on line 1501 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 '-2' at line 6
Mar 02, 2011 at 08:43 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 cpg_pictures AS r
WHERE ((aid = 1 ) OR (keywords like '%(a user name was here, replaced it for privacy reasons)%' ))AND approved='YES'
ORDER BY filename DESC, pid DESC
LIMIT 0 ,-25' 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 '-25' at line 4
2011年 03月 03日 06:49 AM - While executing query 'SELECT cid FROM cpg_categories WHERE lft BETWEEN AND ' in include/functions.inc.php on line 54 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 'AND' at line 1
2011年 03月 03日 07:24 AM - While executing query 'SELECT cid FROM cpg_categories WHERE lft BETWEEN AND ' in include/functions.inc.php on line 54 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 'AND' at line 1
Everything is working as it should, but I'm just wondering if this is something to be scared of?