RealNitro’s Blog

Posted in Life | 13 Comments

13 Responses to “Convert a b2evolution blog to WordPress”

1. on 25 Feb 2007 at 03:411Henry

   Ok, so if I were going to fix that, what do I need to change?

2. on 28 Feb 2007 at 13:572RealNitro

   Well, if you check the ‘(evo_)posts’ table in your b2evo database, there is a field called ‘post_urltitle’. This needs to be mapped to ‘post_name’ field in the ‘(wp_)posts’ table in your WordPress database.

   For the categories, the ‘(evo_)categories’ table has a field called ‘cat_name’ that needs to be mapped to the ‘category_nicename’ field in ‘(wp_)categories’.

   I updated the script. I didn’t test it, so I’m not sure if it will work.

   If you want to change things manually, you can give the categories ‘nicenames’ using the WordPress admin panel. Go to Managa->Catergories, click Edit, and fill in the ‘Category slug’ field. For the posts, go to Manage->Posts, click Edit, expand the ‘Post slug’ box on the right, and fill in the slug.

3. on 04 Apr 2007 at 22:323lappy512

   The prefix thing doesn’t work, one of the lines has:
   select option_value from wp_options

   Fix that and replace it with:
   select option_value from ” . $wp_pref . “options

4. on 16 Apr 2007 at 17:184RealNitro

   lappy512: thx for letting me know. I updated the script. The newest version is b2evo2wp_update2.php.txt.

5. on 27 Aug 2007 at 14:265Diane

   Just tried to run your updated script and got this error when actually tried the import:

   SQL : SELECT DISTINCT evo_users.* FROM evo_users, evo_posts WHERE evo_users.`ID`=`post_author` AND `user_login`’admin’

   Since I don’t know a thing about this stuff, it could be user error rather than a problem with the script. My installed b2evolution software is 1.9.3 while I just installed the latest WP.

6. on 27 Aug 2007 at 19:526RealNitro

   Diane, I can’t figure out what is going wrong. It seems to me the error you posted isn’t complete. Is there any more error output?

7. on 27 Aug 2007 at 20:447Diane

   This is all the page says:

   All right sparky, this is where the actual import takes place! Do you feel lucky today? :p
   Importing User records …
   Invalid query:
   SQL : SELECT DISTINCT evo_users.* FROM evo_users, evo_posts WHERE evo_users.`ID`=`post_author` AND `user_login`’admin’

   That’s it. The rest is a blank page.

8. on 27 Aug 2007 at 22:058Diane

   Just noticed that the error I’m getting above is the same error that caused you to rewrite the original script from Appleyard’s blog. Possibly this means that the newest b2evo has once again made the script obsolete. I certainly hope someone finds out how to bring it up to date again. I’d really like to switch my blog over.

9. on 28 Aug 2007 at 19:579RealNitro

   I think you’re still using the old script from Appleyard’s blog. There is no other way that you would get that error… I suggest you (re)download this script, copy it to your server, rename it to ‘b2evo2wp.php’ (as mentioned here) and it should work fine.

10. on 31 Mar 2008 at 00:4510Benoit Marcoux

    I am trying to use the script - understand that I am a newbie to PHP. I get the following error:

    b2Evolution file path: http://benoit.marcoux.ca/blog/media/
    WordPress file path: /

    Importing User records …
    0 User record(s) imported!
    Importing Category records …
    Invalid query: Table ‘bmarcou_wordpress.wp_categories’ doesn’t exist
    SQL : INSERT INTO `wp_categories` (`cat_name`,`category_nicename`,`category_description`) VALUES (’Général’,'Général’,”);

    Can you help me?
    Thx

11. on 31 Mar 2008 at 14:3011RealNitro

    Benoit: Did you install wordpress on your server before using my script?

12. on 13 Jul 2008 at 14:5612Taz

    same error for me

13. on 10 Oct 2008 at 16:0313John

    Getting a 404 error. Any idea?

    Wordpress already installed before using script.

Leave a Reply

Name (required)

Mail (hidden) (required)

Website