WordPress.org

Ready to get started?Download WordPress

Forums

new COMMENT DOES NOT APPEAR in wp2.0 (i've just upgraded.) (2 posts)

  1. alwaysfine
    Member
    Posted 8 years ago #

    i've just upgraded to wp2.0 from 1.5.2.
    and When new comment is leaved, it's in DB. but it's not appeared.
    so can't write comments.

    how do i do?

  2. chapter
    Member
    Posted 8 years ago #

    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...

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.