I was about to upgrade from 1.7.3. to 1.83 and run into problems. I just run first step where Environment and server checks was performed. On this page "unicode" appears in RED and as I understand this must be solved prior to going further with upgrade. Then I choosed that I do not want to go further with upgrade, reverted back to 1.7.3 (renamed back 1.7.3 folder for default moodle folder). But now there is a problem as when I login to moodle, admin is not the same, it is like I am logged as user and not admin ! I was about to perform this unicode migration but I can not login as admin anymore. I mean, I can, but in there , there are no settings and moodle stuff. How can i solve this or how can I set this unicode some other way - safe way.
Please help me solve this.
Hi, I can't quite remember but I think there is an user ID number change. We are still using 1.6.3 where the admin account is ID 1. Then it changes I think in 1.8 to ID 2. This is great if you start with a brand new version then add the content individually but if like me you have a great big sql file to restore then it puts the ID back to 1. Then you have no admin rights although you can login. Worth a look see. Quest user becomes ID 1 and admin becomes 2. You might need to reverse the ID's on the database by putting quest out to some outlandish ID and changing admin to 2 and then change quest back to ID 1. Hope this is making sense.
However, I cannot figure out how to update the ruddy database. I keep seeing reference to a utility in 1.7, but cannot find it anywhere. Did you find that?
tried that but I am getting message "Sorry, but you do not currently have permissions to do that (Change site configuration)" and link http://docs.moodle.org/en/error/moodle/nopermissions
I tried this but unfortunately nothing helped, still when logged as admin , I have no rights to Moodle settings. Admin ID is 2, and guest ID is 1. I changed this guest to 2222, tried after that , nothing, then I changed Admin ID to 1, again nothing. So i reverted back how it was before.
So, any new ideas how to restore Admin rights ?
Unfortunately, everything is OK in this tables, I checked, everything pointing where it should. I have no idea what is going on.
In that case the next thing I would look at is the mdl_role_capabilities table in which the capabilities of each role are listed. In my database there are 149 rows in that table for the administrator role alone. I have attached a list of them to this post.