forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: idosha on August 08, 2013, 03:23:52 am

Title: There was an error while processing a database query.
Post by: idosha on August 08, 2013, 03:23:52 am

Here is the error:

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 = 8   ORDER BY  LIMIT 0,30' in index.php on line 795

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,30' at line 1


Gallery: hailee-steinfeld.com/gallery/
One of the pages with errors: http://hailee-steinfeld.com/gallery/index.php?cat=8

I'm lost as to what is causing it as some pages work fine as others do not.

Title: Re: There was an error while processing a database query.
Post by: idosha on August 08, 2013, 03:43:16 am

I fixed it, stupid me forgot to update the database after installing new version.