"Remove only new imported data" errors
-
I’m trying to remove the newly imported data but keep getting errors. The connection to the database tests just fine. I get the popup that says “Content removed from WordPress” but this is in the log: (i changed the domain name to “xxxxxx”)
=== START empty 2016-06-28 16:44:23 ===
WordPress content removed
=== END empty 2016-06-28 16:44:39 ===WordPress database error: [Access denied for user ‘nededw2’@’localhost’ to database ‘www2_xxxxxx_org_working’]
CREATE TEMPORARY TABLE IF NOT EXISTS wp_fg_data_to_delete (id
bigint(20) unsigned NOT NULL, PRIMARY KEY (id
) ) DEFAULT CHARSET=utf8;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
INSERT IGNORE INTO wp_fg_data_to_delete (id
) SELECT post_id FROM wp_postmeta WHERE meta_key LIKE ‘_fgj2wp_%’WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
— Delete Comments and Comment metas DELETE c, cm FROM wp_comments c LEFT JOIN wp_commentmeta cm ON cm.comment_id = c.comment_ID INNER JOIN wp_fg_data_to_delete del WHERE c.comment_post_ID = del.id;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
— Delete Term relashionships DELETE tr FROM wp_term_relationships tr INNER JOIN wp_fg_data_to_delete del WHERE tr.object_id = del.id;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
— Delete Posts Children and Post metas DELETE p, pm FROM wp_posts p LEFT JOIN wp_postmeta pm ON pm.post_id = p.ID INNER JOIN wp_fg_data_to_delete del WHERE p.post_parent = del.id;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
— Delete Posts and Post metas DELETE p, pm FROM wp_posts p LEFT JOIN wp_postmeta pm ON pm.post_id = p.ID INNER JOIN wp_fg_data_to_delete del WHERE p.ID = del.id;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
TRUNCATE wp_fg_data_to_delete;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
INSERT IGNORE INTO wp_fg_data_to_delete (id
) SELECT term_id FROM wp_termmeta WHERE meta_key LIKE ‘_fgj2wp_%’WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
— Delete Terms, Term taxonomies and Term metas DELETE t, tt, tm FROM wp_terms t LEFT JOIN wp_term_taxonomy tt ON tt.term_id = t.term_id LEFT JOIN wp_termmeta tm ON tm.term_id = t.term_id INNER JOIN wp_fg_data_to_delete del WHERE t.term_id = del.id;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
TRUNCATE wp_fg_data_to_delete;WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
INSERT IGNORE INTO wp_fg_data_to_delete (id
) SELECT comment_id FROM wp_commentmeta WHERE meta_key LIKE ‘_fgj2wp_%’WordPress database error: [Table ‘www2_xxxxxx_org_working.wp_fg_data_to_delete’ doesn’t exist]
— Delete Comments and Comment metas DELETE c, cm FROM wp_comments c LEFT JOIN wp_commentmeta cm ON cm.comment_id = c.comment_ID INNER JOIN wp_fg_data_to_delete del WHERE c.comment_ID = del.id;
- The topic ‘"Remove only new imported data" errors’ is closed to new replies.