Import Posts from B2 Evolution
3 years, 7 months ago When moving from an older blog system to a new one, it is usually the case that you want to import all the posts and categories from the old blog into the new one. The purpose of this tutorial is to show how to import posts etc from a b2evolution system, to your new Wordpress installation.
I have modified a script originally written by Farook, and I take no credit for the work on this. I have simply altered it to work with the release of B2Evo I was working with. If it doesn’t work for you, please contact me with any error message you recieve and I’ll do my best to help.
Ensure your current B2Evolution installation is working correctly, and then upload the script to your wordpress directory. Run the script, and follow the instructions which Farook placed in there, and go ahead to import the data.
Please Note: Do not create the same categories you did in your B2Evo install before running the script, because the script will try to create them again, and fail with an error message
Wordpress, B2evolution, Import
February 24th, 2005 at 12:14 pm
Yeh I tried it … and I got an error about an unknown field ..
No posts seem to have been imported nor do any users (but i am the only user really)
any help would be appreciated.
March 2nd, 2005 at 3:25 pm
I just run the script. Imported from b2evolution ‘Paris’ version into WordPress 1.5. It worked.
I have multiblogs in b2evo, but it seems like the script will just import all posts in the database regardless of which blog you have choosed.
That’s okay for me. I’m new to WordPress and need sometimes to explore WordPress’s functions to see if it suits me.
Thank you for providing the script.
Cheers
March 4th, 2005 at 2:35 am
good to know cara … i was doing from copenhagen .. i’ll upgrade to paris .. and see what happens
March 4th, 2005 at 3:34 am
nope i still get the same error .. i don’t get that i upgraded to Paris and it still doesn’t work
March 4th, 2005 at 6:13 am
Giles, after i run the php script, this was what i get:-
All right sparky, this is where the actual import takes place! Do you feel lucky today? :p
Importing User records …
0 User record(s) imported!
Importing Category records …
18 Category record(s) imported!
Importing Entry records …
INSERT INTO `wp_posts` (`post_author`,`post_date`,`post_content`,`post_title`,`post_category`)
VALUES [whatever my posts] then done.
I’m the only user for my b2evo blogs also, but i have created another user name but both in Administrator status.
As from the error, it shows that the script is trying to import user data. Are you sure you have no other user deatils in your database? (My case is ‘0 User record(s) imported!’ since i have no other user in other user groups except Administrator).
Either that or the unknown column in your database’s tables causes the error.
Sorry i can’t help.
March 4th, 2005 at 6:57 am
Anyone who can’t get this to work, try this new script here:
http://www.khubla.com/b2evo2wp.php.txt
You might have more luck
March 5th, 2005 at 1:41 am
wicked that new one worked a whole bunch better !!
March 21st, 2005 at 11:26 pm
hi. when i convert it works fine, but russian characters bocome:
????? ????? ????? ??? ??? ? ? ?? ????
what can i do to fix it?
thnx
March 22nd, 2005 at 6:48 am
Sorry - I really have no idea!
May 5th, 2005 at 10:00 am
[…] 217;un vers l’autre sans tout casser. Merci donc ‡ Farook et David Appleyard pour ce script qui marche du feu de Dieu. Je ne reviendrai pas sur l’installation de Wordpress qui ne m̵ […]
June 4th, 2005 at 3:47 am
Thank you for this script, it looks really promising however slap me silly for this “first things first” question, I do have to have wordpress installed and running first *before* I even attempt this, ya? I mean, it looks like it skims the info off the DB instead of a text file a la blogger/mt import.
June 9th, 2005 at 5:58 pm
Yes, you need to have WP installed first. I am currently doing rewrites on the script, including proper checking for a WP install. I hope to have it finished and posted by the end of the day.
June 10th, 2005 at 5:11 am
Okay, I’ve finished hacking the updated khubla.com version of the script and have made the following changes:
- Now checks for WordPress install and loads DB info automatically: no more step 2!
- Inserts post_name data so that permalinks on imported posts will work.
- Cleaned up coding style and switched to WP functions wherever possible (i.e. for string sanitizing and db operations).
- Trimmed out about 100 lines of code.
http://themikecam.com/downloads/import-b2evolution.php.txt (rename to .php, of course)
Simply upload to your wp-admin folder and run.
I’ve tested it on my own b2evo blog, but I’d welcome further testing and would be willing to fix any bugs that arise.
Here’s the unified diff if anyone’s interested: http://themikecam.com/downloads/import-b2evolution.diff.txt
August 30th, 2005 at 6:26 pm
Michael, your script ran well except that the comments portion did not get imported in although it said that it had imported it. Any ideas how to go about it? I looked at the wp_comments table and its empty. How should I import it?
August 31st, 2005 at 8:58 am
buy phentermine online
September 6th, 2005 at 4:07 pm
Invalid query: Unknown column ‘dateYMDhour’ in ‘field list’
I got this error - so i looked at the wp_users table and did not see a this field. Any ideas?
Thanks!
October 11th, 2005 at 11:02 pm
Someone else has made some changes/updates to the script, but I think it should be stable and working at the moment, and I should hopefully always have the latest version on my site so please try that if you previously experienced any problems. Also, I don’t really check this post at all, so please e-mail me or contact me through my site if you have a question/comment.
Michael
January 27th, 2006 at 10:04 pm
I really enjoyed reading your blog.
February 6th, 2006 at 10:29 am
Hi, I think you are totally right. Great! -
Susan.
February 6th, 2006 at 7:53 pm
Hello and congratulations! I’m impressed by this blog. I was searching the web and found your entry “Import Posts from B2 Evolution “. I am looking to publish a comprehensive site reviewing many different articles and blogs. Feel free to visit my Adobe Acrabat sit and add anything your want.
February 10th, 2006 at 3:40 pm
Hi, Do you think I could get such a blog? Susan.
March 8th, 2006 at 8:10 pm
Does your script require users to install Wordpress in the same database as B2Evolution — like this other import script:
http://themikecam.com/downloads/import-b2evolution.php.txt
March 30th, 2006 at 9:07 pm
dating married women maryland delawaredating married women maryland delaware
May 7th, 2006 at 4:22 pm
Hey David,
Your script works fine up until step 2. At that point I receive the following error:
———————————-
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’
———————————-
Do you - maybe - know what this error means and how we can resolve it? that would be GREAT!
Hoping to hear from you,
Cheers,
Melle.
August 19th, 2006 at 8:22 am
Hi
I try use the script anda ui receive:
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’
Do you - maybe - know what this error means and how we can resolve it? that would be GREAT!
Hoping to hear from you,
thanks
Sergio Lima
January 22nd, 2007 at 9:05 pm
Fetish Web CamFetish chat greenish fetish chat fetish web cam muscle-shaping fetish web cam free fetish chat isolationistic free fetish chat.
January 25th, 2007 at 9:52 am
ute indian tribeanime demons stocking 01 dads rape girls
February 21st, 2007 at 11:39 pm
To all people getting the
——
Invalid query:
SQL : SELECT DISTINCT evo_users.* FROM evo_users, evo_posts WHERE evo_users.`ID`=`post_author` AND `user_login`’admin’
——
errors, I adapted the script from this page to convert from b2evolution 1.8.6 to WordPress 2.1. Check out
http://blog.realnitro.be/2007/02/21/convert-a-b2evolution-blog-to-wordpress/
May 25th, 2007 at 2:40 pm
Rose Pop trio Atomic Kitten will reform to play a concert in support of jailed Liverpool football fan Michael Shields.
May 25th, 2007 at 5:19 pm
Segura Social networking site MySpace is to block users from uploading copyrighted music to its pages.
May 25th, 2007 at 5:19 pm
Segura Social networking site MySpace is to block users from uploading copyrighted music to its pages.