Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Update History plugin for cpg1.5.x issue  (Read 3712 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.04 seconds with 20 queries.