Admin account inacive

Permalink
I was in system maintenance > jobs and i ran checked after that my admin account went inactive any idea how to re-activate the admin account.

 
Mnkras replied on at Permalink Reply
Mnkras
What do you mean "went inactive"?
Rmacogle replied on at Permalink Reply 1 Attachment
Now when i go to log in i input my username and password i get a this user is inactive message see posted screen shot.
Mainio replied on at Permalink Reply
Mainio
As far as I know you shouldn't even be able to unactivate the main admin user.

However, if this has happened (e.g. because of some bug in some add-on), you can fix it with this SQL command:
UPDATE Users SET uIsActive = 1 WHERE uName = 'admin';



Antti / Mainio
Rmacogle replied on at Permalink Reply
Thank you for your help but I am very new to this where do I input the code?
Rmacogle replied on at Permalink Reply
Thank you for your help I really appreciate it. But I am very new at all of this where do I input the command at?
Mainio replied on at Permalink Reply
Mainio
Ok, you would need basic knowledge about handling your MySQL server, that's all I can help.

There are various guides around in internet for connecting to your MySQL server, one of which is here:
http://dev.mysql.com/doc/refman/5.0/en/connecting.html...

You can always ask for someone to do that for you if you're not willing to learn yourself. Google can be a big help!

You can find your MySQL credentials for accessing the server from your site's site.php configuration file. The path to the file looks something like this but depends on your server environment:
/your_home_folder/public_html/config/site.php


Br,
Antti / Mainio