New Version of Serendipity (s9y) to WordPress Importer Available

Tell your friends!

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.

  • http://www.ckay.de ckay

    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)

  • http://www.ckay.de ckay

    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)

  • http://www.ckay.de ckay

    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)

  • http://www.ckay.de ckay

    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)

  • http://www.ckay.de ckay

    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)

  • http://www.ckay.de ckay

    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)

  • http://blog.phpaws.net Paws

    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

  • http://blog.phpaws.net Paws

    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

  • http://blog.phpaws.net Paws

    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

  • http://blog.phpaws.net Paws

    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

  • http://blog.phpaws.net Paws

    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

  • http://blog.phpaws.net Paws

    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

  • http://blog.phpaws.net Paws

    Found the solution….

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • Pingback: Forums » Technology, Blogging and New Media()

  • http://blog.phpaws.net Paws

    *grins*

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • Pingback: Serendipity Importer for WordPress Released » Technology, Blogging and New Media()

  • Pingback: Ramblings from the Marginalized » About the move…()

  • http://www.hmtk.com HMTKSteve

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

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

  • http://www.hmtk.com HMTKSteve

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

  • http://www.hmtk.com HMTKSteve

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

  • http://www.hmtk.com HMTKSteve

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

  • http://www.hmtk.com HMTKSteve

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

  • http://www.hmtk.com HMTKSteve

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

  • Pingback: Umstieg auf Wordpress()

  • Pingback: Lesezeichen vom 18. Februar()

  • http://www.kmsklinar.co.uk Kim

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

  • http://www.kmsklinar.co.uk Kim

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

  • http://www.kmsklinar.co.uk Kim

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

  • http://www.kmsklinar.co.uk Kim

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

  • http://www.kmsklinar.co.uk Kim

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

  • http://www.kmsklinar.co.uk Kim

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

  • http://sogua.mamakcorner.com SoGua

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

    ANy new solution?

  • http://sogua.mamakcorner.com SoGua

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

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • http://sogua.mamakcorner.com SoGua

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

  • 54

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

  • 54

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

  • 54

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

  • 54

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

  • 54

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

  • 54

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

  • http://gedankenblase.de ritman

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

    what is the problem?

  • http://gedankenblase.de ritman

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

  • http://gedankenblase.de ritman

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

  • http://gedankenblase.de ritman

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

  • http://gedankenblase.de ritman

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

  • http://gedankenblase.de ritman

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

  • http://gedankenblase.de ritman

    no one here to help me?

  • http://gedankenblase.de ritman

    no one here to help me?

  • http://gedankenblase.de ritman

    no one here to help me?

  • http://gedankenblase.de ritman

    no one here to help me?

  • http://gedankenblase.de ritman

    no one here to help me?

  • http://gedankenblase.de ritman

    no one here to help me?

  • Pingback: Voip Phreak - » Shift to WordPress()

  • http://zion.demon.nl/ Henk

    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?

  • http://zion.demon.nl/ Henk

    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?

  • http://zion.demon.nl/ Henk

    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?

  • http://zion.demon.nl/ Henk

    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?

  • http://zion.demon.nl/ Henk

    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?

  • http://zion.demon.nl/ Henk

    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?

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

  • http://blog.phpaws.net Paws

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

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

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

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

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

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

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

  • http://ryanroth.net Ryan

    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!

  • http://ryanroth.net Ryan

    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!

  • http://ryanroth.net Ryan

    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!

  • http://ryanroth.net Ryan

    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!

  • http://ryanroth.net Ryan

    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!

  • http://ryanroth.net Ryan

    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!

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

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

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

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

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

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

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

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

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

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

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

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

  • 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

  • CMB

    Also, All the posts are attributed to the admin

  • 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

  • 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

  • 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

  • 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

  • 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

  • CMB

    Also, All the posts are attributed to the admin

  • CMB

    Also, All the posts are attributed to the admin

  • CMB

    Also, All the posts are attributed to the admin

  • CMB

    Also, All the posts are attributed to the admin

  • CMB

    Also, All the posts are attributed to the admin

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • http://www.nicksfreepicks.com nick

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

  • http://www.nicksfreepicks.com nick

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

  • http://www.nicksfreepicks.com nick

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

  • http://www.nicksfreepicks.com nick

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

  • http://www.nicksfreepicks.com nick

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

  • http://www.nicksfreepicks.com nick

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

  • Pingback: The Best of 2007()

  • http://www.michelazzo.com.br/ Paulino Michelazzo

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

    Regards from Brazil

  • http://www.michelazzo.com.br/ Paulino Michelazzo

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

  • http://www.michelazzo.com.br/ Paulino Michelazzo

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

  • http://www.michelazzo.com.br/ Paulino Michelazzo

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

  • http://www.michelazzo.com.br/ Paulino Michelazzo

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

  • http://www.michelazzo.com.br/ Paulino Michelazzo

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

  • http://www.squashyfrog.co.uk/ Kolin Tregaskes

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

  • http://www.squashyfrog.co.uk/ Kolin Tregaskes

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

  • http://www.squashyfrog.co.uk/ Kolin Tregaskes

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

  • http://www.squashyfrog.co.uk/ Kolin Tregaskes

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

  • http://www.squashyfrog.co.uk/ Kolin Tregaskes

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

  • http://www.squashyfrog.co.uk/ Kolin Tregaskes

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

  • http://www.zoeselina.com 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!

  • http://www.zoeselina.com 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!

  • http://www.zoeselina.com 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!

  • http://www.zoeselina.com 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!

  • http://www.zoeselina.com 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!

  • http://www.zoeselina.com 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!

  • http://pwn.no-ip.org empika

    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

  • http://pwn.no-ip.org empika

    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

  • http://pwn.no-ip.org empika

    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

  • http://pwn.no-ip.org empika

    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

  • http://pwn.no-ip.org empika

    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

  • http://pwn.no-ip.org empika

    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

  • http://www.ronakorn.com/ asshur

    Thanks. But I have problems same Jonathan

  • http://www.ronakorn.com/ asshur

    Thanks. But I have problems same Jonathan

  • http://www.ronakorn.com/ asshur

    Thanks. But I have problems same Jonathan

  • http://www.ronakorn.com/ asshur

    Thanks. But I have problems same Jonathan

  • http://www.ronakorn.com/ asshur

    Thanks. But I have problems same Jonathan

  • http://www.ronakorn.com/ asshur

    Thanks. But I have problems same Jonathan

  • http://www.auctionwire.info Auctionwire

    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

  • http://www.auctionwire.info Auctionwire

    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

  • http://www.auctionwire.info Auctionwire

    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

  • http://www.auctionwire.info Auctionwire

    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

  • http://www.auctionwire.info Auctionwire

    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

  • http://www.auctionwire.info Auctionwire

    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

  • http://www.mycoffeecuphasfeet.com Phil Malmstrom

    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!

  • http://www.gooddir.com gooddirectory

    I getting WordPress database error.

  • http://www.gooddir.com gooddirectory

    I getting WordPress database error.

  • http://www.gooddir.com gooddirectory

    I getting WordPress database error.

  • http://www.gooddir.com gooddirectory

    I getting WordPress database error.

  • http://www.gooddir.com gooddirectory

    I getting WordPress database error.

  • http://www.gooddir.com gooddirectory

    I getting WordPress database error.

  • http://michael.tyson.id.au Michael Tyson

    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-

  • http://socialnetworkroadmap.com Chris Rollyson

    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-

Data provided by Marvel. © 2015 MARVEL