Comments aren’t working

  • Resolved troubled

    (@troubled)


    17 years, 7 months ago

    I seem to have lost all of my comments.
    At the top of my blog is this: WordPress database error: [Table ‘./troubled_wordpress/wp_comments’ is marked as crashed and should be repaired]
    SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = ‘1’) WHERE post_status = ‘publish’ AND ID IN (185,184,183,182,181,180,179,178,177,176) GROUP BY ID.
    Under each blog where comments should be found is this: WordPress database error: [Table ‘./troubled_wordpress/wp_comments’ is marked as crashed and should be repaired]
    SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = ‘185’ AND comment_approved = ‘1’

    Anybody know what’s happening here?

Viewing 6 replies - 1 through 6 (of 6 total)
  • moshu

    (@moshu)

    17 years, 7 months ago

    If you have access to phpMyadmin you can try to repair those tables (there is a button = Repair) – or, you can contact your host (which I hope you did already).

    Thread Starter troubled

    (@troubled)

    17 years, 7 months ago

    Moshu,
    Thanks.
    I tried to find phpMyadmin on Fantastico which is on my CPanel. There is a link to actually install PHP but none labeled phpMyadmin. Do I need to contact my provider about this problem?

    moshu

    (@moshu)

    17 years, 7 months ago

    Just for the sake of clarity:
    – Fantastico is a gizmo to install different scripts. You don’t even have to think about it if you are NOT installing something.
    – cPanel is your site admin control panel. It does have a link to phpMyadmin.

    But if you are that much lost – contact your host…

    cori

    (@cori)

    17 years, 7 months ago

    Possible clarifiaction:
    phpMyAdmin would be available in CPanel if it were installed. It’s possible it’s not and your host would have you use Fantastico to install it so that it would be available, but if in doubt definitely contact your host….

    Thread Starter troubled

    (@troubled)

    17 years, 7 months ago

    Moshu,

    Thanks, I found it. The repair function is listed under MY SQL Databases.

    Thanks for your help.

    Thread Starter troubled

    (@troubled)

    17 years, 7 months ago

    Moshu,

    I checked the blog. That did the trick.

    Thanks for your help.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Comments aren’t working’ is closed to new replies.