Comments NOT counting

Gus Greeper · Post by **Gus Greeper** » Wed Feb 22, 2006 11:52 pm

my full amount of comments are not counting. they haven't been for a few days. is this happening to anyone else?

iam very GREEEEEEEEEEEN.

i can't even figure out how to upgrade my damn program...AT ALL, im STILL on 0.9-alpha3. i didn't set the site up and the person who did is not availible to help me with upgrading etc. i'd appreaite any help. im looking for a very kind person to help me out please as i've gotta start from the basics.

thanks!

http://www.gusgreeper.com

Post by **garvinhicking** » Thu Feb 23, 2006 10:53 am

Hm, which "full amount of comments" do you mean? I just made a comment on "Boredom thoughts" and the comment counter increased to '7' alright...

Regards,
Garvin

Gus Greeper · Post by **Gus Greeper** » Thu Feb 23, 2006 7:18 pm

thank you for looking.

you just happened to get one that was correct

i think i mentioned it is kind of random.
if you go back you'll notice on the second page in the post called:

WARNING – this post contains literature of a graphic nature – but read it anyway damnit = 29 comments/ showing 27

same page: no posts? = 14 comments/showing 13

back to the front main page from the top:

She Won’t Stop Meowing About It = 16 comments/showing 15

and last example but there are more is:

Kill the Lights = 13 comments says 12

i gots no idea!?!

at first i thought i just wasn't counting MY responses but that is not it.
thanks so much for any help you can offer !

i guess i'll get this sorted out before i even look at updating the program.

Post by **garvinhicking** » Thu Feb 23, 2006 8:41 pm

Is your blog using postgresql or mysql or sqlite?

The comment count increases/decreases depending on whether you delete comments or whether comment moderation for an entry is turned on. The comment count is not calculated dynamically, but rather fetched from the 'comments' column of the serendipity_entries database table.

We've had sporadic reports from postgresql users where a wrong comment count happened, but I believe some things have been addresses in the 0.9 final release there.

However upgrading to 0.9 will not correct the comment count; it will just (hopefully) not get the comment counter off by numbers in future cases. You might want to try that.

On this forums somebody once posted a SQL statement to fix the comment_count by selecting the real numbers of comments, it was:

Code: Select all

UPDATE serendipity_entries AS e SET e.comments = (SELECT count(c.entry_id) FROM serendipity_comments AS c WHERE c.entry_id = e.id AND c.status = 'approved')

HTH,
Garvin

Gus Greeper · Post by **Gus Greeper** » Fri Feb 24, 2006 12:12 am

ok, that makes no sense to me at all. BUT i still thank you for your time and response.

this is what is really sucking having someone else set the damn site up for me and now i can't trouble shot and i can't upgrade.
now that first post on the front page has 17 comments and is STILL showing 15.
what you responded with i don't know even know where to add that NOTHING.

im trying to get my friend to help me but he just happens to go to 'the' film school in North America and doesn't have the time for me....i will be switching to a s9y suggested host company, mine sucks so bad people can hardly get on the damn site....
im just pissed someone builds me a website it gets popular and NOW i can't do dick all with it. sorry for the vent...you MAY have noticed im pretty fresh out of surgery...if you went to page 2.

ok well, thank you for your response i have no idea what to do with it..i'll have to hope my friend gets back to me.

i almost wish you charged like host compaines do so i could just pay someone to do all this shit for me....granted i LEARN very very fast i just need direction that makes laymen sense to me.

Brendon K · Post by **Brendon K** » Fri Feb 24, 2006 4:52 am

I don't have the time right now to go through all these steps to give you laymen's terms, but perhaps you would be able to take some time out of your day and go through this yourself?

I did a search for what garvin posted and found the following:
http://www.s9y.org/forums/viewtopic.php ... tries++set

I believe that was the article he was referring to, and it's a bit more detailed.

Gus Greeper · Post by **Gus Greeper** » Fri Feb 24, 2006 4:57 am

thank you kindly!
it is not that i don't enjoy learning it...it is that i don't even know where to start.
so thank you...hopefully this helps get me on my way.

Brendon K · Post by **Brendon K** » Fri Feb 24, 2006 5:02 am

Goodluck. I'm going to bed.

Let us know how you make out (after trying a few times, of course) and if you can't figure it out, reply so we can try and give you a better explanation that might help solve your issue.

Post by **garvinhicking** » Fri Feb 24, 2006 2:15 pm

Hi Gus!

Without technical knowledge, this is a bit of a problem, as I cannot reproduce your error.

I can only offer you to look into your installation if you give me FTP access to your blog. You must decide if you want to do that, and contact me privately in case you want that.

Thanks also to Brendon for jumping in!

Best regards,
Garvin