bob58

Take a look at the following:

https://www.wp-plugins.net/wiki/index.php?title=SK2
(Spam Karma)

Or at the Codex:
https://codex.www.ads-software.com/Combating_Comment_Spam

There are different ways of getting rid of the spam described.

The only thing I can tell you is: Your theme works quite the standard way …

Hah! I have an idea, when updating to 2.0 RC1, did you run /wp-admin/upgrade.php ???

The comment_count is a new field for Release 2 …

This Drop command tells the database to drop (delete) the given table if it already exists.

The name in front of the @ should be your (DB) user name, after the @ should be the the name of the server (db.speakeasy.net).

Are the second and the third XXXXX… the same as the first (your username) ?

You have to provide the database name, the (DB) server name and the username as well as the password in wp-config.php.

Can you double check them (especially the server name) ?

And ask the database guys if they have granted your user all the rights in your database. That’s the most likely reason for the error …

Do you have access to your database ?
There must be a difference between the older and the new entries (the ones with correct amount of comments and the ones with zero).

Congrats !

Can you just send me the code from index.php (see above) to bobsblogger at gmail dot com ?

Maybe, I can see something’s goind wrong …

It’s problematic using the RC for a productional blog (I do so, but I’m living on the edge ;-)).

Did you have this problem since upgrading to 2.0 RC1 or did it occur later ?

Downgrading without a DB backup is nearly impossible. Go back to RC1 and try one additional thing: Use the standard theme and see if it displays the comment count correctly.

If you login as admin, you can change the user data of the admin. Posts are provided with the current settings. I never tried it, but I think, comments have to be changed by hand / sql.

Just give it a try.

First: A post “knows” it’s category-ID.
Usually, you should change your templates (there is a line, where the date is displayed (for example in index.php).

Change it to something like that:

<?php
if (in_category(4))
{
echo "posted on " . the_time('l, d.m.Y');
}
?>


That has to be done on every page in your theme where the date is / should be displayed.

Sorry, but I have no Idea, how ecto works … it might be a problem with the RC of WordPress as well as a problem with ecto in general.

Can you have a look into themes -> theme editor -> main index page ? There is a line which usually generates the comment link and count (maybe comment_popup_link(…)).

I read, you just have recently installed ecto. Is it possible, that ecto screws up the field comment_count in the table wp_posts ?
As far as I got it, the number of comments is taken from that field, not from counting the comments.

Which version of WordPress are you using ?
And what does the code for displaying the number of comments in your template look like (I think, it’s in index.php) ?

What exactly is going wrong ?
I see older comments (i.e. at You’ve got mail) … is the problem, that new ones do not appear ?

May it be, that they are marked as spam or waiting for moderation ?

UPDATE wp_posts
SET comment_status = ‘open’
, ping_status = ‘open’;

If you are using a different prefix, you have to put it in instead of ‘wp_’.

Sorry, to switch them all off, set the _status to ‘closed’;

I think, the error comes from CachedFileReader in stream.php. Is your localisation file available at the given directory (I think, wp-content/languages) and is the entry in wp-config.php spelled correctly (especially lower an upper case) ?