Database query problem

[cally6008]

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

[cally6008]

Solved ,, apologies ,, ran the update database again and it now works as it should

[kuletdesigns]

hello, we have just upgraded to the newer version and this is what we got

There was an error while processing a database query.

the site: www.mindanews.com/pictures

i checked the user/password/dbname, they are all correct.

sorry, im a newbie here. thanks

[allvip]

hello, we have just upgraded to the newer version and this is what we got

There was an error while processing a database query.

the site: www.mindanews.com/pictures

i checked the user/password/dbname, they are all correct.

sorry, im a newbie here. thanks

Even if you have the same problem, you have to start a new thread.
I can see you solved it. You have to say how for other users to learn how to solve it if they have the same problem. Users will find your thread in search and will want to know how you solved it. This way they won't have to wait for someone to help them.
User cally6008 post it his solution.
Are forum rules.