Skip to content

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.

178 Comments

  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. Found the solution….

    as Database host enter “127.0.0.1” instead of “localhost”

  14. Found the solution….as Database host enter “127.0.0.1” instead of “localhost”

  15. Found the solution….as Database host enter “127.0.0.1” instead of “localhost”

  16. Found the solution….as Database host enter “127.0.0.1” instead of “localhost”

  17. Found the solution….as Database host enter “127.0.0.1” instead of “localhost”

  18. Found the solution….as Database host enter “127.0.0.1” instead of “localhost”

  19. *grins*

    Keep up the good work! You’re a life saver!
    *hug* :)

  20. *grins*Keep up the good work! You’re a life saver!*hug* :)

  21. *grins*Keep up the good work! You’re a life saver!*hug* :)

  22. *grins*Keep up the good work! You’re a life saver!*hug* :)

  23. *grins*Keep up the good work! You’re a life saver!*hug* :)

  24. *grins*Keep up the good work! You’re a life saver!*hug* :)

  25. Great job, I just used it to save me some time!

    One thing, why does it not pull the extended text?

  26. Great job, I just used it to save me some time!One thing, why does it not pull the extended text?

  27. Great job, I just used it to save me some time!One thing, why does it not pull the extended text?

  28. Great job, I just used it to save me some time!One thing, why does it not pull the extended text?

  29. Great job, I just used it to save me some time!One thing, why does it not pull the extended text?

  30. Great job, I just used it to save me some time!One thing, why does it not pull the extended text?

  31. […] alten Beiträge habe ich mit dem Skript von technosailer.com von Serendipity zu WordPress importiert. Das ganze hat fast ohne Probleme (Umlaute wurden zum Teil […]

  32. […] Serendipity (s9y) to WordPress Importer – Script zum Importieren von Serendipity-Inhalten in ein WordPress-Weblog. Tags:&nbsp […]

  33. Kim Kim

    I’m trying to download this and it tells me that the file is corrupted?

  34. Kim Kim

    I’m trying to download this and it tells me that the file is corrupted?

  35. Kim Kim

    I’m trying to download this and it tells me that the file is corrupted?

  36. Kim Kim

    I’m trying to download this and it tells me that the file is corrupted?

  37. Kim Kim

    I’m trying to download this and it tells me that the file is corrupted?

  38. Kim Kim

    I’m trying to download this and it tells me that the file is corrupted?

  39. I work just half way, i cant import my extended message to my wordpress.

    ANy new solution?

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

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

  41. I work just half way, i cant import my extended message to my wordpress.ANy new solution?

  42. I work just half way, i cant import my extended message to my wordpress.ANy new solution?

  43. I work just half way, i cant import my extended message to my wordpress.ANy new solution?

  44. I work just half way, i cant import my extended message to my wordpress.ANy new solution?

  45. I work just half way, i cant import my extended message to my wordpress.ANy new solution?

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

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

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

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

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

  51. 54 54

    what do you mean SoGua? And kim and ether repare the file, or re download the file.

  52. 54 54

    what do you mean SoGua? And kim and ether repare the file, or re download the file.

  53. 54 54

    what do you mean SoGua? And kim and ether repare the file, or re download the file.

  54. 54 54

    what do you mean SoGua? And kim and ether repare the file, or re download the file.

  55. 54 54

    what do you mean SoGua? And kim and ether repare the file, or re download the file.

  56. 54 54

    what do you mean SoGua? And kim and ether repare the file, or re download the file.

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

    what is the problem?

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

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

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

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

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

  63. no one here to help me?

  64. no one here to help me?

  65. no one here to help me?

  66. no one here to help me?

  67. no one here to help me?

  68. no one here to help me?

  69. […] serendipity blog system, to wordpress instead. I used this sweet little conversion script, called Serendipity to WordPress importer. I just had to put the script in the directory, give it my db credentials, and import all my […]

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

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

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

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

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

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

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

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

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

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

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

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

  82. peanutsof80s peanutsof80s

    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.

  83. peanutsof80s peanutsof80s

    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.

  84. peanutsof80s peanutsof80s

    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.

  85. peanutsof80s peanutsof80s

    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.

  86. peanutsof80s peanutsof80s

    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.

  87. peanutsof80s peanutsof80s

    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.

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

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

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

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

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

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

  94. Jonathan Jonathan

    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.

  95. Jonathan Jonathan

    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.

  96. Jonathan Jonathan

    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.

  97. Jonathan Jonathan

    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.

  98. Jonathan Jonathan

    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.

  99. Jonathan Jonathan

    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.

  100. peanutsof80s peanutsof80s

    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.

  101. peanutsof80s peanutsof80s

    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.

  102. peanutsof80s peanutsof80s

    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.

  103. peanutsof80s peanutsof80s

    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.

  104. peanutsof80s peanutsof80s

    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.

  105. peanutsof80s peanutsof80s

    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.

  106. CMB CMB

    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

  107. CMB CMB

    Also, All the posts are attributed to the admin

  108. CMB CMB

    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

  109. CMB CMB

    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

  110. CMB CMB

    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

  111. CMB CMB

    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

  112. CMB CMB

    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

  113. CMB CMB

    Also, All the posts are attributed to the admin

  114. CMB CMB

    Also, All the posts are attributed to the admin

  115. CMB CMB

    Also, All the posts are attributed to the admin

  116. CMB CMB

    Also, All the posts are attributed to the admin

  117. CMB CMB

    Also, All the posts are attributed to the admin

  118. CMB CMB

    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

  119. CMB CMB

    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

  120. CMB CMB

    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

  121. CMB CMB

    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

  122. CMB CMB

    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

  123. CMB CMB

    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

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

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

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

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

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

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

  130. […] New Version of Serendipity (s9y) to WordPRess Importer […]

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

    Regards from Brazil

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

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

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

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

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

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

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

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

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

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

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

  143. Zoe Zoe

    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!

  144. Zoe Zoe

    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!

  145. Zoe Zoe

    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!

  146. Zoe Zoe

    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!

  147. Zoe Zoe

    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!

  148. Zoe Zoe

    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!

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

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

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

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

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

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

  155. Thanks. But I have problems same Jonathan

  156. Thanks. But I have problems same Jonathan

  157. Thanks. But I have problems same Jonathan

  158. Thanks. But I have problems same Jonathan

  159. Thanks. But I have problems same Jonathan

  160. Thanks. But I have problems same Jonathan

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

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

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

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

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

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

  167. I just wanted to say thanks for the importer. It worked perfectly as described, and saved me a TON of work moving my old posts.

    Very much appreciated!

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

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