Errors during “import-b2.php” 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 wea€?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

    (@stoofa)

    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

    (@stoofa)

    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.
    https://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.

    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 https://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.