error in moodle 2.1 beta

error in moodle 2.1 beta

Nikita M -
Number of replies: 14

Hi,

when I try to load questions with deferred feedback in moodle 2.1 beta I receive this message:

 

Error writing to database

More information about this error

Debug info: Out of range value for column
'minfraction' at row 1

INSERT INTO mdl_question_attempts
(questionusageid,slot,behaviour,questionid,variant,maxmark,minfraction,flagged,questionsummary,rightanswer,responsesummary,timemodified)
VALUES(?,?,?,?,?,?,?,?,?,?,?,?)

[array (

0 => 8,

1 => 1,

2 => 'deferredfeedback',

3 => '39',

4 => 1,

5 => '1.0000000',

6 => '-0.2500000',

7 => 0,

8 => '

Per copyright
relativamente al software si intende:: un insieme di norme che proteggono
legalmente la proprietà del software; la fase di copia di un software da CD a
disco fisso; un software creato per realizzare copie di altri software; un
dispositivo hardware preposto a realizzare copie di software da CD e DVD',

9 => 'un insieme di
norme che proteggono legalmente la proprietà del software',

10 => NULL,

11 => 1308498189,

)]

Stack trace:

line
396 of \lib\dml\moodle_database.php: dml_write_exception thrown

line
878 of \lib\dml\mysqli_native_moodle_database.php: call to
moodle_database->query_end()

line
920 of \lib\dml\mysqli_native_moodle_database.php: call to
mysqli_native_moodle_database->insert_record_raw()

line
95 of \question\engine\datalib.php: call to
mysqli_native_moodle_database->insert_record()

line
71 of \question\engine\datalib.php: call to
question_engine_data_mapper->insert_question_attempt()

line
93 of \question\engine\lib.php: call to question_engine_data_mapper->insert_questions_usage_by_activity()

line
196 of \mod\quiz\startattempt.php: call to
question_engine::save_questions_usage_by_activity()

how fix this error?

 

Վարկանիշների միջին թիվը. -
In reply to Nikita M

Re: error in moodle 2.1 beta

Tim Hunt -
Core developers Նկարը Documentation writers Նկարը Particularly helpful Moodlers Նկարը Peer reviewers Նկարը Plugin developers Նկարը

It appears I defined that column as unsigned, which is stupid.

Doh!

Filed as MDL-27929.

In reply to Tim Hunt

Re: error in moodle 2.1 beta

Nikita M -

Good Tim.

In timhunt-Moodle-Question-Engine-2-43277d3 it works, but then then you have made some change and it began to give this error.

In reply to Nikita M

Re: error in moodle 2.1 beta

Tim Hunt -
Core developers Նկարը Documentation writers Նկարը Particularly helpful Moodlers Նկարը Peer reviewers Նկարը Plugin developers Նկարը

I don't seem to have a 43277d3 revision anywhere. Weird. Can you describe the version it works in in some other way? Thanks.

In reply to Tim Hunt

Re: error in moodle 2.1 beta

Nikita M -

Is it possible to send you this file in some way?

In reply to Nikita M

Re: error in moodle 2.1 beta

Tim Hunt -
Core developers Նկարը Documentation writers Նկարը Particularly helpful Moodlers Նկարը Peer reviewers Նկարը Plugin developers Նկարը

Attach it to the bug report.

In reply to Tim Hunt

Re: error in moodle 2.1 beta

Nikita M -

Hi Tim,

is it possible to give this issue hight priority. How can I write in my thesis that it is the best LCMS quiz  if it it doesn't work?

Is there some something I can do?

In reply to Nikita M

Re: error in moodle 2.1 beta

Tim Hunt -
Core developers Նկարը Documentation writers Նկարը Particularly helpful Moodlers Նկարը Peer reviewers Նկարը Plugin developers Նկարը

This is on my list for today, I hope.

If you want a quick fix, you can directly edit the table definition (using PHPMyAdmin or similar) to change the question_attempts.minfraction column to remove 'unsigned' from the data type.

In reply to Nikita M

Re: error in moodle 2.1 beta

Jean-Michel Védrine -

Using a BETA version rather than a STABLE one clearly expose to more bugs աչքով եմ անում .

If you need a stable version for your thesis, you better have to  use 2.0 stable or wait for 2.1 release at the end of the month.

In reply to Jean-Michel Védrine

Re: error in moodle 2.1 beta

Tim Hunt -
Core developers Նկարը Documentation writers Նկարը Particularly helpful Moodlers Նկարը Peer reviewers Նկարը Plugin developers Նկարը

No. 2.1 is in a state where it is fine to use for research, and helping to find the bugs is a very useful contribution.

In reply to Nikita M

Re: error in moodle 2.1 beta

Nikita M -

I notice another problem:

when I go to Courses ->"CourseName" -> Participiants

it go back to Home-> Participants

and not to

Home->Courses->"CourseName"-> Participiants

as I would expect