Gradebook is not opening

Re: Gradebook is not opening

by Tammy Moore -
Number of replies: 0

If it is a very large course with a large enrollment, increase your max_allowed_packets. You can even increase this in PHPMyAdmin in the SQL query window. 

You can find what it currently is with the query:

show variables like 'max_allowed_packet'

The default is usually 268435456 which is 268 mb. that is too small for a busy site with large courses and lots of quizzes. Try increasing it using ...

set global max_allowed_packet=563870912

and see how that does. if you still cannot get in, go up higher.

We have just had to bump ours up this week when we had the grade book time out after trying to unlock a grade over-ride in a course with around 700 students and 160 plus quizzes. I changed ours to 888888888 and immediately the quizzes and grade book became available again. I guess I was in an 8 mood today. This weekend when it is less crazy, I plan to go in with more attention and fine tune it and get SSH in to the config file to make it permanent. When you set it in PHPMyAdmin, it is not permanent. The next server restart will drop it down to the original setting. But, for a quick visit to PHPMyAdmin just to see if that will do the trick it is a great diagnostic tool.