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: Critical error / click thumbnail to see detail comment  (Read 3460 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: 15764
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: 15764
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.027 seconds with 20 queries.