Changed STUDENT now no adminstrator ability

Changed STUDENT now no adminstrator ability

Greg Murphy -
回帖数：2

This may be simple to fix, but I don't want to burn out my brain if someone else has seen this.

When I changed priveleges for STUDENTS  and saved, I found that my defaut login didn't give me ADMINSISTRATOR abilities.

Before I mess too much with PHP and SQL, has anyone else made this boneheaded mistake and corrected it?

I think the problem was that I changed what a student could do (after an initial installation and lots of additions) before I defined what an ADMINISTRATOR could do.

Now, it seems, every possible log in has no abilities to call up the EDIT FUNCTION on the main page or do anything.

I can't access any of the administrator functiions!

Your help is appreciated.

PS:  I know how to access some configuration of tables and fields in PHP MyAdmin  but hesitate to go futher.

Thanks.

Murph

平均分： -
回复Greg Murphy

Re: Changed STUDENT now no adminstrator ability

Mary Cooch -
Documentation writers的头像 Moodle HQ的头像 Particularly helpful Moodlers的头像 Testers的头像 Translators的头像
Hi there - you could try this
平均分： -
回复Mary Cooch

Re: Changed STUDENT now no adminstrator ability

Greg Murphy -

GOOD ON ME !

I can’t hardly believe it, but I found a solution without running that script. While that would have probably done the trick, I was concerned about the scary disclaimer inside.

So, I did the following. The net result is apparent success in getting back my site administration.  big grin

1. Went into MYSQL and browsed mdl_role_capabilties

2. Noted permissions were “1, “-1” and “-1000” which I assumed corresponded to Allow, Prevent and Prohibit.

3. Saw lots of -1000 entries with timestamps 1264110300 and 1264110299. Didn’t know how to convert, but assumed they were close to the same time. I noted that modifier ID was 2.

4. Picked one of the -1000 entries to change (It may be helpful to find out which one, but the one I used seemed a logical one to try.

5. Ran query on this one change.

6. Went to site and found edit button on front page when I logged in. This wasn’t previoiusly available since I messed things up yesterday!

7. Went back in and changed more -1000 items moodle/zite:XXXXXXX and moodle/role:manage

8. Ran the query to modify the database table and records.

9. Loggin in with apparent full adminstrator rights.

10. There are still things that have -1000 permissions, but my ability to do it from within the site will let me change them there for each type of user.

If someone else needs to see how this is done, I can do a few screen snaps or a quick Captivate flash.

Murph

平均分： -