Title: b2 conversion issues
Last modified: August 18, 2016

---

# b2 conversion issues

 *  [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/b2-conversion-issues/)
 * 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)

[←](https://wordpress.org/support/topic/b2-conversion-issues/?output_format=md) 
[1](https://wordpress.org/support/topic/b2-conversion-issues/?output_format=md) 
2

 *  Anonymous
 * [21 years, 11 months ago](https://wordpress.org/support/topic/b2-conversion-issues/page/2/#post-64950)
 * 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
 *  Anonymous
 * [21 years, 11 months ago](https://wordpress.org/support/topic/b2-conversion-issues/page/2/#post-64952)
 * 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…
 *  [yoshy](https://wordpress.org/support/users/yoshy/)
 * (@yoshy)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/b2-conversion-issues/page/2/#post-64969)
 * isnt there a conversion readme which sais EXACTLY what you have to do ?
 *  Anonymous
 * [21 years, 11 months ago](https://wordpress.org/support/topic/b2-conversion-issues/page/2/#post-65017)
 * anyone ???
 *  [Hannes](https://wordpress.org/support/users/hannes/)
 * (@hannes)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/b2-conversion-issues/page/2/#post-65191)
 * 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 5 replies - 16 through 20 (of 20 total)

[←](https://wordpress.org/support/topic/b2-conversion-issues/?output_format=md) 
[1](https://wordpress.org/support/topic/b2-conversion-issues/?output_format=md) 
2

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

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 20 replies
 * 6 participants
 * Last reply from: [Hannes](https://wordpress.org/support/users/hannes/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/b2-conversion-issues/page/2/#post-65191)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics