Assignment

For what its worth....

Pino's modification worked for me. Students submitted work, and teachers saw "view 2 submitted assignments". When the clicked on it they saw "Nothing to display".

I made the mods shown above (although I typed it wrong the first time ) and it now works perfectly. Suspect its a MySQL version issue?

Moodle 1.9.10+ (20110125)
MySQL 5.5.8
PHO 5.3.5

Pino, thank you very much

Thanks Pino, that was driving me nuts, worked like a charm

Hello to all:

I experienced the same problem, i'm using moodle 1.9.5

I tried what you suggested, but it didn't work for me.

Any other ideas?

This is driving me crazy!!!!!

I'll thank any help!!!!!!!!!!!!

Great Pino!!!, a lot of problems solved!!!

Works, Pico, you are a genius. Thanks

Thank you Pino! You're a genious ...

As far as I am concerned I just followed your fix and it worked. This really shows how great this Moodle community is.

Thanks!

Thanks Pino for sharing.

thanks a lot

I seem to witness the same symptoms of viewing submitted assignments with result "Nothing to display".  This has been happening for the last few versions of Moodle (v1.9 branch) and the teacher claimed that it started happening this school year (last 2 months).  Moodle version 1.9.14, mysql 4.1.22, php 4.3.9, debug info is as follows:

Unknown column 'status' in 'order clause'

SELECT u.id, u.firstname, u.lastname, u.picture, u.imagealt, s.id AS submissionid, s.grade, s.submissioncomment, s.timemodified, s.timemarked FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid AND s.assignment = 8308 WHERE u.id IN (2202,2102,2096,2121,2112,2196,2109,2110,2111,2097,2095,2106,1962,2094,2103,2099,2101,2104,2108,2098,2105,2100,2113,2107) ORDER BY status ASC

• line 687 of lib/dmllib.php: call to debugging()
• line 967 of lib/dmllib.php: call to get_recordset_sql()
• line 1184 of mod/assignment/lib.php: call to get_records_sql()
• line 524 of mod/assignment/lib.php: call to assignment_upload->display_submissions()
• line 43 of mod/assignment/submissions.php: call to assignment_upload->submissions()

After some searching the initial error seems similar to MDL-29529 although that bug corresponds to Moodle version 2.1.1 (same error however).  Any suggestions?

Pino you are an absolute legend!

I was a problem like that.

I solved it thanks to you.

Thank you very much.

I had started to have this problem, with new assignments (old still appeared). I solved it with the "Pino solution".

Thank you Pino, you're really great....

Hi Pino,

It looks like you came up with a good solution to this problem which I am currently experiencing (version 1.9.4). I'm a newbie with fixing bugs though and I don't know how to implement your fix. Any guidance would be greatly appreciated.

Hi, my name is luz, where did i find the lib.php or mod\ assigment, i have the same problem i could not see the my students list to apply the calification.

Hi, Pinooooo

Please help me, i dont know nothing about postgres or php or sql, how did i find that or how could i fix the assigment dissaper problem.

Please help me

Pino... You are the best...!!!!

Thanks a lot... my problem was causing by the MySQL upgrade... but... now, with the line changed in lib.php all work's fine...

Thanks again..:!!!

Perfecto, ahota todo va fino. Gracias

Thank you, Pino.
I actually had to modify two lines of code in the referenced directory.  One line at 842, and the other line at 1171.

R. Russell Williams

Dear Pino,

Thanks a lot for perfect solution.

I tried doing all, finally went to cpanel of  my website and edited lib.php as per your instructions and .... wow.. it works!!!

I suggest all to adopt this simple solution.

Thanks n Regards,

Narayan Solanke
INDIA

Me habia vuelto un poco loco, si eres de los que les pasa lo mismo. Lo que debes hacer es:

1)Primero antes que nada, generate una copia de respaldo del lib.php, si algo sale mal, el que va pagar los paltos rotos serás tu con desveladas arreglando el problema.

2)Borrar la siguiente linea que muestro en rojo (ojo: búscala dos veces, pues aparaece en dos ocasiones en ese archivo) en la siguiente ruta /mod/assignment/lib.php

COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0) AS status ';

Y reemplázalas por esta:

COALESCE(SIGN(CAST(s.timemarked as SIGNED) + SIGN(CAST(s.timemarked as SIGNED) - CAST(s.timemodified as SIGNED))), 0) AS status ';

BINGO! .... a dormir se ha dicho, ya debe estar listo jeje

Thank you very much Pino Calambrogio for your help .... let´s sleep zzzz

Thank you, Pino!  The Moodle community is awesome!

Gracias 

Eres lo mas grande. estimado.

gracias por compartir esta solución.

+1000000

Thank you very much Pino. Muchas gracias Pino. You are wonderful! It is working. I am smiling again.

Jesus!!!

Thanks a lot, this was my problem and your answer help me.