New Version of Serendipity (s9y) to WordPress Importer Available

Posted on January 2, 2007 by Aaron

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

1	serendipity.php

to your WordPress blog in the

1	wp-admin/import

directory.

Hire me! I am actively looking for full-time work. If you're interested in discussing opportunities, please email me at aaron@technosailor.com

178 thoughts on “New Version of Serendipity (s9y) to WordPress Importer Available”

Zoe on March 19, 2008 at 6:13 am said:

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!
empika on March 21, 2008 at 12:40 pm said:

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
empika on March 21, 2008 at 1:40 pm said:

HiIm 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 51Call Stack# Time Function Location1 2.0075 {main}( ) ../admin.php:02 19.0969 call_user_func ( ??? ) ../admin.php:1033 19.0969 Serendipity_Import->dispatch( ) ../admin.php:04 19.0977 Serendipity_Import->import_comments( ) ../serendipity.php:6055 19.1062 Serendipity_Import->comments2wp( ??? ) ../serendipity.php:4926 19.1118 find_comment_parent( ???, ??? ) ../serendipity.php:424WordPress 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 thanksEdd
empika on March 21, 2008 at 1:40 pm said:

HiIm 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 51Call Stack# Time Function Location1 2.0075 {main}( ) ../admin.php:02 19.0969 call_user_func ( ??? ) ../admin.php:1033 19.0969 Serendipity_Import->dispatch( ) ../admin.php:04 19.0977 Serendipity_Import->import_comments( ) ../serendipity.php:6055 19.1062 Serendipity_Import->comments2wp( ??? ) ../serendipity.php:4926 19.1118 find_comment_parent( ???, ??? ) ../serendipity.php:424WordPress 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 thanksEdd
empika on March 21, 2008 at 1:40 pm said:

HiIm 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 51Call Stack# Time Function Location1 2.0075 {main}( ) ../admin.php:02 19.0969 call_user_func ( ??? ) ../admin.php:1033 19.0969 Serendipity_Import->dispatch( ) ../admin.php:04 19.0977 Serendipity_Import->import_comments( ) ../serendipity.php:6055 19.1062 Serendipity_Import->comments2wp( ??? ) ../serendipity.php:4926 19.1118 find_comment_parent( ???, ??? ) ../serendipity.php:424WordPress 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 thanksEdd
empika on March 21, 2008 at 1:40 pm said:

HiIm 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 51Call Stack# Time Function Location1 2.0075 {main}( ) ../admin.php:02 19.0969 call_user_func ( ??? ) ../admin.php:1033 19.0969 Serendipity_Import->dispatch( ) ../admin.php:04 19.0977 Serendipity_Import->import_comments( ) ../serendipity.php:6055 19.1062 Serendipity_Import->comments2wp( ??? ) ../serendipity.php:4926 19.1118 find_comment_parent( ???, ??? ) ../serendipity.php:424WordPress 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 thanksEdd
empika on March 21, 2008 at 1:40 pm said:

HiIm 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 51Call Stack# Time Function Location1 2.0075 {main}( ) ../admin.php:02 19.0969 call_user_func ( ??? ) ../admin.php:1033 19.0969 Serendipity_Import->dispatch( ) ../admin.php:04 19.0977 Serendipity_Import->import_comments( ) ../serendipity.php:6055 19.1062 Serendipity_Import->comments2wp( ??? ) ../serendipity.php:4926 19.1118 find_comment_parent( ???, ??? ) ../serendipity.php:424WordPress 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 thanksEdd
asshur on March 28, 2008 at 4:14 pm said:

Thanks. But I have problems same Jonathan
asshur on March 28, 2008 at 4:14 pm said:

Thanks. But I have problems same Jonathan
asshur on March 28, 2008 at 4:14 pm said:

Thanks. But I have problems same Jonathan
asshur on March 28, 2008 at 4:14 pm said:

Thanks. But I have problems same Jonathan
asshur on March 28, 2008 at 4:14 pm said:

Thanks. But I have problems same Jonathan
asshur on March 28, 2008 at 4:14 pm said:

Thanks. But I have problems same Jonathan
Auctionwire on March 31, 2008 at 12:45 am said:

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
Auctionwire on March 31, 2008 at 12:45 am said:

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.infoDoes your importer work for that?thanks
Auctionwire on March 31, 2008 at 12:45 am said:

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.infoDoes your importer work for that?thanks
Auctionwire on March 31, 2008 at 12:45 am said:

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.infoDoes your importer work for that?thanks
Auctionwire on March 31, 2008 at 12:45 am said:

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.infoDoes your importer work for that?thanks
Auctionwire on March 31, 2008 at 12:45 am said:

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.infoDoes your importer work for that?thanks
Phil Malmstrom on April 24, 2008 at 9:30 am said:

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!
gooddirectory on July 8, 2008 at 5:48 am said:

I getting WordPress database error.
gooddirectory on July 8, 2008 at 5:48 am said:

I getting WordPress database error.
gooddirectory on July 8, 2008 at 5:48 am said:

I getting WordPress database error.
gooddirectory on July 8, 2008 at 5:48 am said:

I getting WordPress database error.
gooddirectory on July 8, 2008 at 5:48 am said:

I getting WordPress database error.
gooddirectory on July 8, 2008 at 5:48 am said:

I getting WordPress database error.
Michael Tyson on September 4, 2008 at 1:52 am said:

Hi! I had a few problems with this. My categories weren't being imported properly, and it repeatedly timed out on me.It was incorrecly using the id of the created WordPress post to look up the old S9Y post, which I fixed, as well as adjusting the timeout delay, and breaking up the work of importing the posts into smaller steps.Seemed to solve the problem.See the revised version (which I called 1.2) at http://michael.tyson.id.au/626-serendipity-s9y-…
Chris Rollyson on February 11, 2009 at 3:45 pm said:

I have saas installations of s9y and wp 2.7, and I am not a developer. s9y blog hosted at netsol as is my wp 2.7 blog; however don’t know whether they’re on the same server. It looks like this plugin only for running on the same box. Am I wasting my time playing with this, or can I use? Thanks-

Technosailor.com

Business and Technology with Common Sense

New Version of Serendipity (s9y) to WordPress Importer Available

178 thoughts on “New Version of Serendipity (s9y) to WordPress Importer Available”