[lesliekirk]

For some reason the admin that was set up for the site can't login. The site is "down for maintenance" and when the admin tries to log in, it just keeps rolling back to the "down for maintenance" message instead of the backend.

Am I going to need to poke around in the MySQL file to see if the admin (1st account created) login was somehow changed?

Many thanks!
Leslie the Lost

[lesliekirk]

I'm still digging on this one, but it looks like somehow there is no longer an admin account - even though there is still a USER ID 1 in the database, when I try to log in with it's user name & password - the admin no longer comes up.

[Michael]

totally possible. check that the admin user account in the database is actually a master admin group.

In JR5 any account can be made to be an admin account, so if you un-make the main admin account an admin and leave the site without any admins, you would be stuck.

need to edit the database then and make one account an admin. I think the group was 'master' but if someone could confirm that that would be useful.


_________________
Michael Ussher
Jamroom Network Team Member: http://www.jamroom.net
Priority Support: http://www.jamroom.net/Support_Center

[lesliekirk]

Thanks - off hand do you know which table I need to take a peek at?

[Michael]

I haven't got my dev server up right now so cant give accurate specifics, but from memory, i think its the user datastore, so that will be...

jr_jruser_item_key

and look for the key=>value set of something like
1 user_group standard

and change it to
1 user_group master

to change the user 1 from group 'standard' to group 'master'.

The part im not sure of is the wording for master. im not sure if its 'master' or 'admin' or something else.

so if you have another JR5 installed database, check that ones settings and that will give you the correct wording. (or maybe someone who has one can chime in here.)


_________________
Michael Ussher
Jamroom Network Team Member: http://www.jamroom.net
Priority Support: http://www.jamroom.net/Support_Center

[lesliekirk]

Thanks Michael,

I' think we are getting warmer. There are currently 3 users, all 3 of them have a user_group value of user. I'll see what happens when I change the user 1 to master.

Leslie

ps...thanks for being gentle with me the noob

[Michael]

There's a lot to learn,

Good on you for trying.

Im just not sure of the term. see I thought the group was 'standard' but you figured out it was 'user'. It could be the same with the master term too. Try 'master' first, then try 'admin'.

If neither of those work might need to wait for someone with phpmyadmin fired up to give input.


_________________
Michael Ussher
Jamroom Network Team Member: http://www.jamroom.net
Priority Support: http://www.jamroom.net/Support_Center

[lesliekirk]

I changed user to master and it did the trick.

Thanks!
Leslie