WeBWorK Main Forum

courses with set_id~s over 100 characters

courses with set_id~s over 100 characters

by Alex Jordan -
Number of replies: 1

Following an upgrade to 2.20, my server has a few courses where the Upgrade Courses page indicates that a few database set_id fields need:

Change type of field from TINYBLOB to VARCHAR(100) when upgrading

But if I try to make that upgrade, the message back is:

Failed to changed type of column 'set_id' from table 'problem'. It is recommended that you delete this course and restore it from an archive.

Actually it seems that these courses have at least one set whose id is over 100 characters long. Deleting/restoring the course won't change that. What should I do? One of the courses is a new course that was unarchived from an old course, so I can rename the sets to something shorter (by exporting them, renaming them, and then importing them).

However the other course where this is happening is a course that is active with student data from before the upgrade. Should I do anything? Or just ignore the column type mismatch?

In reply to Alex Jordan

courses with set_id~s over 100 characters

by Glenn Rice -

The easiest thing to do is just to skip the column type change. If it was working before, it should still work. Restore the course archive and don't select the option to change the column type when you upgrade. This is why that is an option.