wp_terms’ doesn’t exist ERROR upgrading to 2.3
-
I recently upgraded to latest version and categories and archieves dissapeared. Let me say that I had posts in more that one category. On my page I have this error several times:
(just a note: mainsite = username , mysite = my site address)
WordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
SELECT 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 (171) ORDER BY t.name ASCIf I try to edit a post and save I have this error:
WordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
SELECT t.term_id 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 (166) ORDER BY t.name ASCWordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
SELECT t.name 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 (‘post_tag’) AND tr.object_id IN (166) ORDER BY t.name ASCWordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
SELECT tr.term_taxonomy_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id IN (166) AND tt.taxonomy IN (‘category’) ORDER BY tr.term_taxonomy_id ASCWordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
SELECT term_id FROM wp_terms as t WHERE t.term_id = ‘1’WordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
SELECT term_id FROM wp_terms as t WHERE t.slug = ‘1’WordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
INSERT INTO wp_terms (name, slug, term_group) VALUES (‘1’, ‘1’, ‘0’)WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
SELECT tt.term_taxonomy_id FROM wp_term_taxonomy AS tt INNER JOIN wp_terms AS t ON tt.term_id = t.term_id WHERE tt.taxonomy = ‘category’ AND t.term_id = 0WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES (‘0’, ‘category’, ”, ‘0’, ‘0’)WordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id = ‘166’ AND term_taxonomy_id = ‘0’WordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES (‘166’, ‘0’)WordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships.object_id AND post_status = ‘publish’ AND post_type = ‘post’ AND term_taxonomy_id = ‘0’WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
UPDATE wp_term_taxonomy SET count = ” WHERE term_taxonomy_id = ‘0’WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
SELECT term_id, taxonomy FROM wp_term_taxonomy WHERE term_taxonomy_id IN (0)WordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
SELECT tr.term_taxonomy_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id IN (166) AND tt.taxonomy IN (‘post_tag’) ORDER BY tr.term_taxonomy_id ASCWordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
INSERT INTO wp_terms (name, slug, term_group) VALUES (”, ”, ‘0’)WordPress database error: [Table ‘mainsite.wp_terms’ doesn’t exist]
UPDATE wp_terms SET slug = ‘0’ WHERE term_id = ‘0’WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
SELECT tt.term_taxonomy_id FROM wp_term_taxonomy AS tt INNER JOIN wp_terms AS t ON tt.term_id = t.term_id WHERE tt.taxonomy = ‘post_tag’ AND t.term_id = 0WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES (‘0’, ‘post_tag’, ”, ‘0’, ‘0’)WordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id = ‘166’ AND term_taxonomy_id = ‘0’WordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES (‘166’, ‘0’)WordPress database error: [Table ‘mainsite.wp_term_relationships’ doesn’t exist]
SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships.object_id AND post_status = ‘publish’ AND post_type = ‘post’ AND term_taxonomy_id = ‘0’WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
UPDATE wp_term_taxonomy SET count = ” WHERE term_taxonomy_id = ‘0’WordPress database error: [Table ‘mainsite.wp_term_taxonomy’ doesn’t exist]
SELECT term_id, taxonomy FROM wp_term_taxonomy WHERE term_taxonomy_id IN (0)Warning: Cannot modify header information – headers already sent by (output started at /var/www/virtual/mysite.net/htdocs/wp-includes/wp-db.php:160) in /var/www/virtual/mysite.net/htdocs/wp-includes/pluggable.php on line 390
If I change the theme and deactivate all the plugins I have the same error, it`s not from a plugin. PLEASE HELP. Thanks!
- The topic ‘wp_terms’ doesn’t exist ERROR upgrading to 2.3’ is closed to new replies.