Support » How-To and Troubleshooting » phpMyAdmin WP Tables that refer to wp_comments table

phpMyAdmin WP Tables that refer to wp_comments table

  • I have deleted my wp_comments table from phpMyAdmin.

    Instead of the normal 9, I now just have 8 tables in phpMyAdmin.

    Apparently there are other tables that must link to or reference the comments table because I now get an error message on my website.

    Does anyone know which tables refer to the wp_comments table and which functions I need to disable from those tables so they will no longer refer to the wp_comments table.

    This is the first error message I get:

    Table ‘_wp1.wp_comments’ doesn’t exist]
    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 (12) GROUP BY ID

    This is the other:

    [Table ‘_wp1.wp_comments’ doesn’t exist]
    SELECT comment_author, comment_author_url, comment_ID, comment_post_ID FROM wp_comments WHERE comment_approved=’1′ ORDER BY comment_date_gmt DESC LIMIT 5

    I have deleted most other comment sections from the WP Dashboard

  • The topic ‘phpMyAdmin WP Tables that refer to wp_comments table’ is closed to new replies.