phpMyAdmin WP Tables that refer to wp_comments table (1 post)

  1. stevevbc
    Posted 7 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic