Title: Errors during “import-b2.php” dare not continue
Last modified: August 18, 2016

---

# Errors during “import-b2.php” dare not continue

 *  [stoofa](https://wordpress.org/support/users/stoofa/)
 * (@stoofa)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/errors-during-import-b2php-dare-not-continue/)
 * OK, I’m still having fun and games attempting to get myself upgraded from b2 
   to WP 1.0.2
    I uploaded all of the required files and then simply ran the file(
   on the server): /wp-admin/upgrade.php This moaned about not having WP installed,
   so I actually installed the program (having remembered to change the prefix in
   the wp-config.php file to b2_) This seemed to work OK, there were no actual error
   messages that I could see. Next I ran /admin/upgrade.php once more and this time
   it looked a lot better, two pages and it told me everything was done. Finally
   I ran /wp-admin/import-b2.php and I’m afraid the results page looked a lot less
   friendly. Here is a copy & paste of the output at “Step 2”: Step 2 First weâ€
   ™re going to add excerpt, post, and password functionality… SQL/DB Error: [Duplicate
   column name ‘post_excerpt’] ALTER TABLE b2_posts ADD COLUMN post_excerpt text
   NOT NULL; SQL/DB Error: [Duplicate column name ‘post_status’] ALTER TABLE b2_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… SQL/DB Error: [Can’t DROP ‘ID’. Check that column/
   key exists] ALTER TABLE b2_posts DROP INDEX ID One down, two to go… SQL/DB Error:[
   Table ‘prawling_b21.b2_settings’ doesn’t exist] ALTER TABLE b2_settings DROP 
   INDEX ID So far so good. SQL/DB Error: [Can’t DROP ‘post_karma’. Check that column/
   key exists] ALTER TABLE b2_posts DROP post_karma Almost there… SQL/DB Error: [
   Can’t DROP ‘ID’. Check that column/key exists] ALTER TABLE b2_users DROP INDEX
   ID Welcome to the family. Have fun! And that is my current status. The link at
   the bottom of this output page “Have Fun” is a link to my Blog URL however I 
   dare not click it. In case something has gone badly wrong and then somebody tells
   me I need to hit a “back” button and make a change. Can anybody tell me if what
   I see above “matters” and what is likely to happen when I click the link to end
   the installation with the above “errors”? Cheers in advance.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [stoofa](https://wordpress.org/support/users/stoofa/)
 * (@stoofa)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/errors-during-import-b2php-dare-not-continue/#post-67542)
 * OK, so I had no option but to continue.
    WP is now installed, wahay!! None of
   my B2 posts are anywhere to be seen at all – I’ve got a totally empty Blog here.
   Any ideas what my next steps should be? I’ve got about five months worth of entries
   which “should” still be where they were, it’s just WP cannot in any way shape
   or form see them.
 *  Thread Starter [stoofa](https://wordpress.org/support/users/stoofa/)
 * (@stoofa)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/errors-during-import-b2php-dare-not-continue/#post-67543)
 * A final post before I call it a night and for the first time in a long time do
   so without a fully working website 🙂
    Here is a link to a screen capture of 
   my “php MyAdmin” screen showing the database in question. [http://www.cifi.com/images/phpmyadmin.jpg](http://www.cifi.com/images/phpmyadmin.jpg)
   You should be able to see where the “semi duplicate” tables are. If anybody could
   point me in the right direction on what to do next it would be most appreciated.
 *  [Hannes](https://wordpress.org/support/users/hannes/)
 * (@hannes)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/errors-during-import-b2php-dare-not-continue/#post-68598)
 * 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](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 3 replies - 1 through 3 (of 3 total)

The topic ‘Errors during “import-b2.php” dare not continue’ is closed to new replies.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 2 participants
 * Last reply from: [Hannes](https://wordpress.org/support/users/hannes/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/errors-during-import-b2php-dare-not-continue/#post-68598)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics