Hotpot (plugin)

Hi Robert,

I did your Shopping Dictagloss on Gordon's site and I didn't see an error message at the end - I was just trapped in the exercise with no elegant way out.

You should maybe put a shorter one on his site for him to test.

By the way, there's a place where you hear: "for" but you need to put, I think,  "in" - a two letter word anyway.

As you're creating dictation-like exercises with WebRhubarb you might be intersted in the 2011-09-20-TexToys-modified-source-files.zip I put on the Hot Potatoes users group recently. I can explain exactly what they do - I already have on the users group.

Cheers,

Glenys

Hi Robert,

> INSERT INTO mdl_quizport_responses ( ATTEMPTID, ... ) VALUES ( 544519, ... )

Congratualtions to you and your students for doing over half a million attempts at QuizPort quizzes  - !

> INSERT INTO mdl_quizport_responses ( ATTEMPTID, ... CORRECT )
> VALUES ( 544519, ... '660,84,24411,2556,6524,283,337,1189,876,37260,
> 177,3080,37242,2874,169,909,594,1009,8329,664,37261,874,342,18494,
> 375,37262,180,3021,7560,648,341,50,221,37263,619,3059,347,22161,
> 47,37264,5375,250,36076,178,698,36,3150,8947,37265,15807,37268,
> 373,657,6,6531,1008,4977,1763,30,968,2704' )

What is happening here is that each word in the correct answer is assigned an id from the "strings" table and then this list of ids is stored in the "correct" field of the record in the "attempts" table. The "correct" field can be up to 256 chars long, but because the ids in your database are now large, combined with the fact that rhubarb quizzes require a lot of ids means that all those ids are now longer than the allowed length of the "correct" field.

When we do the same activity on my server, the ids are all much shorter and therefore there is enough room for this information and we don't get the error on my server.

I don't really want to make this field in the database longer, because at the moment the type of this field in the database is VARCHAR(256) whch is has a variable length and is quite an efficient way to store text fields that are usually short but sometimes long. To make the field longer, we would have to make it a fixed length TEXT field, but this would mean we have to allocate space for the field even if it is not used - and usually this field only contains a handful of ids.

I think a better solution would be to rethink how to store Rhubarb results. For the moment, I will simply cut off the list of ids if it is going to be longer than 256 chars. This will mean that you lose some informationabout which words were entered. In the longer term I will implement a solution which allows the all the words to be stored.

I will let you know when you can download a version of the QuizPort module which can handle your situation.

best regards
Gordon