importing from wordpress 2.0

[Rocksolid]

I'm trying to import entries from the new wordpress 2.0 but i get the error:

Starting import procedure...
Import failed: Could not select user information: .

Any help would be greatly appreciated.

Thank you

[garvinhicking]

If you get that message, then the SQL query:

Code: Select all

SELECT ID, user_login, user_pass, user_email, user_level FROM PREFIX_users;

could not be executed.

Check if you can execute that query in your phpMyAdmin or sth. like that. Replace "PREFIX_" with the prefix you entered in the import config!

I haven't yet looked at the new DB SQL structure, but I'll doubt that there are many changes...

HTH,
Garvin

[Guest]

There's no user_level. I'll remove that bit and see if it works

[Rocksolid]

Guess i wasn't logged in on the reply...

Removing the user_level parts from the import script did it. I was the only user on the wordpress blog so maybe it didn't call for user_level, then again maybe it's changed in wordpress 2.0

Thanks for the help Garvin

[garvinhicking]

Thanks a lot! I'll see how to get this into our next version so that user_level is optional.

Regards,
Garvin

[anitaulu]

Hello! I'm having the same issue, and getting the same error message as above. I am in wordpress.inc.php, and looking for this user_level to delete - but don't want to touch anything, just in case! Can you tell me what I can do to import my WP entries?

[garvinhicking]

Hi!

I suggest you to use the recent s9y version 1.0-beta3. This will get release as 1.0 during the course of the next days, so this is the most stable version to date. And it contains the fix for the WP importer code.

Regards,
Garvin

[anitaulu]

Hi, Garvin.
I am now getting the message: Import failed: Could not select user information: Access denied for user 'XXX'@'localhost' to database 'XXX'. I got support from my host, and they were unable to find the error. I'm sure it's something really simple, but would very much like to get this sorted out. You can email me, if you wish to keep the chatter down, on the board!
anita@chowslurp.com

Thanks!!

[anitaulu]

Garvin, nevermind...I used the Generic RSS, and it worked perfectly!!



EDIT: is there a way to import comments using RSS?

[garvinhicking]

Hi!

That import error you got means that the password you specified does not work to give serendipity access to the WP table! Please double-check your password/username and make sure that the host were your s9y is running is allowed to access the DB server!

HTH,
Garvin

[anitaulu]

Hey, Garvin. It's okay - I got everything to work! Loving Serendipity, it's fantastic, thanks!!!

Anita.