New Version of Serendipity (s9y) to WordPress Importer Available

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

Previous in series Next in series

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 is the Director of Technology at b5media and is available for consulting.

Tagged: at 7:19 pm -

35 Responses to “New Version of Serendipity (s9y) to WordPress Importer Available”

1

ckay Says:

doesn’t work for me. it seems that the importer tries to use the s9y database for inserting the data into wordpress, but in my case they are two different databases on the same server.

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)

January 14th, 2007 at 6:09 pm
2

Paws Says:

Same goes for me. Both, the S9Y and the WP Databases are on the same server. Now when I try to import, the Plugin tries to write the data into the S9Y Database instead of the WP Database

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

January 31st, 2007 at 5:00 pm
3

Paws Says:

Found the solution….

as Database host enter “127.0.0.1″ instead of “localhost”

January 31st, 2007 at 6:54 pm
4

Forums » Technology, Blogging and New Media Says:

[...] are nice. Especially when lots of people want support. :-) This is not an announcement. Carry on, [...]

February 1st, 2007 at 3:02 am
5

Paws Says:

*grins*

Keep up the good work! You’re a life saver!
*hug* :)

February 1st, 2007 at 6:07 am
6

Serendipity Importer for WordPress Released » Technology, Blogging and New Media Says:

[...] : There ia a new version available. The current original download is no longer available (delinked [...]

February 3rd, 2007 at 1:22 pm
7

Ramblings from the Marginalized » About the move… Says:

[...] would like to use this post to thank Aaron Brazell for his excellent Serendipity to WordPress import plugin. Though it was not perfect it helped me save a lot of [...]

February 12th, 2007 at 9:26 pm
8

HMTKSteve Says:

Great job, I just used it to save me some time!

One thing, why does it not pull the extended text?

February 12th, 2007 at 9:27 pm
9

Umstieg auf Wordpress Says:

[...] alten Beiträge habe ich mit dem Skript von technosailer.com von Serendipity zu Wordpress importiert. Das ganze hat fast ohne Probleme (Umlaute wurden zum Teil [...]

February 18th, 2007 at 2:14 pm
10

Lesezeichen vom 18. Februar Says:

[...] Serendipity (s9y) to Wordpress Importer - Script zum Importieren von Serendipity-Inhalten in ein Wordpress-Weblog. Tags:&nbsp [...]

February 18th, 2007 at 7:31 pm
11

Kim Says:

I’m trying to download this and it tells me that the file is corrupted?

February 28th, 2007 at 5:16 am
12

SoGua Says:

I work just half way, i cant import my extended message to my wordpress.

ANy new solution?

March 15th, 2007 at 10:54 pm
13

SoGua Says:

ok i’ve modified line 317 to join the $extended content. As this:-

$post_body = $wpdb->escape($body) . $wpdb->escape($extended);

March 15th, 2007 at 11:11 pm
14

54 Says:

what do you mean SoGua? And kim and ether repare the file, or re download the file.

March 22nd, 2007 at 5:16 pm
15

ritman Says:

i have a blog with 4 authors. your import plugin works good, but all entrys are importet for the administrator..

what is the problem?

March 30th, 2007 at 7:11 am
16

ritman Says:

no one here to help me?

April 2nd, 2007 at 8:43 am
17

Voip Phreak - » Shift to WordPress Says:

[...] serendipity blog system, to wordpress instead. I used this sweet little conversion script, called Serendipity to Wordpress importer. I just had to put the script in the directory, give it my db credentials, and import all my [...]

April 12th, 2007 at 12:56 am
18

Henk Says:

Uhm, I keep getting errors:

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?

April 28th, 2007 at 10:48 am
19

Paws Says:

That’s what I get now when trying to import from my S9Y DB:

—
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… :|

June 15th, 2007 at 11:01 am
20

peanutsof80s Says:
This serendipity.php script works perfectly in my case, making my former Serendipity 0.9 (s9y) install a history with about 200 entries perfectly imported to Wordpress (WP) 2.2. However, it’s not perfect out of the box. It needs some preparation to make the migration works.

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:
```
# cd {wordpress_web_root_path}/wp-admin/import
# wget -c http://www.technosailor.com/downloads/serendipity-importer.zip
# unzip serendipity-importer.zip
```
- Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat $wpdb->escape($extended) to $post_body variable.

- Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.
```
GRANT all privileges on *.* to \'root\'@\'127.0.0.1\' identified by \'your_mysql_passwd\';
FLUSH PRIVILEGES;
```
- Verify your s9y database name and prefix. By default it’s “serendipity” and “serendipity_” respectively. Try listing ls -1 /var/lib/mysql/

- 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:
```
Serendipity Database User: root
Serendipity Database Password: your_mysql_password
Serendipity Database Name: serendipity
Serendipity Database Host: 127.0.0.1
Serendipity Table prefix (if any): serendipity_
```
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.
June 16th, 2007 at 12:47 pm
21

Ryan Says:

Paws -

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!

July 4th, 2007 at 6:01 pm
22

Jonathan Says:

I’ve been trying to use the Serendipity to wordpress importer but I keep getting the this same error:

Warning: Cannot modify header information - headers already sent by (output started at /home/microcap/public_html/wp-admin/admin-header.php:16) in /home/microcap/public_html/wp-includes/wp-db.php on line 373
WordPress

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.

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?

The serendipity account is hosted by Aplus.net, and the Wordpress is hosted by BlueHost.

Any ideas would be awesome.

August 1st, 2007 at 5:44 pm
23

peanutsof80s Says:

Sounds like pure database connectivity issue. As mentioned that s9y and WP are hosted separately which I assumed they’re on separate networks where MySQL default TCP port 3306 is normally blocked on the perimeter.

Remember, MySQL authentication requires this port (or any assigned non-standard MySQL port) to be opened to accept database connection. I hope this will help.

August 2nd, 2007 at 11:35 pm
24

CMB Says:

This worked for me but it only imported the the “body” field of the entries table, not the “extended” field (where all my content except the introductory paragraph is).

Also it ignored the category ID on half the posts. (half the posts would up in the uncategorized category).

Any Idea’s????

Chris

August 7th, 2007 at 11:05 pm
25

CMB Says:

Also, All the posts are attributed to the admin

August 7th, 2007 at 11:09 pm
26

CMB Says:

I had missed the code modification in item 13. When applied the whole post is imported.

I guess I’ll change the poster names by hand.

Thanks a million for the VERY useful script. Saved me a lot of work!

CMB

August 8th, 2007 at 10:39 am
27

nick Says:

Works like a charm, only make sure you edit the file like the guy of comment 13 said.

September 26th, 2007 at 3:50 am
28

The Best of 2007 Says:

[...] New Version of Serendipity (s9y) to WordPRess Importer [...]

December 24th, 2007 at 2:15 pm
29

Paulino Michelazzo Says:

Thanks so much for your script. Solve me a lot of problems.

Regards from Brazil

March 5th, 2008 at 5:38 pm
30

Kolin Tregaskes Says:

I’ve tried to import, it imports the categories OK but then I click on Import Users and after a second or 2 it stops at:

Steps may take a few minutes depending on the size of your database. Please be patient.

Importing Users…

Please help?? :-)

March 7th, 2008 at 4:03 pm
31

Zoe Says:

Worked really smoothly except that the entries didn’t go into their respective categories. But that’s okay. It’s still quicker than copying and pasting! :) Thanks!

