Forum Replies Created

Viewing 1 replies (of 1 total)
  • Forum: Fixing WordPress
    In reply to: importing from b2

    exact same error mesasge
    Step 2

    First we’re going to add excerpt, post, and password functionality...
    Database error: [Duplicate column name 'post_excerpt']
    ALTER TABLE wp_posts ADD COLUMN post_excerpt text NOT NULL;
    Database error: [Duplicate column name 'post_status']
    ALTER TABLE wp_posts ADD post_status ENUM('publish','draft','private') NOT NULL, ADD comment_status ENUM('open','closed') NOT NULL, ADD ping_status ENUM('open','closed') NOT NULL, ADD post_password varchar(20) NOT NULL;
    That went well! Now let's clean up the b2 database structure a bit...
    Database error: [Can't DROP 'ID'. Check that column/key exists]
    ALTER TABLE wp_posts DROP INDEX ID
    One down, two to go...
    Database error: [Table 'jmetropo_clio.wp_settings' doesn't exist]
    ALTER TABLE wp_settings DROP INDEX ID
    So far so good.
    Database error: [Can't DROP 'post_karma'. Check that column/key exists]
    ALTER TABLE wp_posts DROP post_karma
    Almost there...
    Database error: [Can't DROP 'ID'. Check that column/key exists]
    ALTER TABLE wp_users DROP INDEX ID
    Welcome to the family. Have fun!
    except nothing’s been imported!

Viewing 1 replies (of 1 total)