Thanks for the reply. This issue might have a cause that I can not control at the moment.
I can not replicate the size of your gallery with my test gallery.
Please - could you make a fast test without the plugin?
1) Uninstall Lightbox
2) Choose a recent Category (2010)
3) Try "Most viewed" -> then the last page -> last thumbnail
ex.
http://www.huitzuco.org/photo/thumbnails.php?album=topn&cat=-544&page=3
http://www.huitzuco.org/photo/displayimage.php?album=topn&cat=-544&pid=30687#top_display_media
For the first url this error:
"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, pic_raw_ip, pic_hdr_ip
FROM cpg_pictures AS r
INNER JOIN cpg_albums AS a ON a.aid = r.aid
WHERE (r.aid = 544)
AND approved = 'YES'
AND hits > 0
ORDER BY hits ASC, pid DESC
LIMIT 0 ,-45' in include/functions.inc.php on line 1593
mySQL error: 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 '-45' at line 8
Fichero: /x/x/x/x/include/functions.inc.php - Linea: 258 "
second url
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, pic_raw_ip, pic_hdr_ip
FROM cpg_pictures AS r
INNER JOIN cpg_albums AS a ON a.aid = r.aid
WHERE (r.aid = 544)
AND approved = 'YES'
AND hits > 0
ORDER BY hits ASC, pid DESC
LIMIT 0 ,-45' in include/functions.inc.php on line 1593
mySQL error: 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 '-45' at line 8
Fichero: /x/x/x/x/include/functions.inc.php - Linea: 258
and
4) Home Page -> "Most Viewed" -> then the last page -> last thumbnail
ex.
http://www.huitzuco.org/photo/thumbnails.php?album=topn&cat=0&page=1537
http://www.huitzuco.org/photo/displayimage.php?album=topn&cat=0&pid=31265#top_display_media
Thanks in advance if you can reply with your results.
with no errors.
thank you for your time and help. any advice is welcome