Assignment attempts disappearing-moodle

Assignment attempts disappearing when login as administrator.
The the problem is the php code
To solve the problem about Assignment attempts disappearing u should find the folder mod on moodle installation. My mod folder was on C:\xampp\htdocs\moodle\mod\assignment.

and find lib.php

this screen shoot can fast u to find a lib.php

open lib.php with text editor like Notepad and find and bold the

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

than paste with this code

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

hope the assign attempts disappearing was solve.

more on Assignment attempts disappearing moodle forum

i'am using XAMPP server and using moodle as localhost