• I get to step 2 and it says
    Database error: [Duplicate column name ‘post_excerpt’]
    ALTER TABLE wordpress_posts ADD COLUMN post_excerpt text NOT NULL;
    Database error: [Duplicate column name ‘post_status’]
    ALTER TABLE wordpress_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 wordpress_posts DROP INDEX ID
    One down, two to go…
    Database error: [Table ‘scamcity.wordpress_settings’ doesn’t exist]
    ALTER TABLE wordpress_settings DROP INDEX ID
    So far so good.
    Database error: [Can’t DROP ‘post_karma’. Check that column/key exists]
    ALTER TABLE wordpress_posts DROP post_karma
    Almost there…
    Database error: [Can’t DROP ‘ID’. Check that column/key exists]
    ALTER TABLE wordpress_users DROP INDEX ID
    Welcome to the family. Have fun!
    What am I doing wrong?

Viewing 5 replies - 16 through 20 (of 20 total)
  • Then I altered the config.php script to use “b2” as the table prefix in my DB, and with the 6 existing B2 tables in there, it says that I already have WP installed, yet it won’t run

    If I go ahead and try to run the conversion script after having 6 b2 tables in the DB, with the config script changed to the “b2” prefix, then I get tons of DB errors…

    isnt there a conversion readme which sais EXACTLY what you have to do ?

    anyone ???

    Hannes

    (@hannes)

    hi all, i have made script for converting b2 to WordPress (posts, categories, comments). Many of you here were having problems with original script, which wasnt working (and no respond from the creators of the WordPress of course), so this should solve your problem. You can download it at http://www.czhannes.com/b2_wordpress_import.rar . Upload it to folder /wp-admin/ on your server, open in browser and read the instructions…

    Hannes

Viewing 5 replies - 16 through 20 (of 20 total)

The topic ‘b2 conversion issues’ is closed to new replies.