January 2, 2007

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.

Filed Under: Aaron Brazell Tagged With:
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:
    August 2, 2007 at 11:35 pm

    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:
    August 2, 2007 at 11:35 pm

    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. CMB says:
    August 7, 2007 at 11:05 pm

    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. CMB says:
    August 7, 2007 at 11:09 pm

    Also, All the posts are attributed to the admin

  5. CMB says:
    August 7, 2007 at 11:05 pm

    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. CMB says:
    August 7, 2007 at 11:05 pm

    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. CMB says:
    August 7, 2007 at 11:05 pm

    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. CMB says:
    August 7, 2007 at 11:05 pm

    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. CMB says:
    August 7, 2007 at 11:05 pm

    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. CMB says:
    August 7, 2007 at 11:09 pm

    Also, All the posts are attributed to the admin

  11. CMB says:
    August 7, 2007 at 11:09 pm

    Also, All the posts are attributed to the admin

  12. CMB says:
    August 7, 2007 at 11:09 pm

    Also, All the posts are attributed to the admin

  13. CMB says:
    August 7, 2007 at 11:09 pm

    Also, All the posts are attributed to the admin

  14. CMB says:
    August 7, 2007 at 11:09 pm

    Also, All the posts are attributed to the admin

  15. CMB says:
    August 8, 2007 at 10:39 am

    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. CMB says:
    August 8, 2007 at 10:39 am

    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. CMB says:
    August 8, 2007 at 10:39 am

    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. CMB says:
    August 8, 2007 at 10:39 am

    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. CMB says:
    August 8, 2007 at 10:39 am

    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. CMB says:
    August 8, 2007 at 10:39 am

    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. nick says:
    September 26, 2007 at 3:50 am

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

  22. nick says:
    September 26, 2007 at 3:50 am

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

  23. nick says:
    September 26, 2007 at 3:50 am

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

  24. nick says:
    September 26, 2007 at 3:50 am

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

  25. nick says:
    September 26, 2007 at 3:50 am

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

  26. nick says:
    September 26, 2007 at 3:50 am

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

  27. Paulino Michelazzo says:
    March 5, 2008 at 5:38 pm

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

    Regards from Brazil

  28. Paulino Michelazzo says:
    March 5, 2008 at 5:38 pm

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

  29. Paulino Michelazzo says:
    March 5, 2008 at 5:38 pm

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

  30. Paulino Michelazzo says:
    March 5, 2008 at 5:38 pm

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

  31. Paulino Michelazzo says:
    March 5, 2008 at 5:38 pm

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

  32. Paulino Michelazzo says:
    March 5, 2008 at 5:38 pm

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

  33. Kolin Tregaskes says:
    March 7, 2008 at 4:03 pm

    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. Kolin Tregaskes says:
    March 7, 2008 at 4:03 pm

    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. Kolin Tregaskes says:
    March 7, 2008 at 4:03 pm

    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. Kolin Tregaskes says:
    March 7, 2008 at 4:03 pm

    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. Kolin Tregaskes says:
    March 7, 2008 at 4:03 pm

    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. Kolin Tregaskes says:
    March 7, 2008 at 4:03 pm

    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. Zoe says:
    March 19, 2008 at 5:13 am

    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. Zoe says:
    March 19, 2008 at 6:13 am

    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. Zoe says:
    March 19, 2008 at 6:13 am

    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. Zoe says:
    March 19, 2008 at 6:13 am

    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. Zoe says:
    March 19, 2008 at 6:13 am

    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. Zoe says:
    March 19, 2008 at 6:13 am

    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. empika says:
    March 21, 2008 at 12:40 pm

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

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

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

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

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

    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

« Older Comments
Newer Comments »