Title: b2 conversion not working
Last modified: August 18, 2016

---

# b2 conversion not working

 *  [washablemarker](https://wordpress.org/support/users/washablemarker/)
 * (@washablemarker)
 * [21 years, 10 months ago](https://wordpress.org/support/topic/b2-conversion-not-working/)
 * I recently installed WordPress into the same database that I am currently running
   b2 in. I followed the conversion steps, the first step went fine. On the second
   step, every action had DATABASE ERROR: beside it, the text on the screen after
   the second step is as follows:
    —————————– start quote——————————- 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 ‘sarah_b2.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! ———————————–end quote——————– Since 
   it said that all was well at the end, I assumed it had fixed whatever database
   errors it had found, but when I logged back in to WordPress, my old entries hadn’t
   been added. What’s going on?

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

 *  [gregorsmith](https://wordpress.org/support/users/gregorsmith/)
 * (@gregorsmith)
 * [21 years, 10 months ago](https://wordpress.org/support/topic/b2-conversion-not-working/#post-66890)
 * I had this error too…
    what you do is ignore the documentation before installing
   wordpress, rename the field prefix to whatever your b2 field prefix (the default
   being ‘b2’) and upload the files to the root directory of your webspace (very
   important you do this as it looks sfor everything in the root, i made the mistake
   of installing into my b2 folder and couldnt login afterwards) now run the import-
   b2.php file and everything should be working ok, login using your b2 username
   and password
 *  [unoamigo](https://wordpress.org/support/users/unoamigo/)
 * (@unoamigo)
 * [21 years, 10 months ago](https://wordpress.org/support/topic/b2-conversion-not-working/#post-66892)
 * Yeah, you just have the wrong table prefix.
    Instead of ‘wp_’, you probably just
   want ‘b2’ Otherwise, it looks like your doing just fine.

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

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [unoamigo](https://wordpress.org/support/users/unoamigo/)
 * Last activity: [21 years, 10 months ago](https://wordpress.org/support/topic/b2-conversion-not-working/#post-66892)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics