Support » Installing WordPress » Upgrading from b2 to WP problems

  • Downloaded WP 1.0.2 for upgrade from b2 v0.6.1.
    Going through the WP readme file, the “Upgrading from b2 v0.6.1/v0.6.2.2 to WordPress v1.0.2:” section:
    – I backed up my database.
    – Configured wp-configure.php
    – “All you really have to do is replace all the files with newer versions and run wp-admin/upgrade.php and you should be ready to go.” -> didn’t understand this, so uploaded all files. Went to wp-admin/upgrade.php and it told me WP wasn’t installed. So I installed the program.
    – “There is also an import script at wp-admin/import-b2.php.” -> Went here next, and it gave me loads of errors:
    First we’re going to add excerpt, post, and password functionality…
    SQL/DB Error:
    [Duplicate column name ‘post_excerpt’]
    ALTER TABLE wp_posts ADD COLUMN post_excerpt text NOT NULL;
    SQL/DB 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…
    SQL/DB Error:
    [Can’t DROP ‘ID’. Check that column/key exists]
    ALTER TABLE wp_posts DROP INDEX ID
    One down, two to go…
    SQL/DB Error:
    [Table ‘intrinz_b2.wp_settings’ doesn’t exist]
    ALTER TABLE wp_settings DROP INDEX ID
    So far so good.
    SQL/DB Error:
    [Can’t DROP ‘post_karma’. Check that column/key exists]
    ALTER TABLE wp_posts DROP post_karma
    Almost there…
    SQL/DB Error:
    [Can’t DROP ‘ID’. Check that column/key exists]
    ALTER TABLE wp_users DROP INDEX ID
    Welcome to the family. Have fun!
    – Now my blog looks the same as when I first installed it.
    I’d just like to say the readme file for upgrading from b2 to wp is crap – I didn’t understand it and now look what’s happened. It should be step-by-step, to avoid problems like this.
    Please help me fix this? I don’t know what to do next.

Viewing 15 replies - 1 through 15 (of 39 total)
  • Thread Starter tinuviel

    (@tinuviel)

    So no clues on why my installation/upgrade didn’t work? Where should I go to find out???

    i’ve got the exact same problem. it looks like all db my info is still there. i uploaded my old b2 index page (now creatively named b2index.php), and it picks up everything. but the wp index page still just has “Welcome to WordPress. This is the first post. Edit or delete it, then start blogging!” if i figure it out i’ll post here, but it would be nice to hear from someone that’s done this upgrade before.

    i decided to try moving some of my database info over manually, i started with the categories since it’s a small table and not dependant on anything (i think). so i dumped b2categories, fixed the SQL statement to add the extra 3 columns, inserted it into wp_categories…and nothing. i still only see “general” on index.php, although they all show up fine under /wp-admin/categories.php. hmmmmmm, any ideas? dumping the comments over seems to be working though. haven’t tried dumping b2posts yet.
    i’d still like to know what’s wrong with the b2import script, even if it’s my own ignorance. if i’d known upgrading was going to be this much of a hassle i would have prepared my db info beforehand, or possibly put the whole thing off longer.

    These are the same errors I am experiencing. Any luck?

    Ditto, I’m getting the same errors. Does ANYBODY have the answer to this problem??

    I just checked and all of those tables have already been created. So that’s not my problem at least. And I’m still having the same issues. Can anybody else think of a reason we might all be having this issues??

    Well, I went ahead an imported all of my old blogger files into WP and it was a flawless, simple process… If somebody could PLEASE let us know how to get b2 to do the same I’d be ever so greatful. Having all of my old blog posts into ONE program is almost too good to be true!!

    Well that echo looks fine to me. It is just Wp telling you what it is doing and it seems fine, but you need to follow the link to the next step of the install surely?

    arianwen: When i do so i get this error: You appear to already have WordPress installed. If you would like to reinstall please clear your old database files first.
    But i had already dropped all we_ files from the database.. any idea? my old b2 files are still in the database.

    Aziza,
    Hi had the same problem… If I change the
    // Change the prefix if you want to have multiple blogs in a single database.
    $table_prefix = ‘b2’; // example: ‘wp_’ or ‘b2’ or ‘mylogin_
    then it also says i already have WP installed.
    If I keep the default table_prefix as ‘wp_’ then it installs fine, but I get a ton of errors when I try to run the importb2 script

    Finally got something to work!
    Installed WP per instructions, left the $table prefix as “wp_”
    renamed the 6 existing b2 tables to : “wp_TABLENAME”
    Then using phpmyadmin deleted all tables that would have been repetitive.
    Then ran the inportb2 script and seemed to work.
    I got one error, but when I run it, WP looks ok, and I get my data from b2 converted!

    I’m suprised how good wordpress looks and works but how bad the support is. The support forums suck compared to phpBB (from b2 support forum) and the readme has no info on importing from b2.

    @anon – if there is an answer here, you will get it, as will anyone else. If answers for your issues have not been forthcoming, it’s not because you are being ignored, it’s because your problems, and how to work around them are unknown to those looking to provide answers.
    Many others may have worked around this, but unless they return here and offer their wisdom, we are left without the answer.
    There may be scant information in the readme, but there is a wealth of information in these forums and also in the Wiki.
    I hope we can help you better with any issues you have with WordPress 🙂

    i was having the same problem and tried everything listed here. nothing worked. rather than fight it i just wrote a conversion script in perl that takes everything from a b2* table into it’s wp_* equivalent.
    http://www.gamehaus.net/docs/b2/convert_b2_to_wordpress.pl
    i recommend you delete everything in the wp tables first. well.. errr.. back your stuff up first. and grab your password value from the old database, i couldn’t replicate the encryption (easily). if you don’t know how to run a perl script don’t ask me b/c i don’t know either 😉

    I’m afraid at the end of the day the best solution I found with upgrading from B2 to WP is don’t!
    Because support on b2 had finished I too decided it was time to upgrade to WP.
    The instructions, all five points of them seemed easy enough but as a lot of people in this thread will say – those five points are simply not enough.
    If you’re a complete novice with MySQL and php (as I am) then those five points of an install and convert guide are nothing more than dangerous.
    In the end I took a much more radical approach.
    It took me a couple of days, but the end result is that it worked.
    I copied and pasted all of my entries from my blog (about 4 months worth) into MS Word.
    I then totally removed b2 from my website and did a clean, totally fresh, none-upgrade install of WP.
    Finally I upgraded to WP 1.2 and then I copied & pasted each of my blog entries back, using the “Change Timestamp” option for each one.
    Sure it took me 2-3 days to get all of the entries back in, however it ihas taken some people longer than that to get an upgrade working!!

Viewing 15 replies - 1 through 15 (of 39 total)
  • The topic ‘Upgrading from b2 to WP problems’ is closed to new replies.