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: Update History plugin for cpg1.5.x issue  (Read 3918 times)

0 Members and 1 Guest are viewing this topic.

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Update History plugin for cpg1.5.x issue
« on: November 17, 2011, 03:40:12 pm »

Hi,

When a new album is created and not in a category there is a critical 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 cpg132_albums as a  LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid  WHERE a.category= ORDER BY a.pos, a.aid LIMIT 0,1' in index.php on line 771

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 'ORDER BY a.pos, a.aid LIMIT 0,1' at line 1

When the new album is moved into a category it works fine.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Update History plugin for cpg1.5.x issue
« Reply #1 on: November 17, 2011, 03:52:58 pm »

You'd really help us/me if you post more information in your starting posts.

I had to search the plugin, which I found here: http://forum.coppermine-gallery.net/index.php/topic,70073.0.html

Which plugin version do you use?

When exactly does the error occur?

Please post a link to your gallery.
Logged

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Re: Update History plugin for cpg1.5.x issue
« Reply #2 on: November 17, 2011, 05:51:45 pm »

I use version 1.1.

When the new album is created the error occures when hitting the home button.
Right now I have moved the album in a category as a temporary fix.

So only albums which are not in a category causes the critical error in combination with this plugin.

The url is www.aviationpix.nl
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.