• Resolved djenk

    (@djenk)


    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;

    https://wordpress.org/plugins/fg-joomla-to-wordpress/

Viewing 1 replies (of 1 total)
  • Plugin Author Kerfred

    (@kerfred)

    Please check if the mysql user nededw2 has the CREATE TEMPORARY TABLE privileges on the WordPress database.

Viewing 1 replies (of 1 total)
  • The topic ‘"Remove only new imported data" errors’ is closed to new replies.