I had a problem with new member spam in an ExpressionEngine Site. Over a couple days, I amassed 20k members. I disabled new member registration but I still had to get rid of all the extraneous members. I ran an SQL statement to delete all members who had never made a comment or a forum post but I didn't realize that the admin member that I use was also deleted. Now I can't log in to fix the problem.
Even stranger, an account which I know that I did not delete can also not log in anymore.
Does anyone have suggestions to help me log in?
edit: using ee v 1.6.1
Evan - if you can access your database directly, via phpMyAdmin or otherwise, just create a new member directly without a password, then use the password reset function (link found on the EE login screen) to have a new one generated and sent to you.
Just enter values for username, screen_name, and email_address, and set the group_id to 1.