Query failed in load_user_capability

Query failed in load_user_capability

by Jerome De Cuyper -
Number of replies: 3
Hi!
I'm trying to install moodle on a windows server 2003 sp2 with php5 and mysql5.
The instalation goes fine untill the last step where it throws the following error: "Query failed in load_user_capability".
I'm able to see the moodle intro page but not as an admin.
I already tried a few patches (found on the moodle pages) but nothing is working.
Is the problem on the php/mysql/os or moodle side?
Thanks a lot for support!
Jerome



Average of ratings: -
In reply to Jerome De Cuyper

Re: Query failed in load_user_capability

by Richard Enison -
JDC,

This is a (more or less) known Moodle bug (http://tracker.moodle.org/browse/MDL-10090). It happens when an error occurs when a big query is run against the db to produce an array representing all the current user's role capabilities. You might be able to get it to work by increasing memory_limit. If not, I would turn debugging on (http://docs.moodle.org/en/Debugging) and see what errors are reported or logged.

RLE
Average of ratings: Useful (1)
In reply to Richard Enison

Re: Query failed in load_user_capability

by Jerome De Cuyper -
Hi RLE!

Thanks a lot for answering.

Your where right, I increased the memomy limit (to -1, which means no limit) in php.ini and everything worked fine.

I really appreciated your quick answer.

Jérôme.

In reply to Jerome De Cuyper

Re: Query failed in load_user_capability

by Olumuyiwa Taiwo -
Picture of Plugin developers
We also had this problem today, but in our case it was because we had gone over our disk quota - in the /tmp directory, but it could probably have beec caused by anything that causes the hosting account to go over quota.

Hope this helps someone.

Muyi