I've just upgraded to Moodle 2.0 and while everything else seems to be working, I can't view any assignment submissions, or previous quiz results.
I've turned DEVELOPER DEBUGGING on and I then see the SQL error that is occuring:
Debug info: BIGINT UNSIGNED value is out of range in '(`db`.`s`.`timemarked` - `db`.`s`.`timemodified`)'
I think it has to do with the fact that I had to convert collation within the tables of my DB (as per this thread).
*** OK, I appear to have partially solved the problem, but I'm not sure if it's a 'dodgy' fix or not. I followed the instructions on this thread and added the sql_mode = 'NO_UNSIGNED_SUBTRACTION' to the my.ini file and it seems to work. Is this a dodgy fix or a bug I should submit? I'm not sure, but I'm just pleased that I can now see the results / submissions!
I still get an error when trying to view SOME quiz results (some quizzes work!?!??):
BIGINT UNSIGNED value is out of range in '(`db`.`qa`.`timefinish` - `db`.`qa`.`timestart`)'
SELECT CONCAT(u.id, '#', COALESCE(qa.attempt, '0')) AS concattedid, qa.uniqueid, qa.id AS attempt, u.id AS userid, u.idnumber, u.firstname, u.lastname, u.institution, u.department, u.email, u.picture, u.imagealt, qa.sumgrades, qa.timefinish, qa.timestart, qa.timefinish - qa.timestart AS duration, qa.layout FROM mdl_user u LEFT JOIN mdl_quiz_attempts qa ON qa.userid = u.id AND qa.quiz = ? WHERE qa.id IS NOT NULL AND qa.preview = 0 ORDER BY concattedid ASC LIMIT 0, 30