Migrating from b2 to WP

  • I found a tool that was supposed to work but it doesn’t seem to be. I’m using b2 evolution on 3 blogs on three different domains and I want to convert them all. The ease of WordPress has won me over ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Daethian

    (@daethian)

    My blog id is #2 and here are the errors I get when I run the file :

    All right sparky, this is where the actual import takes place! Do you feel lucky today? :p
    Importing User records …
    10 User record(s) imported!
    Importing Category records …

    Importing Links from Blog #4

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(cat_ID, cat_name) VALUES (19, ‘Research Sites’)’ at line 1]
    INSERT INTO (cat_ID, cat_name) VALUES (19, ‘Research Sites’)

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(cat_ID, cat_name) VALUES (20, ‘Care Sites’)’ at line 1]
    INSERT INTO (cat_ID, cat_name) VALUES (20, ‘Care Sites’)

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(cat_ID, cat_name) VALUES (21, ‘Photo Sites’)’ at line 1]
    INSERT INTO (cat_ID, cat_name) VALUES (21, ‘Photo Sites’)

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(cat_ID, cat_name) VALUES (22, ‘Misc Land Hermit Crab Sites’)’ at line 1]
    INSERT INTO (cat_ID, cat_name) VALUES (22, ‘Misc Land Hermit Crab Sites’)

    Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/purpleme/public_html/hermitcrabassociation/wp-admin/import-b2evolution-wp2.php on line 96

    Done. Imported 0 links in 4 link categories.2 category record(s) imported!
    Importing Entry records …
    Invalid query: Unknown column ‘post_category’ in ‘on clause’
    SQL : SELECT * FROM evo_posts INNER JOIN evo_categories ON cat_ID = post_category WHERE cat_blog_ID IN (2)

    I am in the same predicament. I wanted to change from B2Evo 1.8.1-RC to WordPress (Version 2.3.3), but having found the above post and that the guy above didnt get an any response in over 9 months, it does not seem like much is happening over here and it may be a bad idea.
    Anyway, if anyone ever reads this, I found a script on this site “import-b2evolution-wp2.php” and installed them both in the same SQL database but get this error message:

    “All right sparky, this is where the actual import takes place! Do you feel lucky today? :p

    Importing User records …
    2 User record(s) imported!
    Importing Category records …
    4 category record(s) imported!
    Importing Entry records …
    Invalid query: Unknown column ‘post_category’ in ‘on clause’
    SQL : SELECT * FROM evo_posts INNER JOIN evo_categories ON cat_ID = post_category”

    So guys there does not appear to be any working import of b2evo to WordPress.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Migrating from b2 to WP’ is closed to new replies.