DBD::mysql::st execute failed: Data too long for column 'set_id' at row 1 at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 837.
git diff b40bbff11f16bccd9471459c989dcd4602773768 lib/WeBWorK/DB/Record/PastAnswer.pm
Is there a fix to this? I am getting similar error but not for set_id, it is for "frozen_hash':
DBD::mysql::st execute failed: Data too long for column 'frozen_hash' at row 1 at /app/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 837.
The correct answer also gets marked incorrect.
The problem in my case seems to be that students have to enter a 5x5 or larger matrix. I guess that also gets added to the set_id and other stuff. ADo I have to decrease the matrix size?
That is a different issue. The answers for the problem are not a part of the key for the database row, and so that data is not limited in the same way. There is still a limitation on the data size based on the chosen data type of the last answer column, and there are an increasing number of cases that are indicating that that column needs to have its data type changed to allow for more data.
Do you by chance have MathQuill enabled? That increases the amount of data that is stored in the last answer column.
Achievements are stored in another table, but the same problem can occur there. The frozen_hash column of that table stores local data for an achievement. In particular the still_not_right.at achievement stores all of the last answer data in that column (with some other data). That achievement can easily exceed the VARCHAR(1024) size limits. This is a known issue.