Comments aren’t working

  • Resolved troubled

    (@troubled)


    18 years, 2 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)

  • 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)

    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?

    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…

    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)

    Moshu,

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

    Thanks for your help.

    Thread Starter troubled

    (@troubled)

    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.