I’ve got the same problem. Actually the comment is displaying in the database and underneath the post. But it still says “no comment”
Anybody got a idea? i also use the Spam Karma 2 plugin, but that also says that comments are approved.
This is the default WP20 table.
wp_comments
Field Type Null Default
comment_ID bigint(20) No
comment_post_ID int(11) No 0
comment_author tinytext No
comment_author_email varchar(100) No
comment_author_url varchar(200) No
comment_author_IP varchar(100) No
comment_date datetime No 0000-00-00 00:00:00
comment_date_gmt datetime No 0000-00-00 00:00:00
comment_content text No
comment_karma int(11) No 0
comment_approved enum(‘0’, ‘1’, ‘spam’) No 1
comment_agent varchar(255) No
comment_type varchar(20) No
comment_parent bigint(20) No 0
user_id bigint(20) No 0
Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 1 comment_ID
comment_approved INDEX 1 comment_approved
comment_post_ID INDEX 1 comment_post_ID
This is the commenttable from the updated 1.5.2 to 2.0 db.
wp_comments
Veld Type Null Standaardwaarde
comment_ID bigint(20) Nee
comment_post_ID int(11) Nee 0
comment_author tinytext Nee
comment_author_email varchar(100) Nee
comment_author_url varchar(200) Nee
comment_author_IP varchar(100) Nee
comment_date datetime Nee 0000-00-00 00:00:00
comment_date_gmt datetime Nee 0000-00-00 00:00:00
comment_content text Nee
comment_karma int(11) Nee 0
comment_approved enum(‘0’, ‘1’, ‘spam’) Nee 1
comment_agent varchar(255) Nee
comment_type varchar(20) Nee
comment_parent bigint(20) Nee 0
user_id bigint(20) Nee 0
Indices :
Sleutelnaam Type Kardinaliteit Veld
PRIMARY PRIMARY 176 comment_ID
comment_approved INDEX 2 comment_approved
comment_post_ID INDEX 88 comment_post_ID
The Nee, is No in dutch, the PhpMyAdmin on this server is dutch, but should be the problem i guess…
