URGENT HELP NEEDED--recent error with quiz module

URGENT HELP NEEDED--recent error with quiz module

by Mike Finney -
Number of replies: 9
I am running 1.7. Within the past couple of weeks the quiz module has started with this error message:

Could not insert entry in question_sessions.

So I ran a debug and it says that the table has crashed and repair is needed. I run the repair in MySql and it says the table is fine. At a loss right now on what to do... any suggestions?

Thanks. I am attaching a screenshot of the issue...
Attachment image001.jpg
Average of ratings: -
In reply to Mike Finney

Re: URGENT HELP NEEDED--recent error with quiz module

by Matt Campbell -
Just off the top of my head - are you able to add new courses and content? Have you checked the amount of storage space available?

Thanks,
Matt
In reply to Mike Finney

Re: URGENT HELP NEEDED--recent error with quiz module

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Can you try going to Admin -> Server -> Debugging and turning on debug messages to see if that generates a more specific and helpful error message?
In reply to Tim Hunt

Re: URGENT HELP NEEDED--recent error with quiz module

by Mike Finney -
Initially, when I ran the debug, I got this message:

mdle_question_sessions has crashed and may need to be repaired.

Now when I run debug, I get:

XML Parsing Error: mismatched tag. Expected: </form>.
Location: http://clevelandemstraining.org/mod/quiz/attempt.php?q=21
Line Number 195, Column 3:

</div>
--^

Don't know if this helps.

MIke
In reply to Mike Finney

Re: URGENT HELP NEEDED--recent error with quiz module

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
The XML error is because you set developer debug, which is super-picky. That is not the real problem. I am sorry, I should have told you to use DEBUG_ALL before.

The initial error looks like the real cause, but I am not a MySQL expert.
In reply to Tim Hunt

Re: URGENT HELP NEEDED--recent error with quiz module

by Mike Finney -
I ran it with just DEBUG_ALL... here is the screenshot from one of the quizzes. It is doing the same for all....


Attachment cpss2.JPG
In reply to Mike Finney

Re: URGENT HELP NEEDED--recent error with quiz module

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
In reply to Howard Miller

Re: URGENT HELP NEEDED--recent error with quiz module

by Mike Finney -
Ran that... but still get the error message. Does that suggest the table is not repairable?
In reply to Howard Miller

Re: URGENT HELP NEEDED--recent error with quiz module

by Mike Finney -
It sounds like I am going to need to rebuild the table... any suggestions on an easy way to do this?

In reply to Mike Finney

Re: URGENT HELP NEEDED--recent error with quiz module

by Peter Kupfer -
I think I am having the same problem. Mike, did you ever resolve this?