Critical error / click thumbnail to see detail comment

[cl9m]

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.

[Nibbler]

Enable debug mode and post the db error message.

[cl9m]

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

[Αndré]

I cannot find an issue with the code and it works for me:

Code Select Expand

       $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.

[cl9m]

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

[Αndré]

Please disable all plugins and try again.

[cl9m]

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