Upgraded from 2.16 to 2.17 on Ubuntu 20.04 using the instructions at https://webwork.maa.org/wiki/Release_notes_for_WeBWorK_2.17#Upgrade_Instructions.
Most seems to have gone smoothly, but in the very last step, > upgrade_admin_db.pl , executing "./upgrade_admin_db.pl" throws an error:
You need to set the WEBWORK_ROOT environment variable.\n at ./upgrade_admin_db.pl line 20.
BEGIN failed--compilation aborted at ./upgrade_admin_db.pl line 23.
Now it is impossible for anyone to login via the web. Upon attempting to login the error reported is as follows:
Error record identifier
26de56ba-097c-5514-be65-49be364a5211::23b95a0a-174f-11ed-8830-af143d5b2172
Warning messages
It looks like the database is missing a column. You may need to upgrade your course tables. If this is the admin course then you will need to upgrade the admin tables using the upgrade_admin_db.pl script. at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 876.
Error messages
DBD::mysql::st
execute failed: Unknown column 'set_id' in 'field list' at
/opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 881.
Call stack
The following information can help locate the source of the problem.
in WeBWorK::DB::Schema::NewSQL::Std::handle_error called at line 469 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pmin WeBWorK::DB::Schema::NewSQL::Std::_get_fields_where_prepex called at line 437 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pmin WeBWorK::DB::Schema::NewSQL::Std::get_fields_where called at line 497 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pmin WeBWorK::DB::Schema::NewSQL::Std::get_records_where called at line 796 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pmin WeBWorK::DB::Schema::NewSQL::Std::gets called at line 768 of /opt/webwork/webwork2/lib/WeBWorK/DB.pmin WeBWorK::DB::getKeys called at line 763 of /opt/webwork/webwork2/lib/WeBWorK/DB.pmin WeBWorK::DB::getKey called at line 786 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pmin WeBWorK::Authen::check_session called at line 529 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pmin WeBWorK::Authen::verify_normal_user called at line 309 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pmin WeBWorK::Authen::do_verify called at line 206 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pmin WeBWorK::Authen::verify called at line 150 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pmin WeBWorK::Authen::call_next_authen_method called at line 203 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pmin WeBWorK::Authen::verify called at line 306 of /opt/webwork/webwork2/lib/WeBWorK.pmHelp would be most appreciated.