I've been working on setting up a quiz, using the the jQuery countdown integration. Things were going well, but now my admin user (user 1) receives the below error when attempting to go to the "Take" tab of the quiz. Other users can take it. I'm guessing I must have started the quiz then timed out? Any ideas how to resolve?

PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'time_left' at row 1: UPDATE {quiz_node_results} SET time_left=:db_update_placeholder_0 WHERE (result_id = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => -1692267 [:db_condition_placeholder_0] => 2 ) in quiz_take_quiz() (line 2020 ...

Comments

nels’s picture

nels commented

I had the same issue. After I deleted all the "results" for the administrator account (example.com/node/[quiz-nid]/results), the admin/uid1 could take the quiz again.

h.arefmanesh’s picture

h.arefmanesh commented

I had the same issue too.
I enabled jQuery countdown integration and it was working properly. but when I add another quiz this problem appeared.

jukka792’s picture

jukka792 commented

I also have the same issue, but it appears also for anonymous users, so quiz is not usable at all.

dansboy’s picture

dansboy commented

The same issue.

sivaji_ganesh_jojodae’s picture

sivaji_ganesh_jojodae commented
Status: Active » Fixed

Fixed http://hub.knackforge.com/projects/quiz-support/repository/revisions/5d0...

Status: Fixed » Closed (fixed)

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

selvamkf’s picture

selvamkf commented

The time_left column is now smallint(6) which should be converted to MEDIUMINT to support larger seconds.

  • Commit 5d0dedb on 7.x-4.x, 7.x-5.x by sivaji: 
    Issue #1770302 by michellezeedru: Fixed PDOException Out of range value...

  • Commit 5d0dedb on 7.x-4.x, 7.x-5.x, quiz-pages by sivaji: 
    Issue #1770302 by michellezeedru: Fixed PDOException Out of range value...

  • Commit 5d0dedb on 7.x-4.x, 7.x-5.x, quiz-pages, 2269219 by sivaji: 
    Issue #1770302 by michellezeedru: Fixed PDOException Out of range value...

  • Commit 5d0dedb on 7.x-4.x, 7.x-5.x, 2269219 by sivaji: 
    Issue #1770302 by michellezeedru: Fixed PDOException Out of range value...