I Want to Undo AN SQL Command on My DB
I was trying to find a solution to registration new users on my site; and I used an advice from a Wordpress forum to run a particular SQL query. Now when I try to log into my Admin account, the login page just returns to the regular Wordpress login and then refreshes itself.
The initial problem I was trying to solve is that new users that register on my website get an activation e-mail that leads them to a page that asks for "activation key"; and yet nothing in the email sent to them is called an activation key. When they copy and paste the numbers on the URL for account activation, the server replies "invalid activation key"
So, here's what the guy at the Wordpress forum posted awhile back :
Invalid activation key errors can sometimes be fixed by running this query on your DB:
UPDATE wp_users SET user_activation_key = '' WHERE user_activation_key LIKE '%$%'
Be sure to change wp_users to your actual users table if you use a non-default DB prefix.
How does this work? If the user_activation_key field is blank, WP will create a new one that's not invalid.
I copied this and ran it on my DB. Now, I can't even log into my account. That means my users will not also be able to log into their account even though I have used a plugin to disable the need for activation e-mail.
My site is Afrimash | Building the Largest Community of Food Providers for Africa. I need help. I'm not an SQL expert. I was looking for a simple solution.
Your responses will help me. Thanks.
-
prima854 -
Thanks
{{ DiscussionBoard.errors[10024056].message }} -
-
Aravind Murthy -
Thanks
{{ DiscussionBoard.errors[10025334].message }} -
-
Crystal_Jobs -
Thanks
SignatureBusiness Email Samples | Top Rated Business Books{{ DiscussionBoard.errors[10025513].message }} -