There is a new version of the Serendipity importer available for WordPress. It can be downloaded at here. Note: The old location no longer works.
This version is a bugfix version addressing issues of unassociated comments and unassociated categories. This should be considered a beta release until I get more user feedback.
To use, upload serendipity.php to your WordPress blog in the wp-admin/import directory.
Table of contents for WordPress Plugins
- WordPress-to-WordPress Import
- WordPress-to-WordPress Import v2.0 Released
- New Version of Serendipity (s9y) to WordPress Importer Available
- Timecapsule Plugin 1.0.3
- WordPress Plugin: Embargo Press Release
Stumble it!
About the Author: Aaron Brazell is the lead editor of Technosailor.com and a social media expert. His passion is to see companies and individuals use the internet and web technologies wisely and effectively to promote their brands and companies. He served as Director of Technology at b5media from 2005-2008 and is currently an independent consultant.
Add New Comment
Viewing 15 Comments
Thanks. Your comment is awaiting approval by a moderator.
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
Also it would be nice if i could choose what to import. Right now i have to do one thing after the other even if i don't want to :) (i would like to skip the users and categories, as they already exist)
Do you already have an account? Log in and claim this comment.
WordPress database error: [Table 'usr_webXX_12.wp_categories' doesn't exist]
SELECT cat_ID FROM wp_categories WHERE category_nicename = 'php'
usr_webXX_12 = The S9Y DB
usr_webXX_14 = WP Database
Do you already have an account? Log in and claim this comment.
as Database host enter "127.0.0.1" instead of "localhost"
Do you already have an account? Log in and claim this comment.
Keep up the good work! You're a life saver!
*hug* :)
Do you already have an account? Log in and claim this comment.
One thing, why does it not pull the extended text?
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
ANy new solution?
Do you already have an account? Log in and claim this comment.
$post_body = $wpdb->escape($body) . $wpdb->escape($extended);
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
what is the problem?
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
WordPress database error: [Table 'serendipity._category' doesn't exist]
This is correct, because it should be serendipity_category NOT serendipity._category with a . in it!!
How to fix this?
Do you already have an account? Log in and claim this comment.
---
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at . This could mean your host's database server is down.
---
doesn't work with 127.0.0.1 as db-host either... :|
Do you already have an account? Log in and claim this comment.
The following should be made prior to migration based on my preparation.
- Backup both s9y and WP package and MySQL databases. Whatever method will be fine.
- Download the package and install into your WP installation folder:
[code]PGNvZGU+DQojIGNkIHt3b3JkcHJlc3Nfd2ViX3Jvb3RfcGF0aH0vd3AtYWRtaW4vaW1wb3J0DQojIHdnZXQgLWMgaHR0cDovL3d3dy50ZWNobm9zYWlsb3IuY29tL2Rvd25sb2Fkcy9zZXJlbmRpcGl0eS1pbXBvcnRlci56aXANCiMgdW56aXAgc2VyZW5kaXBpdHktaW1wb3J0ZXIuemlwDQo8L2NvZGU+[/code]
- Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat [code]PGNvZGU+JHdwZGItPmVzY2FwZSgkZXh0ZW5kZWQpPC9jb2RlPg==[/code] to [code]PGNvZGU+JHBvc3RfYm9keTwvY29kZT4=[/code] variable.
- Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.
[code]PGNvZGU+DQpHUkFOVCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gXCdyb290XCdAXCcxMjcuMC4wLjFcJyBpZGVudGlmaWVkIGJ5IFwneW91cl9teXNxbF9wYXNzd2RcJzsNCkZMVVNIIFBSSVZJTEVHRVM7DQo8L2NvZGU+[/code]
- Verify your s9y database name and prefix. By default it's "serendipity" and "serendipity_" respectively. Try listing [code]PGNvZGU+bHMgLTEgL3Zhci9saWIvbXlzcWwvPC9jb2RlPg==[/code]
- Remove all single-quoted Category names like most of the French words. Otherwise, the import will continue but MySQL will skip importing those single-quoted Categories. You can manually remove it or via SQL command.
- At this point, you're all set to go ahead with s9y migration through WP admin ... Manage ... Import ... Serendipity. A default s9y install should be like these:
[code]PGNvZGU+DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBVc2VyOiByb290DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBQYXNzd29yZDogeW91cl9teXNxbF9wYXNzd29yZA0KU2VyZW5kaXBpdHkgRGF0YWJhc2UgTmFtZTogc2VyZW5kaXBpdHkNClNlcmVuZGlwaXR5IERhdGFiYXNlIEhvc3Q6IDEyNy4wLjAuMQ0KU2VyZW5kaXBpdHkgVGFibGUgcHJlZml4IChpZiBhbnkpOiBzZXJlbmRpcGl0eV8NCjwvY29kZT4=[/code]
The rest is just pony and click. The import includes Categories, Users, Posts and Comments.
I hope this will help your migration to WP error-free.
Do you already have an account? Log in and claim this comment.
I get the same error as you. Any luck figuring it out? My s9y installation is hosted at dreamhost, so I can't use 'localhost' or '127.0.0.1' to connect, I must use my actual domain name (ryanroth.net). I'm assuming this may be part of the problem.
Any ideas would be splendid!
Add New Comment