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)
  • Thread Starter gregorsmith

    (@gregorsmith)

    no one?

    These sound like errors that shouldn’t affect the operation. Does it work anyway?

    Thread Starter gregorsmith

    (@gregorsmith)

    no, it doesnt

    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

    (@gregorsmith)

    even with b2 as the prefix, it still comes up the same errors and doesnt convert over

    Thread Starter gregorsmith

    (@gregorsmith)

    I now have it converted over… but it wont let me log in
    isnt this supposed to be easy?

    Could you be more specific with regards to your login problems?

    Thread Starter gregorsmith

    (@gregorsmith)

    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

    Are you trying to install into 2 directories ?

    Thread Starter gregorsmith

    (@gregorsmith)

    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

    after i ran import-b2.php at step 2 i got this :
    Step 2
    First wea€?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 ?

    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…

    I got:
    Step 2
    First wea€?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

    (@gregorsmith)

    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

    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)
  • The topic ‘b2 conversion issues’ is closed to new replies.