script shows comments, where no comments are
 

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?

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

PHP 4.3.10
MySQL-Version 3.23.48-Max

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 for further details).

In the PhotoPlog index.php file find (two spots):
And replace with the following (in both spots):
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.

great service...

where can i buy my licence ;-)

Simple as that ;)

Go to the Download (Navbar) link => Click on Upgrade/Renew/Purchase. 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