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 / click thumbnail to see detail comment  (Read 3040 times)

0 Members and 1 Guest are viewing this topic.

cl9m

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 118
Critical error / click thumbnail to see detail comment
« on: September 01, 2010, 12:09:33 pm »

Hi,

I've found a problem with version 1.5.8 on the lastcom page when I click on a thumbnail to see detail of comment, I've a CRITICAL ERROR!

Who has the same problem ?

What is the issue ?

Thanks a lot.



Logged

Nibbler

  • Guest
Re: Critical error / click thumbnail to see detail comment
« Reply #1 on: September 01, 2010, 12:25:30 pm »

Enable debug mode and post the db error message.
Logged

cl9m

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 118
Re: Critical error / click thumbnail to see detail comment
« Reply #2 on: September 01, 2010, 01:10:39 pm »

Septembre 01, 2010 at 01:08 PM - While executing query 'SELECT COUNT(*) FROM c15x_pictures AS p
INNER JOIN c15x_albums AS r ON r.aid = p.aid
INNER JOIN c15x_comments AS c ON c.pid = p.pid
WHERE (1)
AND approved = 'YES'
AND approval = 'YES'
AND msg_id > ' in include/functions.inc.php on line 2112 the following error was encountered:
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 '' at line 7
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Critical error / click thumbnail to see detail comment
« Reply #3 on: September 02, 2010, 12:30:50 pm »

I cannot find an issue with the code and it works for me:
Code: [Select]
       $superCage = Inspekt::makeSuperCage();

        $query = "SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} AS p
            INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS r ON r.aid = p.aid
            INNER JOIN {$CONFIG['TABLE_COMMENTS']} AS c ON c.pid = p.pid
            $RESTRICTEDWHERE
            AND approved = 'YES'
            AND approval = 'YES'
            AND msg_id > ".$superCage->get->getInt('msg_id');

            $result = cpg_db_query($query);

Please post a link to your gallery and a link where the error occurs.
Logged

cl9m

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 118
Re: Critical error / click thumbnail to see detail comment
« Reply #4 on: September 02, 2010, 01:23:39 pm »

Sorry I forget my cpg link

lastcom page ok!
http://www.zumup.com/thumbnails.php?album=lastcom

when you click on a last comment

http://www.zumup.com/displayimage.php?album=lastcom&cat=0&pid=24

for help you I activate the debug mod

Thx
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Critical error / click thumbnail to see detail comment
« Reply #5 on: September 02, 2010, 01:24:49 pm »

Please disable all plugins and try again.
Logged

cl9m

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 118
Re: Critical error / click thumbnail to see detail comment
« Reply #6 on: September 02, 2010, 01:46:16 pm »

thank to you I've found the probleme, is caused by this plugin : cpg1.5.x_plugin_album-fav-boxes_v2.4

Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 19 queries.