script shows comments, where no comments are

[Vogelfreund]

Hello,

i have open the testscript for unregistert for you, to have a look on it...

http://www.vogelforen.de/fotos/index.php?c=17

There you see on every picture 1 comment..

if you klick on a photo, there is no comment:

http://www.vogelforen.de/fotos/index.php?n=4

Wenn you see the mainpage, the count is also correct:

http://www.vogelforen.de/fotos/

Why is the count on the image-list wrong?

Can someone help?

[Morgan]

Hi, what versions of PHP and MySQL are you using, and what rows are in the photoplog_ratecomment table?

[Vogelfreund]

PHP 4.3.10
MySQL-Version 3.23.48-Max

[Morgan]

You are seeing 1 instead of 0 for the counts because of how MySQL 3.23.48 handles SUM in a couple of PhotoPlog queries (see here (http://bugs.mysql.com/bug.php?id=4346) for further details).

In the PhotoPlog index.php file find (two spots):
Content visible to registered users only.
And replace with the following (in both spots):
Content visible to registered users only.
FYI to others: there is no need to apply this change unless you see 1 instead of 0 in the comment counts where zero is actually the true count.

[Vogelfreund]

great service...

where can i buy my licence ;-)

[MikeD]

Content visible to registered users only.
Simple as that ;)

Go to the Download (http://www.photoplog.com/download/index.php) (Navbar) link => Click on Upgrade/Renew/Purchase (http://www.photoplog.com/forum/payments.php). At the bottom you will see a Drop Down Menu "Prices subject to change". After choosing press the "Order" button. Now you will redirected to PayPal where you can pay PhotoPlog Pro. That's it. No big deal ;) -Mike