I've been having upgrade problems which seems to be roles have not been assigned/created properly - as an admin I'm locked out.
I've looked into the DB and looking at the various tables and I think role number 13 should be an administrator - is there a way I can manually create/check the role assignment? Any ideas why moodle does allow me to act as an admin?
User Table
mdl_user |
||||||||||||||||||||||||||||||||||||||||||||
id |
auth |
confirmed |
policyagreed |
deleted |
username |
password |
idnumber |
firstname |
lastname |
|
emailstop |
icq |
skype |
yahoo |
aim |
msn |
phone1 |
phone2 |
institution |
department |
address |
city |
country |
lang |
theme |
timezone |
firstaccess |
lastaccess |
lastlogin |
currentlogin |
lastip |
secret |
picture |
url |
description |
mailformat |
maildigest |
maildisplay |
htmleditor |
autosubscribe |
trackforums |
timemodified |
trustbitmask |
|
13 |
manual |
1 |
0 |
0 |
ian |
SACSnet |
Administrator |
iscott@sacs.nsw.edu.au |
0 |
Sydney |
AU |
en_utf8 |
99 |
0 |
1164759201 |
1164757768 |
1164759195 |
10.0.5.201 |
1 |
1 |
0 |
1 |
1 |
1 |
1 |
0 |
1140672224 |
0 |
mdl_role_capabilities |
||||||
id |
contextid |
roleid |
capability |
timemodified |
modifierid |
|
1 |
1 |
1 |
moodle/legacy:admin |
1 |
1164756643 |
0 |
mdl_role_assignments |
||||||||||
id |
roleid |
contextid |
userid |
hidden |
timestart |
timeend |
timemodified |
modifierid |
enrol |
sortorder |
1 |
1 |
1 |
13 |
0 |
0 |
0 |
1164756644 |
0 |
manual |
0 |
mdl_role |
||||
id |
name |
shortname |
description |
sortorder |
1 |
Administrator |
admin |
Administrators can usually do anything on the site, in all courses. |
0 |
mdl_access_owner |
|||||||
id |
fkid |
description |
designee |
designee_type |
designee_description |
timecreated |
timemodified |
1 |
1 |
repository_file |
13 |
1 |
1147742976 |
1147742976 |