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.

Published by

Aaron Brazell

Aaron Brazell is a Baltimore, MD-based WordPress developer, A Sr. Web Engineer at 10up, 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.

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

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

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

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

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

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

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

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

  8. 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 DatabaseWordPress 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 DBusr_webXX_14 = WP Database

  9. 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 DatabaseWordPress 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 DBusr_webXX_14 = WP Database

  10. 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 DatabaseWordPress 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 DBusr_webXX_14 = WP Database

  11. 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 DatabaseWordPress 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 DBusr_webXX_14 = WP Database

  12. 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 DatabaseWordPress 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 DBusr_webXX_14 = WP Database

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

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

  14. ok i’ve modified line 317 to join the $extended content. As this:-$post_body = $wpdb->escape($body) . $wpdb->escape($extended);

  15. ok i’ve modified line 317 to join the $extended content. As this:-$post_body = $wpdb->escape($body) . $wpdb->escape($extended);

  16. ok i’ve modified line 317 to join the $extended content. As this:-$post_body = $wpdb->escape($body) . $wpdb->escape($extended);

  17. ok i’ve modified line 317 to join the $extended content. As this:-$post_body = $wpdb->escape($body) . $wpdb->escape($extended);

  18. ok i’ve modified line 317 to join the $extended content. As this:-$post_body = $wpdb->escape($body) . $wpdb->escape($extended);

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

    what is the problem?

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

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

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

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

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

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

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

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

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

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

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

  31. 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… :|

  32. That’s what I get now when trying to import from my S9Y DB:—Error establishing a database connectionThis 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… :|

  33. That’s what I get now when trying to import from my S9Y DB:—Error establishing a database connectionThis 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… :|

  34. That’s what I get now when trying to import from my S9Y DB:—Error establishing a database connectionThis 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… :|

  35. That’s what I get now when trying to import from my S9Y DB:—Error establishing a database connectionThis 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… :|

  36. That’s what I get now when trying to import from my S9Y DB:—Error establishing a database connectionThis 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… :|

  37. This [code]PGNvZGU+c2VyZW5kaXBpdHkucGhwPC9jb2RlPg==[/code] 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:

    [code]PGNvZGU+DQojIGNkIHt3b3JkcHJlc3Nfd2ViX3Jvb3RfcGF0aH0vd3AtYWRtaW4vaW1wb3J0DQojIHdnZXQgLWMgaHR0cDovL3d3dy50ZWNobm9zYWlsb3IuY29tL2Rvd25sb2Fkcy9zZXJlbmRpcGl0eS1pbXBvcnRlci56aXANCiMgdW56aXAgc2VyZW5kaXBpdHktaW1wb3J0ZXIuemlwDQo8L2NvZGU+[/code]

    – Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat [code]PGNvZGU+JHdwZGItPmVzY2FwZSgkZXh0ZW5kZWQpPC9jb2RlPg==[/code] to [code]PGNvZGU+JHBvc3RfYm9keTwvY29kZT4=[/code] variable.

    – Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.

    [code]PGNvZGU+DQpHUkFOVCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gXCdyb290XCdAXCcxMjcuMC4wLjFcJyBpZGVudGlmaWVkIGJ5IFwneW91cl9teXNxbF9wYXNzd2RcJzsNCkZMVVNIIFBSSVZJTEVHRVM7DQo8L2NvZGU+[/code]

    – Verify your s9y database name and prefix. By default it’s “serendipity” and “serendipity_” respectively. Try listing [code]PGNvZGU+bHMgLTEgL3Zhci9saWIvbXlzcWwvPC9jb2RlPg==[/code]

    – 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:

    [code]PGNvZGU+DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBVc2VyOiByb290DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBQYXNzd29yZDogeW91cl9teXNxbF9wYXNzd29yZA0KU2VyZW5kaXBpdHkgRGF0YWJhc2UgTmFtZTogc2VyZW5kaXBpdHkNClNlcmVuZGlwaXR5IERhdGFiYXNlIEhvc3Q6IDEyNy4wLjAuMQ0KU2VyZW5kaXBpdHkgVGFibGUgcHJlZml4IChpZiBhbnkpOiBzZXJlbmRpcGl0eV8NCjwvY29kZT4=[/code]

    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.

  38. This [code]PGNvZGU+c2VyZW5kaXBpdHkucGhwPC9jb2RlPg==[/code] 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:[code]PGNvZGU+DQojIGNkIHt3b3JkcHJlc3Nfd2ViX3Jvb3RfcGF0aH0vd3AtYWRtaW4vaW1wb3J0DQojIHdnZXQgLWMgaHR0cDovL3d3dy50ZWNobm9zYWlsb3IuY29tL2Rvd25sb2Fkcy9zZXJlbmRpcGl0eS1pbXBvcnRlci56aXANCiMgdW56aXAgc2VyZW5kaXBpdHktaW1wb3J0ZXIuemlwDQo8L2NvZGU+[/code]- Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat [code]PGNvZGU+JHdwZGItPmVzY2FwZSgkZXh0ZW5kZWQpPC9jb2RlPg==[/code] to [code]PGNvZGU+JHBvc3RfYm9keTwvY29kZT4=[/code] variable.- Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.[code]PGNvZGU+DQpHUkFOVCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gXCdyb290XCdAXCcxMjcuMC4wLjFcJyBpZGVudGlmaWVkIGJ5IFwneW91cl9teXNxbF9wYXNzd2RcJzsNCkZMVVNIIFBSSVZJTEVHRVM7DQo8L2NvZGU+[/code]- Verify your s9y database name and prefix. By default it’s “serendipity” and “serendipity_” respectively. Try listing [code]PGNvZGU+bHMgLTEgL3Zhci9saWIvbXlzcWwvPC9jb2RlPg==[/code]- 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:[code]PGNvZGU+DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBVc2VyOiByb290DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBQYXNzd29yZDogeW91cl9teXNxbF9wYXNzd29yZA0KU2VyZW5kaXBpdHkgRGF0YWJhc2UgTmFtZTogc2VyZW5kaXBpdHkNClNlcmVuZGlwaXR5IERhdGFiYXNlIEhvc3Q6IDEyNy4wLjAuMQ0KU2VyZW5kaXBpdHkgVGFibGUgcHJlZml4IChpZiBhbnkpOiBzZXJlbmRpcGl0eV8NCjwvY29kZT4=[/code]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.

  39. This [code]PGNvZGU+c2VyZW5kaXBpdHkucGhwPC9jb2RlPg==[/code] 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:[code]PGNvZGU+DQojIGNkIHt3b3JkcHJlc3Nfd2ViX3Jvb3RfcGF0aH0vd3AtYWRtaW4vaW1wb3J0DQojIHdnZXQgLWMgaHR0cDovL3d3dy50ZWNobm9zYWlsb3IuY29tL2Rvd25sb2Fkcy9zZXJlbmRpcGl0eS1pbXBvcnRlci56aXANCiMgdW56aXAgc2VyZW5kaXBpdHktaW1wb3J0ZXIuemlwDQo8L2NvZGU+[/code]- Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat [code]PGNvZGU+JHdwZGItPmVzY2FwZSgkZXh0ZW5kZWQpPC9jb2RlPg==[/code] to [code]PGNvZGU+JHBvc3RfYm9keTwvY29kZT4=[/code] variable.- Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.[code]PGNvZGU+DQpHUkFOVCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gXCdyb290XCdAXCcxMjcuMC4wLjFcJyBpZGVudGlmaWVkIGJ5IFwneW91cl9teXNxbF9wYXNzd2RcJzsNCkZMVVNIIFBSSVZJTEVHRVM7DQo8L2NvZGU+[/code]- Verify your s9y database name and prefix. By default it’s “serendipity” and “serendipity_” respectively. Try listing [code]PGNvZGU+bHMgLTEgL3Zhci9saWIvbXlzcWwvPC9jb2RlPg==[/code]- 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:[code]PGNvZGU+DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBVc2VyOiByb290DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBQYXNzd29yZDogeW91cl9teXNxbF9wYXNzd29yZA0KU2VyZW5kaXBpdHkgRGF0YWJhc2UgTmFtZTogc2VyZW5kaXBpdHkNClNlcmVuZGlwaXR5IERhdGFiYXNlIEhvc3Q6IDEyNy4wLjAuMQ0KU2VyZW5kaXBpdHkgVGFibGUgcHJlZml4IChpZiBhbnkpOiBzZXJlbmRpcGl0eV8NCjwvY29kZT4=[/code]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.

  40. This [code]PGNvZGU+c2VyZW5kaXBpdHkucGhwPC9jb2RlPg==[/code] 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:[code]PGNvZGU+DQojIGNkIHt3b3JkcHJlc3Nfd2ViX3Jvb3RfcGF0aH0vd3AtYWRtaW4vaW1wb3J0DQojIHdnZXQgLWMgaHR0cDovL3d3dy50ZWNobm9zYWlsb3IuY29tL2Rvd25sb2Fkcy9zZXJlbmRpcGl0eS1pbXBvcnRlci56aXANCiMgdW56aXAgc2VyZW5kaXBpdHktaW1wb3J0ZXIuemlwDQo8L2NvZGU+[/code]- Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat [code]PGNvZGU+JHdwZGItPmVzY2FwZSgkZXh0ZW5kZWQpPC9jb2RlPg==[/code] to [code]PGNvZGU+JHBvc3RfYm9keTwvY29kZT4=[/code] variable.- Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.[code]PGNvZGU+DQpHUkFOVCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gXCdyb290XCdAXCcxMjcuMC4wLjFcJyBpZGVudGlmaWVkIGJ5IFwneW91cl9teXNxbF9wYXNzd2RcJzsNCkZMVVNIIFBSSVZJTEVHRVM7DQo8L2NvZGU+[/code]- Verify your s9y database name and prefix. By default it’s “serendipity” and “serendipity_” respectively. Try listing [code]PGNvZGU+bHMgLTEgL3Zhci9saWIvbXlzcWwvPC9jb2RlPg==[/code]- 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:[code]PGNvZGU+DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBVc2VyOiByb290DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBQYXNzd29yZDogeW91cl9teXNxbF9wYXNzd29yZA0KU2VyZW5kaXBpdHkgRGF0YWJhc2UgTmFtZTogc2VyZW5kaXBpdHkNClNlcmVuZGlwaXR5IERhdGFiYXNlIEhvc3Q6IDEyNy4wLjAuMQ0KU2VyZW5kaXBpdHkgVGFibGUgcHJlZml4IChpZiBhbnkpOiBzZXJlbmRpcGl0eV8NCjwvY29kZT4=[/code]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.

  41. This [code]PGNvZGU+c2VyZW5kaXBpdHkucGhwPC9jb2RlPg==[/code] 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:[code]PGNvZGU+DQojIGNkIHt3b3JkcHJlc3Nfd2ViX3Jvb3RfcGF0aH0vd3AtYWRtaW4vaW1wb3J0DQojIHdnZXQgLWMgaHR0cDovL3d3dy50ZWNobm9zYWlsb3IuY29tL2Rvd25sb2Fkcy9zZXJlbmRpcGl0eS1pbXBvcnRlci56aXANCiMgdW56aXAgc2VyZW5kaXBpdHktaW1wb3J0ZXIuemlwDQo8L2NvZGU+[/code]- Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat [code]PGNvZGU+JHdwZGItPmVzY2FwZSgkZXh0ZW5kZWQpPC9jb2RlPg==[/code] to [code]PGNvZGU+JHBvc3RfYm9keTwvY29kZT4=[/code] variable.- Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.[code]PGNvZGU+DQpHUkFOVCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gXCdyb290XCdAXCcxMjcuMC4wLjFcJyBpZGVudGlmaWVkIGJ5IFwneW91cl9teXNxbF9wYXNzd2RcJzsNCkZMVVNIIFBSSVZJTEVHRVM7DQo8L2NvZGU+[/code]- Verify your s9y database name and prefix. By default it’s “serendipity” and “serendipity_” respectively. Try listing [code]PGNvZGU+bHMgLTEgL3Zhci9saWIvbXlzcWwvPC9jb2RlPg==[/code]- 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:[code]PGNvZGU+DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBVc2VyOiByb290DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBQYXNzd29yZDogeW91cl9teXNxbF9wYXNzd29yZA0KU2VyZW5kaXBpdHkgRGF0YWJhc2UgTmFtZTogc2VyZW5kaXBpdHkNClNlcmVuZGlwaXR5IERhdGFiYXNlIEhvc3Q6IDEyNy4wLjAuMQ0KU2VyZW5kaXBpdHkgVGFibGUgcHJlZml4IChpZiBhbnkpOiBzZXJlbmRpcGl0eV8NCjwvY29kZT4=[/code]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.

  42. This [code]PGNvZGU+c2VyZW5kaXBpdHkucGhwPC9jb2RlPg==[/code] 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:[code]PGNvZGU+DQojIGNkIHt3b3JkcHJlc3Nfd2ViX3Jvb3RfcGF0aH0vd3AtYWRtaW4vaW1wb3J0DQojIHdnZXQgLWMgaHR0cDovL3d3dy50ZWNobm9zYWlsb3IuY29tL2Rvd25sb2Fkcy9zZXJlbmRpcGl0eS1pbXBvcnRlci56aXANCiMgdW56aXAgc2VyZW5kaXBpdHktaW1wb3J0ZXIuemlwDQo8L2NvZGU+[/code]- Apply the fix to include extended data on s9y entries table. See SoGua comment. Just add or concat [code]PGNvZGU+JHdwZGItPmVzY2FwZSgkZXh0ZW5kZWQpPC9jb2RlPg==[/code] to [code]PGNvZGU+JHBvc3RfYm9keTwvY29kZT4=[/code] variable.- Add MySQL admin (e.g., root) access to 127.0.0.1 host to avoid possible MySQL connection issue.[code]PGNvZGU+DQpHUkFOVCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gXCdyb290XCdAXCcxMjcuMC4wLjFcJyBpZGVudGlmaWVkIGJ5IFwneW91cl9teXNxbF9wYXNzd2RcJzsNCkZMVVNIIFBSSVZJTEVHRVM7DQo8L2NvZGU+[/code]- Verify your s9y database name and prefix. By default it’s “serendipity” and “serendipity_” respectively. Try listing [code]PGNvZGU+bHMgLTEgL3Zhci9saWIvbXlzcWwvPC9jb2RlPg==[/code]- 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:[code]PGNvZGU+DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBVc2VyOiByb290DQpTZXJlbmRpcGl0eSBEYXRhYmFzZSBQYXNzd29yZDogeW91cl9teXNxbF9wYXNzd29yZA0KU2VyZW5kaXBpdHkgRGF0YWJhc2UgTmFtZTogc2VyZW5kaXBpdHkNClNlcmVuZGlwaXR5IERhdGFiYXNlIEhvc3Q6IDEyNy4wLjAuMQ0KU2VyZW5kaXBpdHkgVGFibGUgcHJlZml4IChpZiBhbnkpOiBzZXJlbmRpcGl0eV8NCjwvY29kZT4=[/code]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.

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

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

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

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

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

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

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

  50. 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 373WordPressError establishing a database connectionThis 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.

  51. 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 373WordPressError establishing a database connectionThis 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.

  52. 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 373WordPressError establishing a database connectionThis 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.

  53. 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 373WordPressError establishing a database connectionThis 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.

  54. 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 373WordPressError establishing a database connectionThis 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  73. Pingback: The Best of 2007
  74. 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?? :-)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Comments are closed.