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: Critical Error when viewing pics via "Most Viewed"  (Read 2229 times)

0 Members and 1 Guest are viewing this topic.

dianajameson

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Critical Error when viewing pics via "Most Viewed"
« on: October 21, 2011, 06:48:47 pm »

Hi

I have a strange problem.

My huge Coppermine (V1.56 stable) installation works fine - except when I select "Most Viewed" from within an album. When I do this I get the error

"Critical Error" "There was an error while processing a database query"

I have also noticed that on rare occasions when I click a thumbnail the wrong full sized picture is shown.

Any help would be appreciated

Diana
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical Error when viewing pics via "Most Viewed"
« Reply #1 on: October 21, 2011, 06:56:41 pm »

Please enable debug mode and post a link to your gallery.
Logged

dianajameson

  • Coppermine newbie
  • Offline Offline
  • Posts: 12
Re: Critical Error when viewing pics via "Most Viewed"
« Reply #2 on: October 21, 2011, 08:47:41 pm »

HI there

Im afraid I cant post a link to the gallery as it is within the members area of an adult site - Posting the access details here might not be appropriate!

The debug info is

While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
                FROM cpg11d_pictures AS r
                INNER JOIN cpg11d_albums AS a ON a.aid = r.aid
                WHERE (r.aid = 1997)
                AND approved = 'YES'
                AND hits > 0
                ORDER BY hits ASC, pid DESC
                 LIMIT 0 ,-539' in include/functions.inc.php on line 1593

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 '-539' at line 8

In file  include/functions.inc.php - Line: 258

Many thanks for your help
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical Error when viewing pics via "Most Viewed"
« Reply #3 on: October 22, 2011, 08:57:03 pm »

If you have the latest release (cpg1.5.16) it's impossible to say what's wrong without blind guessing. I can give you my contact data if you're ready to send me the access details to your members area.
Logged
Pages: [1]   Go Up
 

Page created in 0.026 seconds with 19 queries.