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

1
serendipity.php

to your WordPress blog in the

1
wp-admin/import

directory.

About Aaron

Aaron Brazell is a Baltimore, MD-based WordPress developer, a co-founder at WP Engine, WordPress core contributor and author. He wrote the book WordPress Bible and has been publishing on the web since 2000. You can follow him on Twitter, on his personal blog and view his photography at The Aperture Filter.

Comments

  1. 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.

  2. 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.

  3. 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

  4. Also, All the posts are attributed to the admin

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. Also, All the posts are attributed to the admin

  11. Also, All the posts are attributed to the admin

  12. Also, All the posts are attributed to the admin

  13. Also, All the posts are attributed to the admin

  14. Also, All the posts are attributed to the admin

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

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

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

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

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

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

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

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

    Regards from Brazil

  28. Thanks so much for your script. Solve me a lot of problems.Regards from Brazil

  29. Thanks so much for your script. Solve me a lot of problems.Regards from Brazil

  30. Thanks so much for your script. Solve me a lot of problems.Regards from Brazil

  31. Thanks so much for your script. Solve me a lot of problems.Regards from Brazil

  32. Thanks so much for your script. Solve me a lot of problems.Regards from Brazil

  33. 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?? :-)

  34. 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?? :-)

  35. 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?? :-)

  36. 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?? :-)

  37. 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?? :-)

  38. 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?? :-)

  39. 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!

  40. 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!

  41. 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!

  42. 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!

  43. 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!

  44. 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!

  45. 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

  46. 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

  47. 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

  48. 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

  49. 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

  50. 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