Moodle QA

A 'View x submitted assignments' link informs teachers of the number of assignments submitted to-date

Details

Description

1. Login as student1 and submit a file for a Upload a single file assignment.
2. Login as a teacher and check that a 'View 1 submitted assignments' link is displayed on the assignment page and also the assignments index page.
3. Login as student2 and submit a file for a Upload a single file assignment.
4. Login as a teacher and check that the link now states 'View 2 submitted assignments'.

Issue Links

Activity

Hide
Chad Outten added a comment -

test failed on moodle preview 4 build 201000905. error dialogue reads: error reading from database. developer debugging info as follows:

Debug info: Unknown column 'Array' in 'where clause'
SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email,
s.id AS submissionid, s.grade, s.submissioncomment,
s.timemodified, s.timemarked,
COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0) AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid
AND s.assignment = 1 WHERE Array AND u.id IN (4) ORDER BY lastname ASC
[array (
)]
Stack trace:
line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 732 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1289 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 632 of /mod/assignment/lib.php: call to assignment_base->display_submissions()
line 56 of /mod/assignment/submissions.php: call to assignment_base->submissions()

Show
Chad Outten added a comment - test failed on moodle preview 4 build 201000905. error dialogue reads: error reading from database. developer debugging info as follows: Debug info: Unknown column 'Array' in 'where clause' SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email, s.id AS submissionid, s.grade, s.submissioncomment, s.timemodified, s.timemarked, COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0) AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid AND s.assignment = 1 WHERE Array AND u.id IN (4) ORDER BY lastname ASC [array ( )] Stack trace: line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown line 732 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1289 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql() line 632 of /mod/assignment/lib.php: call to assignment_base->display_submissions() line 56 of /mod/assignment/submissions.php: call to assignment_base->submissions()
Hide
Helen Foster added a comment -

Chad, thanks for your comment.

I've just tried and failed to reproduce the problem you describe. Please could you state on which page you obtained the error and see http://docs.moodle.org/en/QA_testing for what to when tests fail.

Show
Helen Foster added a comment - Chad, thanks for your comment. I've just tried and failed to reproduce the problem you describe. Please could you state on which page you obtained the error and see http://docs.moodle.org/en/QA_testing for what to when tests fail.
Hide
Teresa Gibbison added a comment -

Hey Chad
I couldn't reproduce this either - everything looks fine on my Moodle 2.0 Preview 4+ (Build: 20100906) build.

Show
Teresa Gibbison added a comment - Hey Chad I couldn't reproduce this either - everything looks fine on my Moodle 2.0 Preview 4+ (Build: 20100906) build.
Hide
Chad Outten added a comment -

Test fails at step 2 when teacher clicks the 'View n submitted assignments' at url something like http://moodlesite.com/mod/assignment/submissions.php?id=2.

I receive same error dialogue on local MAMP test install and also an instance that is 'live' to the web. i note that same error received for all (4) assignment types. fyi - bug issue MDL-24106 added to tracker.

note: test does pass on public site at http://qa.moodle.net.

Show
Chad Outten added a comment - Test fails at step 2 when teacher clicks the 'View n submitted assignments' at url something like http://moodlesite.com/mod/assignment/submissions.php?id=2. I receive same error dialogue on local MAMP test install and also an instance that is 'live' to the web. i note that same error received for all (4) assignment types. fyi - bug issue MDL-24106 added to tracker. note: test does pass on public site at http://qa.moodle.net.
Hide
Helen Foster added a comment -

Chad, thanks for your feedback. Just linking the bug report with this QA test.

Show
Helen Foster added a comment - Chad, thanks for your feedback. Just linking the bug report with this QA test.
Hide
Aparup Banerjee added a comment -

I've commented on the bug. This may have been fixed already, resetting.

Show
Aparup Banerjee added a comment - I've commented on the bug. This may have been fixed already, resetting.
Hide
Ashley Blakeston added a comment -

Seen the comments on the bug page and it seems the issues have been fixed for that user, I've just run the test and had no issues, so think it's safe to say that this is passed

Show
Ashley Blakeston added a comment - Seen the comments on the bug page and it seems the issues have been fixed for that user, I've just run the test and had no issues, so think it's safe to say that this is passed

People

Dates

  • Created:
    Updated:
    Resolved: