Found the missing bit: the display_name and user_nicename fields also need to be updated….
So:
UPDATE wp_users u INNER JOIN newDir.hashOldLoginToNew l ON u.user_login = l.oldLogin
SET
u.user_login = l.newLogin,
u.user_nicename = l.newLogin,
u.display_name = l.newLogin
works beautifully!
HTH someone else stuck in this problem….
–Dale
re-doing the installation from scratch with a fresh download of the installation tarball.
hopefully i won’t encounter the same error again.
thanks.
ricardusexa–
Thanks for the help. I *am* my own service provider. The DB is fine, I can connect to it, use the appropriate database, and even pull records from it.
The issue seems to be a missing sunrise.php file. Where can I obtain this file?
–Dale
