从数据库中删除成员后无法登录ExpressionEngine

Question

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

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