I upgraded/updated previously and got this error but did nothing about it.
I have just gone from 1.5.30 to 1.5.34 and thought I should get this fixed
Link -
http://www.tracingequines.co.uk/gallery/index.php This only seems to happen when a person clicks on the main category name.
Critical error
There was an error while processing a database query
File: /... /gallery/include/functions.inc.php - Line: 272
Debug mode shows this information -
Tracing Equines
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 5 ORDER BY LIMIT 0,8' in index.php on line 738
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 'LIMIT 0,8' at line 1
Horsewatch
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 4 ORDER BY LIMIT 0,3' in index.php on line 738
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 'LIMIT 0,3' at line 1
Stolen Horse Register
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 2 ORDER BY LIMIT 0,24' in index.php on line 738
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 'LIMIT 0,24' at line 1
Other Photos
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 7 ORDER BY LIMIT 0,4' in index.php on line 738
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 'LIMIT 0,4' at line 1
Full Albums
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 9 ORDER BY LIMIT 0,3' in index.php on line 738
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 'LIMIT 0,3' at line 1