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

---

# b2 conversion issues

 *  [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 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 15 replies - 1 through 15 (of 20 total)

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

 *  Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64901)
 * no one?
 *  Moderator [Matt Mullenweg](https://wordpress.org/support/users/matt/)
 * (@matt)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64903)
 * These sound like errors that shouldn’t affect the operation. Does it work anyway?
 *  Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64905)
 * no, it doesnt
 *  Moderator [Matt Mullenweg](https://wordpress.org/support/users/matt/)
 * (@matt)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64909)
 * Don’t forget, if you’re upgrading from b2 the table prefix needs to be the same
   as it was under b2, so if your table names are b2posts, b2users, etc you need
   to make “b2” your prefix in `wp-config.php` and not “wordpress_” which is what
   you currently have.
 *  Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64911)
 * even with b2 as the prefix, it still comes up the same errors and doesnt convert
   over
 *  Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64918)
 * I now have it converted over… but it wont let me log in
    isnt this supposed to
   be easy?
 *  Moderator [Matt Mullenweg](https://wordpress.org/support/users/matt/)
 * (@matt)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64920)
 * Could you be more specific with regards to your login problems?
 *  Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64923)
 * i goto login but it looks for the login page in my root folder, when I copy wordpress
   into the root, it displays but when I log in, nothing happens… I’ve even tried
   to get a new password emailed to me, but that doesnt work either
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64924)
 * Are you trying to install into 2 directories ?
 *  Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64925)
 * no, i installed it into my original b2 directory, that being wwwroot/journal/,
   but the install is looking ofr item in the root for some reason
 *  [yoshy](https://wordpress.org/support/users/yoshy/)
 * (@yoshy)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64926)
 * after i ran import-b2.php at step 2 i got this :
    Step 2 First we’re going 
   to add excerpt, post, and password functionality… Database error: [Duplicate 
   column name ‘post_excerpt’] ALTER TABLE wpposts ADD COLUMN post_excerpt text 
   NOT NULL; Database error: [Duplicate column name ‘post_status’] ALTER TABLE wpposts
   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 wpposts DROP INDEX ID One down, two to go… Database error:[
   Table ‘stg_elves1.wpsettings’ doesn’t exist] ALTER TABLE wpsettings DROP INDEX
   ID So far so good. Database error: [Can’t DROP ‘post_karma’. Check that column/
   key exists] ALTER TABLE wpposts DROP post_karma Almost there… Database error:[
   Can’t DROP ‘ID’. Check that column/key exists] ALTER TABLE wpusers DROP INDEX
   ID Welcome to the family. Have fun! and it didnt do anything 🙁 didnt imported.
   i tried lots of times, different directories …i got bored of how many times i
   restored the db 😐 can anyone help ?
 *  Anonymous
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64942)
 * Hey Gregorsmith,
    I got the same set of errors when I got to STEP2 . How did 
   you get yours to work? Currently I installed WP and in the DB are a bunch of 
   tables, the old b2_ tables and a whole set of wp_ tables… Wordrpress does work,
   but didn’t convert my old b2 data oveer…
 *  Anonymous
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64944)
 * I got:
    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 ‘medfools_com.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!
 *  Thread Starter [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64946)
 * ok, from what I gather, before you install WP, rename the table to be “b2” or
   whatever your b2 tables were… not “b2_” as the default b2 table has on _ in it
   
   then run the import and it should work
 *  Anonymous
 * [21 years, 9 months ago](https://wordpress.org/support/topic/b2-conversion-issues/#post-64948)
 * actually, the exising b2 tables were “b2categories” etc…
    I tried chaning them
   to “b2_categories”, then installing WP, but no go. Should I have chanaged them
   to “wp_categories” etc… THEN tried to install WP

Viewing 15 replies - 1 through 15 (of 20 total)

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

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 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