Page 1 of 1
importing from wordpress 2.0
Posted: Mon Jan 02, 2006 5:36 pm
by 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
Re: importing from wordpress 2.0
Posted: Mon Jan 02, 2006 5:54 pm
by 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
Posted: Mon Jan 02, 2006 6:01 pm
by Guest
There's no user_level. I'll remove that bit and see if it works
Posted: Mon Jan 02, 2006 6:10 pm
by 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
Posted: Mon Jan 02, 2006 7:02 pm
by garvinhicking
Thanks a lot! I'll see how to get this into our next version so that user_level is optional.
Regards,
Garvin
Posted: Mon Jun 12, 2006 1:55 am
by 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?
Posted: Mon Jun 12, 2006 9:59 am
by 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
Posted: Mon Jun 12, 2006 9:29 pm
by 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!!
Posted: Mon Jun 12, 2006 9:34 pm
by anitaulu
Garvin, nevermind...I used the Generic RSS, and it worked perfectly!!
EDIT: is there a way to import comments using RSS?
Posted: Mon Jun 12, 2006 9:55 pm
by 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
Posted: Mon Jun 12, 2006 10:29 pm
by anitaulu
Hey, Garvin. It's okay - I got everything to work! Loving Serendipity, it's fantastic, thanks!!!
Anita.
