• 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 wea€?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 9 replies - 31 through 39 (of 39 total)
  • You have to access wp-admin/install.php for those tables to be created :
    5. Run: /wp-admin/install.php

    yeah, i did that but the post table wasn’t created so i dropped all tables and installed again. This time it is installed.

    yeah, i did that but the post table wasn’t created so i dropped all tables and installed again. This time it is installed.

    Now i did the rename-drop stuff again and get the same error again but for another table that was definitaly there!

    Did you [strong] run: wp-admin/import-b2.php[/strong] after dropping and re-naming the tables? If not, ignore the errors and run: wp-admin/import-b2.php. If that doesn’t work you can manually drop the tables and rename them. You will get errors in phpmyadmin until you run: wp-admin/import-b2.php. It should work then.

    ok. how would i go about importing (not upgrading) from b2?
    i have b2 entries from another web page (on a different server) and i want them imported to everymoment.org. i did manage to export the b2 tables from my old database, and imported them to my db at everymoment.org (if you knew how much of a database dummy i am.. you would realize the amazing feat this much has been), but now the problems are:
    1) the database tables have different names (b2___ instead of wp____)
    2) i can’t rename the tables because i already have sections that are names wp_whatever, and they are not empty.. and i do NOT want to dump them (nor run the risk of doing so)
    can anyone help?

    Hannes

    (@hannes)

    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

    Hannes

    (@hannes)

    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 9 replies - 31 through 39 (of 39 total)
  • The topic ‘Upgrading from b2 to WP problems’ is closed to new replies.