It wouldn't be a big deal, except when the corrupt account is there and I assign a new problem set to all users, it only assigns the set to some users (the ones who were in my original CSV file, and not the ones I've added since then). If I delete the corrupt account, then I can assign to everyone properly, but I'd rather not have to delete him over and over.
Can you tell me how to delete the student's account some other way (i.e. without using the Classlist Editor)? I am appending an example of an error message I got when trying to access the student's records. Looks like he's been partially deleted, partially not.
Thanks for your help,
An error occured while processing your request. For help, please send mail to this site's webmaster (webmaster@localhost), including all of the following information as well as what what you were doing when the error occured.
Tue Aug 17 16:22:34 2010
record for user FLAMURKAS.09ï¿½ not found at /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Instructor/Stats.pm line 144.
The information below can help locate the source of the problem.
in WeBWorK::ContentGenerator::Instructor::Stats::body called at line 152 of /opt/webwork/webwork2/lib/WeBWorK/Template.pm
in WeBWorK::Template::template called at line 490 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm
in WeBWorK::ContentGenerator::content called at line 194 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm
in WeBWorK::ContentGenerator::go called at line 353 of /opt/webwork/webwork2/lib/WeBWorK.pm
When I downloaded a class-list file in Excel format (technically it was in CSV format) generated by Blackboard, I did a manipulation to create the .lst format required by WeBWorK. When I imported it, there were strange characters in between all characters of the name.
When I double checked the original file, I discovered that it was in what is called "UTF-16" encoding. WeBWorK is expecting UTF-8 encoding. My text editor was able to read either type and so I wasn't expecting the outcome. If I converted the file to UTF-8 first and then imported to WeBWorK, everything was fine.
When I tried to delete the bad students, they appear to disappear from the classlist. But the next time I query the database, they seem to reappear. I think that what is happening is that the database is purged, but the reference table (the keys for the database) are not correctly cleaned when the text uses the wrong encoding. If I try to edit one of the students, it says they are not there.
For me, since this was a test class and not production, I just deleted the class and started over. I don't know how to access the database directly.
D. Brian Walton
James Madison University
Have you tried to delete the user from inside the database? The easiest way to do this is probably to install phpmyadmin then access the webwork database from there, The user will be in the table called
where classname is the name of the class the student is enrolled in.