forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: cl9m 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.
-
Enable debug mode and post the db error message.
-
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
-
I cannot find an issue with the code and it works for me:
$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.
-
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
-
Please disable all plugins and try again.
-
thank to you I've found the probleme, is caused by this plugin : cpg1.5.x_plugin_album-fav-boxes_v2.4