Critical error when viewing images Critical error when viewing images
 

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]

Main Menu

Critical error when viewing images

Started by jmmc, October 05, 2010, 09:19:51 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

jmmc

October 05, 2010, 09:19:51 PM
Hello. So I turned off the views counter from getting displayed next to the pics thumbs so when I go to the 'Most viewed' and get them by order of most viewed sometimes some of the pics won't open and I get this error:

QuoteCritical error
There was an error while processing a database query

Not for all, I thought this only happened with the pics with less views but it seems random (?) and only sometimes because I noticed the same pics work others times. They always work on the normal view (when I'm not on the 'Most viewed' selected mode on display album) but is there any way to fix this so they'll open all the time?

Thanks in advance, sorry if I didn't explain myself very well but this is a bit weird and it's really what happens... I don't know if it's normal, just wanted to know why it happens and if it's possible to fix it.

Thanks in advance!

jmmc

#1
October 07, 2010, 04:30:57 PM
Up. Anyone plz  :-\

Nibbler

#2
October 07, 2010, 05:12:25 PM
Enable debug mode in config and post the real error message next time it happens.

jmmc

#3
October 07, 2010, 08:17:00 PM
Hey, sorry. Here it is:

Critical error

There was an error while processing a database query.

QuoteWhile 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 cpg15x_pictures AS r
                INNER JOIN cpg15x_albums AS a ON a.aid = r.aid
                WHERE (r.aid = 672)
                AND approved = 'YES'
                AND hits > 0
                ORDER BY hits ASC, pid DESC
                 LIMIT 0 ,-7' 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 '-7' at line 8

File: /home/cassieve/public_html/imgs/include/functions.inc.php - Line: 258 

jmmc

#4
October 09, 2010, 03:34:51 PM
Looked around but couldnt find anything, sry if this has been reported b4 :(

Αndré

#5
October 12, 2010, 02:17:34 PM
Please post a link to your gallery.

Joe Carver

#7
October 12, 2010, 11:42:41 PM
You are running one version behind:
Quote<!--Coppermine Photo Gallery 1.5.6 (stable)-->
Use the Download link above to get version 1.5.8. Then upgrade.

Your theme has not been updated to work with Coppermine versions 1.5.x. This does not belong in the <head>.
Quote<script type="text/javascript" src="scripts.js"></script>

Custom themes from cpg 1.4.x must be updated for version 1.5.x. Read your document package.
Print
Go Up Pages1
User actions