B2 0.6.2.1 to wordpress 1.5

  • Hi there ??

    I decided to switch my blog to WordPress. I tried to import my b2 files to the wp database but it failed :

    Step 2

    First wea€?re going to add excerpt, post, and password functionality…

    WordPress database error: [Duplicate column name ‘post_excerpt’]
    ALTER TABLE wp_posts ADD COLUMN post_excerpt text NOT NULL;

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

    WordPress database error: [Can’t DROP ‘ID’. Check that column/key exists]
    ALTER TABLE wp_posts DROP INDEX ID

    One down, two to go…

    So far so good.

    WordPress database error: [Can’t DROP ‘post_karma’. Check that column/key exists]
    ALTER TABLE wp_posts DROP post_karma

    Almost there…

    WordPress database error: [Can’t DROP ‘ID’. Check that column/key exists]
    ALTER TABLE wp_users DROP INDEX ID

    How can i fix that ?

    Thanks in advance.

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

  • I’m also encountering problems in this area, but my errors are different than yours [ https://www.ads-software.com/support/topic.php?id=24785 ]. From reading the MySql, it seems that maybe you might’ve run through the installation twice? Either that, or something stopped the installation before you finished. Some of the fields already exist, whereas others do not.

    I would suggest cleaning your database and importing your b2 tables back and giving it another shot.

    Reply back after you’ve done that and lets see if we can figure this baby out.

    Thread Starter utena

    (@utena)

    Thks for your quick answer, did you solve your problem ?

    I’ve just clean my database, reinstall WP and run the b2import file.
    And the same error appears.
    That’s really weird.

    Utena, did you run the install.php first? That should be done before you run the upgrade/import.

    First run the install, then run the sql statements on your mysql server, then run the b2upgrade…

    Here’s a link to the mysql statements:
    https://www.wild-mind.net/archives/2004/09/12/changing-from-b2-to-wordpress/

    No, I haven’t solved my problem. But what I’m currently trying is installing an OLDER version of wordpress (you can find it on sourceforge.net) and then importing my b2 stuff… and then upgrading to the current version of wordpress. Will let you know if it works out.

    UTENA!!! I GOT IT WORKING!!

    start with a clean db, with your b2 tables intact

    (1) I downloaded an older version found here: 1.0.2
    https://sourceforge.net/project/showfiles.php?group_id=51422

    (2) run the installation, log-in… change your password from the default

    (3) run the mysql statements on your server
    DROP TABLE wp_categories;
    DROP TABLE wp_comments;
    DROP TABLE wp_posts;
    DROP TABLE wp_settings;
    DROP TABLE wp_users;
    RENAME TABLE b2categories TO wp_categories;
    RENAME TABLE b2comments TO wp_comments;
    RENAME TABLE b2posts TO wp_posts;
    RENAME TABLE b2settings TO wp_settings;
    RENAME TABLE b2users TO wp_users;

    ignore any errors…

    (4) then log-in…

    now i face the challenge to upgrade to 1.5 from 1.0.2….. something tells me it will be easier than upgrading from b2 0.6.2.1

    good luck

    Thread Starter utena

    (@utena)

    Yea i’ve installed WP before importing my b2 files. I tried to solve the problem with Wild-mind advices but the tables dont match with Wp1.5. For example,wp- settings doesnt exist. Datas were imported, but I’ve errors.

    I’ll try to install an older Wp version, too ??

    Thread Starter utena

    (@utena)

    THANK YOU !!!
    I try it now !

    Okay… I just upgraded from 1.0.2 to 1.5 (FLAWLESSLY)..

    I just hope other users upgrading from b2 0.6.2.1 know about this solution. It’s much easier than hacking at your brain and wondering why you’re getting errors. The best thing to do is upgrade to an older version of wordpress and then upgrade to the latest.

    Thread Starter utena

    (@utena)

    It worked ?? The b2 import worked !!!
    Now i’m upgrading to wp 1.5

    THX A LOT !

    Well, I finally managed it aswell…

    Starting with msangapu’s guide at https://www.ads-software.com/support/topic/24942

    I simply had to add some steps to make it work with 1.5.1.2…

    3.5) run wp-admin/b2-import.php
    5) remove all wp1.0.2 files
    6) install the wp1.5.x (latest) files
    7) run wp-admin/upgrade.php

    It took a while to get to this solution, but finally my pages are “a-okay” again… atleast content wise…

    Now to port all my fancy modified templates from b2 to wordpress… (which just takes time… time I haven’t got :lol:)

    Err… add
    6.5) Create the wp-config.php file
    ??

    Thanks msangapu!!!

    I ran into some problems when running the mysql statements though. I solved it by running this instead: (I didn’t have wp_settings)

    DROP TABLE wp_categories;
    DROP TABLE wp_comments;
    DROP TABLE wp_posts;
    DROP TABLE wp_users;
    RENAME TABLE b2categories TO wp_categories;
    RENAME TABLE b2comments TO wp_comments;
    RENAME TABLE b2posts TO wp_posts;
    RENAME TABLE b2settings TO wp_settings;
    RENAME TABLE b2users TO wp_users;

    Yeah wp_settings was replaced by wp_options in some version, but if you run each of these commands manually it won’t “break” – even if it gives an error on the wp_settings thing.

    I wonder if the b2settings really should have been renamed to wp_options though…

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘B2 0.6.2.1 to wordpress 1.5’ is closed to new replies.