Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: There was an error while processing a database query.  (Read 1870 times)

0 Members and 1 Guest are viewing this topic.

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
There was an error while processing a database query.
« 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.
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: There was an error while processing a database query.
« Reply #1 on: August 08, 2013, 03:43:16 am »

I fixed it, stupid me forgot to update the database after installing new version.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.