March 19th, 2008 at 5:13 am
32

empika Says:

Hi

Im getting this error when i get to importing the comment:

Importing Comments…

WordPress database error: [Table 'commune_s9y.wp_comments' doesn't exist]
SELECT comment_post_ID FROM wp_comments WHERE comment_author = ‘mule’ AND comment_date = ‘2005-02-12 20:10:23′

( ! ) Warning: Invalid argument supplied for foreach() in /var/www/pwn.no-ip.org/wordpress/wp-admin/import/serendipity.php on line 51
Call Stack
# Time Function Location
1 2.0075 {main}( ) ../admin.php:0
2 19.0969 call_user_func ( ??? ) ../admin.php:103
3 19.0969 Serendipity_Import->dispatch( ) ../admin.php:0
4 19.0977 Serendipity_Import->import_comments( ) ../serendipity.php:605
5 19.1062 Serendipity_Import->comments2wp( ??? ) ../serendipity.php:492
6 19.1118 find_comment_parent( ???, ??? ) ../serendipity.php:424

WordPress database error: [Table 'commune_s9y.wp_comments' doesn't exist]
INSERT INTO wp_comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (”, ‘****’, ‘****@yahoo.co.uk’, ”, ‘62.252.0.11′, ‘2005-02-12 20:10:23′, ‘2005-02-12 20:10:23′, ‘*****’, ‘1′, ”, ”, ‘0′, ‘0′)

It seems odd that its trying to select comments from s9y_db.wp_comments which is the wordpress table but in the s9y db?!
Any ideas how i could hack the script to sort this out?

many thanks
Edd

March 21st, 2008 at 12:40 pm
33

asshur Says:

Thanks. But I have problems same Jonathan

March 28th, 2008 at 4:14 pm
34

Auctionwire Says:

I use serendipity v0.8x or something which is quite old.
I now want to migrate to use wp v2.5 for my site auctionwire.info

Does your importer work for that?

thanks

March 31st, 2008 at 12:45 am
35

Phil Malmstrom Says:

I just wanted to say thanks for the importer. It worked perfectly as described, and saved me a TON of work moving my old posts.

Very much appreciated!

April 24th, 2008 at 9:30 am