Installation issue Query failed in load_user_capability

Installation issue Query failed in load_user_capability

by Dion Myers -
Number of replies: 9
After upgrading to the new Moodle 1.7, I receive the following error:

Query failed in load_user_capability

I no longer have admin capabilities. This is a HUGE problem. Please help.

Mac OS X 10.4.8
MySQL 5.0.24
PHP 5.2.0

Please help! I am in dire straits!!

Thanks,
Dion Myers
Average of ratings: -
In reply to Dion Myers

Re: Installation issue Query failed in load_user_capability

by Dion Myers -
Can any one point me in the right direction?

I am panicked.
Average of ratings: -
In reply to Dion Myers

Re: Installation issue Query failed in load_user_capability

by Dion Myers -
I noticed that if I ran:

http://mydomain/admin

the tables were upgraded, but I had to repeatedly enter that URL and it would upgrade a section, then kick me back to the start page.

Now, it claims I don't have privleges to be an admin.

Any ideas?

Dion
Average of ratings: -
In reply to Dion Myers

Re: Installation issue Query failed in load_user_capability

by Dion Myers -
I tried upgrading from 1.6.3+ to 1.7+ on a :
Query
Mac OS X 10.4.8 server
MySQL 5.0.24
PHP 5.2.0

the first time, after I was walked through the upgrade and asked to save the config, I was kicked out and the Moodle lost it's theme. I immediately downgraded.

When I downgraded, I was told that the code I was running was older than the code that created the database (after I had replaced the MySQL moodle db).

I upgraded, but I had to run each step as follows:

http://mydomain/admin

each time, the message said that the table was upgraded but the capabilities were not. It would then kick me back to the main page. I continued to type the URL until it said it finished, then I receive the message:

Query failed in load_user_capability

Now, when I try to manually load"

http://mydomain/admin

I receive the message:

Sorry, but you do not currently have permissions to do that (Change site configuration)

Is this resolveable? I have so many users and teachers and everything has come to a halt. Please help.

TIA,
Dion
Average of ratings: -
In reply to Dion Myers

Re: Installation issue Query failed in load_user_capability

by Dion Myers -
Can anyone help me? After reading more, it seems that I have lost my admin "role." Is there any way I can restore my admin privileges? The whole saga began when the computer choked during a backup. Then, I tried several things and when all else failed, I tried to upgrade. This is when I received the above. I could really use some help here.

Anyone? Please?

TIA,
Dion
Average of ratings: -
In reply to Dion Myers

Re: Installation issue Query failed in load_user_capability

by Timothy Takemoto -
Dear Dion
Edward Gash had a simiar problem and gave himself back the admin role with the help of a database editor.
http://moodle.org/mod/forum/discuss.php?d=58405
I would have helped sooner but the title of this thread looked a bit daunting.
Timothy
Average of ratings: -
In reply to Timothy Takemoto

Re: Installation issue Query failed in load_user_capability

by Dion Myers -
I looked at his post, but when I tried to look at the mdl_role_assignments table, it has no data. Any ideas?
Average of ratings: -
In reply to Dion Myers

Re: Installation issue Query failed in load_user_capability

by António Godinho -
I've the same problem and wasn't able to fix it...
Average of ratings: -
In reply to António Godinho

Re: Installation issue Query failed in load_user_capability

by Xiangen Hu -

here is what I did:

  1. get a freah install of 1.7
  2. backup the one with problems (without all the "role_xxx" tables)
  3. restore the backed table to the fresh installed
  4. copy data to the new install

Average of ratings: -
In reply to Xiangen Hu

Re: Installation issue Query failed in load_user_capability

by Rob Hill -
What if you can't back up your site?
Average of ratings: -