Technosailor.com Readers! Donate today to assist the Lambi Fund Haiti Peasant Relief in their efforts.

2 January 2007 178 Comments

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.

Pick up your copy of the WordPress Bible, a wildly popular resource for beginners and experts alike.

Written by Aaron Brazell on January 2, 2007

Popularity: 5% [?]

Tags:

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

  1. peanutsof80s 2 August 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 2 August 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 7 August 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 7 August 2007 at 11:09 pm #

    Also, All the posts are attributed to the admin

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

    Also, All the posts are attributed to the admin

  11. CMB 7 August 2007 at 11:09 pm #

    Also, All the posts are attributed to the admin

  12. CMB 7 August 2007 at 11:09 pm #

    Also, All the posts are attributed to the admin

  13. CMB 7 August 2007 at 11:09 pm #

    Also, All the posts are attributed to the admin

  14. CMB 7 August 2007 at 11:09 pm #

    Also, All the posts are attributed to the admin

  15. CMB 8 August 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 8 August 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 8 August 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 8 August 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 8 August 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 8 August 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 26 September 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 26 September 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 26 September 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 26 September 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 26 September 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 26 September 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 5 March 2008 at 5:38 pm #

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

    Regards from Brazil

  28. Paulino Michelazzo 5 March 2008 at 5:38 pm #

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

    Regards from Brazil

  29. Paulino Michelazzo 5 March 2008 at 5:38 pm #

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

    Regards from Brazil

  30. Paulino Michelazzo 5 March 2008 at 5:38 pm #

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

    Regards from Brazil

  31. Paulino Michelazzo 5 March 2008 at 5:38 pm #

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

    Regards from Brazil

  32. Paulino Michelazzo 5 March 2008 at 5:38 pm #

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

    Regards from Brazil

  33. Kolin Tregaskes 7 March 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 7 March 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 7 March 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 7 March 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 7 March 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 7 March 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 19 March 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 19 March 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 19 March 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 19 March 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 19 March 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 19 March 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 21 March 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 21 March 2008 at 1: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

  47. empika 21 March 2008 at 1: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

  48. empika 21 March 2008 at 1: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

  49. empika 21 March 2008 at 1: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

  50. empika 21 March 2008 at 1: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

« Older Comments
Newer Comments »

Trackbacks/Pingbacks.