WP DB error: wp_terms doesen’t exist

  • Hey, the plugin throws an error for me:

    WordPress database error: [Table ‘myDB.wp_terms’ doesn’t exist]
    SELECT object_id, t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’) AND tr.object_id IN (0)

    I do have table prefix, so my terms table is nx_terms instead of wp_terms.
    If I modify the /easyindex/lib/EasyIndex.php on line 1043-1044 to:

    $q = "SELECT object_id, t.*, tt.* FROM MYDBPREFIX_terms AS t INNER JOIN MYDBPREFIX_term_taxonomy AS tt ON tt.term_id = t.term_id ";
$q .= "INNER JOIN MYDBPREFIX_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id ";

    And I do the same modification in EasyIndexIndex.php line 1067-1068, then the error disappears.
    Cheers!

    • This topic was modified 4 years, 4 months ago by Koli14.
    • This topic was modified 4 years, 4 months ago by Koli14.
    • This topic was modified 4 years, 4 months ago by Koli14.
Viewing 1 replies (of 1 total)

  • I am getting the same error and my site has slowed to a crawl. My ISP sent this message to me:

    That error is saying that the database table wp_terms doesn’t exist. The problem with that is the database doesn’t use that table, it uses wp_7hxc6uni19_terms. There seems to be a plugin that is poorly coded and it is assuming the database prefix.

    I’m not sure what to do next. This is a serious problem for my site because I use EasyIndex in many places.

Viewing 1 replies (of 1 total)
  • The topic ‘WP DB error: wp_terms doesen’t exist’ is closed to new replies.

Tags