/node//results caused PDOException:

PDOException: SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '("elms"."qnrs"."time_end" - "elms"."qnrs"."time_start")': SELECT u.name, qnrs.uid, qnrs.result_id, qnrs.score, qnrs.is_evaluated AS evaluated, qnrs.time_start as started, qnrs.time_end as finished, qnp.pass_rate, qnrs.time_end - qnrs.time_start as duration FROM {quiz_node_results} qnrs LEFT JOIN {users} u ON u.uid = qnrs.uid LEFT JOIN {quiz_node_properties} qnp ON qnrs.vid = qnp.vid WHERE qnrs.nid = :quiz_nid ; Array ( [:quiz_nid] => 19 ) in _quiz_results_mr_data_provider() (line 2055 of /***/sites/all/modules/quiz/quiz.admin.inc).

Comments

falcon’s picture

falcon CreditAttribution: falcon commented
Priority: Normal » Minor

Does anyone else experience this problem?

pgrond’s picture

pgrond CreditAttribution: pgrond commented
Priority: Minor » Normal

Yep, I have the same error.

pgrond’s picture

pgrond CreditAttribution: pgrond commented

Some more info. It happens when changing the options in the "Special filters".

paalj’s picture

paalj CreditAttribution: paalj commented

I am not able to reproduce this one. There must be something funny with the values in the quiz_node_results' time_start and/or time_end columns.

If anyone is able to reproduce it, could you do a query on the quiz_node_results table, and dump the relevant rows here?

greenwork’s picture

greenwork CreditAttribution: greenwork commented

It's in the 7.5x dev as well. I changed both options on the results filter (one after the other) finishing with the option for including quizes that are not finished. Can't get to the results page to change them back now on the account.

Ajax error popup:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /system/ajax
StatusText: error
ResponseText:

greenwork’s picture

greenwork CreditAttribution: greenwork commented

Steps to reproduce:

  1. Admin/creator Account open with results permission
  2. New browser of different type (any other account - anon or logged in) half finish the quiz
  3. return to first browser with Do not show quizzes in progress unchecked will result in error page unable to retrieve results
  4. return to other browser half finished and finish the quiz
  5. Return to first browser and view quiz results will now work.

Let me know if you can reproduce. Questions in order:

Quiz directions
True/false question
Multiple choice question
Matching
Short answer question

paalj’s picture

paalj CreditAttribution: paalj commented

I have performed the steps outlined, but unfortunately I'm not able to reproduce this...

pingwin4eg’s picture

pingwin4eg
Location Zaporizhia 🇺🇦
CreditAttribution: pingwin4eg commented
Version: 7.x-4.0-alpha9 » 7.x-4.0-alpha11

i confirm the problem in alpha11.
values of `time_end` and `time_start` are nothing special.
BUT SELECT `time_end` - `time_start` FROM `quiz_node_results` WHERE `time_end` = 0 (or ANY separate row with `time_end` = 0) results in #1690 - BIGINT UNSIGNED value is out of range.

the SOLUTION is to remove 'UNSIGNED' attribute from `time_end` and `time_start` columns in MySQL table structure.

Sivaji_Ganesh_Jojodae’s picture

Sivaji_Ganesh_Jojodae CreditAttribution: Sivaji_Ganesh_Jojodae commented
Version: 7.x-4.0-alpha11 » 7.x-4.x-dev
Status: Active » Fixed

I was able to reproduce this issue in fresh drupal 7 and quiz (recent dev) install site. Removing unsigned attribute did the trick. Added hook_update_N() to fix it.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

manu56’s picture

manu56 CreditAttribution: manu56 commented

Hi,
I'm getting the same error in 7.x-4.0-alpha12 release as well. Can you guide me on how to use the hook_update_N().

Thanks

rickiellen’s picture

rickiellen CreditAttribution: rickiellen commented
Status: Closed (fixed) » Active

I'm also getting this error in 7.x-4.0-alpha12, possibly due to a quiz indicated as being "In Progress" when I look at the user/%uid/myresults page.

Can someone explain the hook_update_N() fix, please?

greenwork’s picture

greenwork CreditAttribution: greenwork commented

He added the fix to the dev version I believe. That usually is a good choice to try the fix first

  • Commit 07fe741 on 7.x-4.x, 7.x-5.x by sivaji: 
    Fix #1788894 - Changed the attribute of time_start and time_end fields...

  • Commit 07fe741 on 7.x-4.x, 7.x-5.x, quiz-pages by sivaji: 
    Fix #1788894 - Changed the attribute of time_start and time_end fields...

  • Commit 07fe741 on 7.x-4.x, 7.x-5.x, quiz-pages, 2269219 by sivaji: 
    Fix #1788894 - Changed the attribute of time_start and time_end fields...

  • Commit 07fe741 on 7.x-4.x, 7.x-5.x, 2269219 by sivaji: 
    Fix #1788894 - Changed the attribute of time_start and time_end fields...

  • sivaji committed 07fe741 on 7.x-6.x 
    Fix #1788894 - Changed the attribute of time_start and time_end fields...
fuzzy76’s picture

fuzzy76 CreditAttribution: fuzzy76 commented
Issue summary: View changes

Should this be closed since it is fixed?

djdevin’s picture

djdevin
Location Philadelphia
CreditAttribution: djdevin at Cadmium commented
Status: Active » Closed (outdated)

Yes. Thanks!