WeBWorK Main Forum

Display Past Answers error

Display Past Answers error

by Teri Christiansen -
Number of replies: 5

Hi,

We are running into the following error message when trying to Display Past Answers in a course using WW 2.19.  The answer table will display the last recorded answer submitted, but no other attempts.  The csv file that it generates also shows the most recent answer only.

When the same problems are copied to another course, the error/warning does not appear.  I've tried checking the course configuration settings and can't find anything that is different - and I can't replicate the error in the second course.  Would anyone have advice on how to diagnose this error or how to correct it?


Warning messages

  • Argument "" isn't numeric in sort at template ContentGenerator/Instructor/ShowAnswers/past-answers-table.html.ep line 9.

In reply to Teri Christiansen

Re: Display Past Answers error

by Danny Glin -

The first thing to check is that the tables for that course have been upgraded for the latest version.  Click on "Upgrade Courses" in the menu of the admin course.  It will tell you if the past answers table for that course needs to be upgraded.

In reply to Danny Glin

Re: Display Past Answers error

by Teri Christiansen -

Thanks - I checked and all the courses on our server show that they are upgraded and OK (except the admin course...could that impact things?)  The course in particular that is showing the error shows this:

MU_STAT_1200 sql_single Database tables ok

The admin course is having an issue upgrading the html_temp directory...I can check with our server manager if we need to do more with that.

In reply to Teri Christiansen

Re: Display Past Answers error

by Glenn Rice -

The html_temp directory should be automatically recreated.  The warning is a bit misleading on that.

In reply to Glenn Rice

Re: Display Past Answers error

by Teri Christiansen -

Thanks.  

Is there a suggestion for something else to look at for this error?  The course in question was created long ago and has been used through several upgrades.  I suspect there might be some old setting that is causing the issue, since I don't have the issue with courses that were created more recently.

In reply to Teri Christiansen

Re: Display Past Answers error

by Glenn Rice -
Settings are most likely not the issue. Most likely this is something with the data in the database or the database table parameters. Have you run the upgrade-database-to-utf8mb4.pl script on the course? That might help. The syntax is "upgrade-database-to-utf8mb4.pl -c courseId". Note that will create a webwork.sql backup file of the entire database. If something goes wrong the script will let you know, and you should immediately restore that backup with "mysqldump webwork2 -u webworkWrite -p < webwork.sql".