WordPress.org

Ready to get started?Download WordPress

Forums

Upgrading from b2 to WP problems (40 posts)

  1. tinuviel
    Member
    Posted 10 years ago #

    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.

  2. tinuviel
    Member
    Posted 10 years ago #

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

  3. padre
    Member
    Posted 10 years ago #

    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.

  4. padre
    Member
    Posted 10 years ago #

    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.

  5. Eurcynia
    Member
    Posted 10 years ago #

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

  6. Antigone
    Member
    Posted 10 years ago #

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

  7. Antigone
    Member
    Posted 10 years ago #

    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??

  8. Antigone
    Member
    Posted 10 years ago #

    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!!

  9. Root
    Member
    Posted 10 years ago #

    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?

  10. Aziza
    Member
    Posted 10 years ago #

    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.

  11. Anonymous
    Unregistered
    Posted 10 years ago #

    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

  12. Anonymous
    Unregistered
    Posted 10 years ago #

    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!

  13. Anonymous
    Unregistered
    Posted 10 years ago #

    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.

  14. Mark (podz)
    Support Maven
    Posted 10 years ago #

    @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 :)

  15. Anonymous
    Unregistered
    Posted 10 years ago #

    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 ;)

  16. Stoofa
    Member
    Posted 10 years ago #

    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!!

  17. Anonymous
    Unregistered
    Posted 10 years ago #

    I too am having the same b2 import problems. Nothing i do works and to be honest it really surprises me as wordpress is meant to be the 'official' extension of b2...
    Seems like ill just have to start a new blog and forget about my archives... really really sucks.

  18. Mark (podz)
    Support Maven
    Posted 10 years ago #

    @Anon - can you get to #wordpress on IRC ?
    If so, someone there may be able to help you out much quicker - just say "Hi" and shoot with your question.

  19. Anonymous
    Unregistered
    Posted 10 years ago #

    What IRC server do i connect to?
    Cant seem to find any details of it on the site.

  20. Mark (podz)
    Support Maven
    Posted 10 years ago #

  21. Anonymous
    Unregistered
    Posted 9 years ago #

    ok, attempted to get help on irc, with no luck.
    Ive manaully transferred my posts and comments form b2 to wordpress using the queries in the perl script above (i couldnt get the script nitself to work)
    I had a problem when importing the posts into WP, due to the post id's being bigint(20) in b2 but only int(10) in WP. e.g. my b2 posts ids are like this 106479011873570112 (apparently caused from importing from blogger way back) ... anyway....
    So - people on irc told me it should be ok to change the structure of the WP tables so that post id's are bigint(20) to match b2.
    After doing that the import worked fine. Posts show up, and the number of comments are correct.
    However... when i click to view the comment for a post, i get the 'Sorry, no posts matched your criteria." error.
    I did some code searching and found the problem in the wp-blog-header.php file, around line number 201 is the following code.
    // If a post number is specified, load that post
    if (($p != '') && ($p != 'all')) {
    $p = intval($p);
    $where = ' AND ID = '.$p;
    }
    Which takes my bigint(20) post ID and converts it to a normal int - which of course gives an ID that doesnt match.
    So... I dont want to go hacking the php files, cause everytime an update comes out ill have to rehack it.
    My only options i can see are to reassign all the ids and somehow hope thay match up with the comments
    OR
    export the b2 data with post ids as int(10) and once again hope that they match up wioth the comments.
    This is turning in a huge nightmare... b2 -> wp easy? No way.
    Can anyone help?
    Thanks

  22. Sansnom
    Member
    Posted 9 years ago #

    There is an inconscient will to delete the memory of b2 in the WP mind. Heritage is something heavy.
    So you will never find a solution of import. It will always be considered as a minor question...
    I'm agree too with critics for support. The actual forum is a pity. Why not PHBB ? Perhaps because it was the choice of b2 support ? Another sign of heritage to erase.

  23. Anonymous
    Unregistered
    Posted 9 years ago #

    Regarding my long psot above - i have FINALLY figured out how to convert my b2 blog to wordpress and it is all working.
    Im surprised at the lack of support i received in the wordpress irc channel - where my questions went unanswered, and also the lack of support in these forms.
    I am going to write up the method i used to convert and i will post it here when done.

  24. Anonymous
    Unregistered
    Posted 9 years ago #

    @Anon - Are you ever going to come back and share how you successfully upgraded with the rest of us? It's been 20 days...This is exactly what podz was talking about. People figure it out and then don't come back to offer assistance to others who they know are having the same problems. That's why no progress ever seems to be made. Unfortunate.

  25. Mellissa
    Member
    Posted 9 years ago #

    I'm having the same problems too. Ugh, this is frustrating.

  26. carthik
    Member
    Posted 9 years ago #

    Can someone let me in so I can fix an upgrade for them, and see what's going on and fix it?
    An alternate to that could be to send me a dump of the b2 mysql database with all you entries, and the version and so on.
    This is not the first time I've made this offer, and I hope this time someone will help me help them :)
    The email address is mail @ carthik dot net

  27. Anonymous
    Unregistered
    Posted 9 years ago #

    Renaming the b2 tables worked for me. I ran the following SQL query in phpMyAdmin:
    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;
    Once that completed, I ran the import-b2.php script again without any errors. Checking the blog, all my posts are there... hope this helps.

  28. borgo
    Member
    Posted 9 years ago #

    I've just used the aboved mentionned for a friend and it works fine. However what I did after the DROP TABLE and RENAME TABLE, was to re-import the b2 dump in the db
    Thanks for the tip ;)

  29. permalance
    Member
    Posted 9 years ago #

    Holy crap... I'll second (or 11th or 12th as the case may be) the motion that the b2import documentation sucks ass... but WordPress seems cool, so I guess they spend more time on building than documenting...
    That last fix worked for me as well... so here's my steps for installing WordPress (from a PHP/MySQL idiot).
    1. Download the wp zip file.
    2. Edit the wp-config as they suggest - however when you're defining the db_name, db_user & db_password, make sure you use the settings from your B2 installation.
    3. Leave table prefix as "wp_".
    4. Save and upload all files.
    5. Run: /wp-admin/install.php
    6. Visit your phpMyAdmin webclient. Choose the correct database, and then click on "SQL" and do the following:
    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;
    click "go"
    7. Back on your site, run: wp-admin/import-b2.php
    After that, if you're like me, your b2 posts will show up.

  30. Anonymous
    Unregistered
    Posted 9 years ago #

    i followed the instructions from the previous post and I was able to get my b2 imported successfully into Word Press. There was only one difference that I had to accommodate. I did not have a "wp_settings" table to drop. I did have a b2settings table which I did rename without issue. So far so good....I'm going to try to import my old blogger archives now....

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.