So I ran the script but got this when I logged in to any courses

WeBWorK error

An error occured while processing your request.

For help, please send mail to this site's webmaster, including all of the following information as well as what what you were doing when the error occured.

Error record identifier

dd744e16-60e4-540d-9d19-ae3ad5bb480e::ab4c47e4-4c20-11ee-a0e9-f4d2ebcc505f

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/data/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 881.

Context

Re: logging as admin to a course - upgrade_admin_db.pl

by Glenn Rice - Tuesday, 5 September 2023, 3:49 PM

You also need to upgrade courses from the admin course.

Re: logging as admin to a course - upgrade_admin_db.pl

by L Ng - Wednesday, 6 September 2023, 2:05 AM

thank you Glen.

The weird thing is that I can never get the admin course to upgrade

the others are fine

upgrade admin course

Re: logging as admin to a course - upgrade_admin_db.pl

by Glenn Rice - Wednesday, 6 September 2023, 6:55 AM

Many directory issues are not repaired by the upgrade, and need to be manually fixed. When you do the upgrade in the browser UI it should give you more information on what directories have issues. Look at that output, and manually fix them.

Re: logging as admin to a course - upgrade_admin_db.pl

by L Ng - Wednesday, 6 September 2023, 9:54 AM

Hey Glen.

Where can I find out how to fix the issues and what are they "suppose" to be in the directory or other permissions? any docs on them?

thanks

Re: logging as admin to a course - upgrade_admin_db.pl

by Glenn Rice - Wednesday, 6 September 2023, 11:13 AM

If it is a permissions error, then running the commands in https://webwork.maa.org/wiki/Installation_Manual_for_2.18_on_Ubuntu#Set_File_and_Directory_Permissions will fix it.

If there is a missing directory, then use mkdir to create it.

Re: logging as admin to a course - upgrade_admin_db.pl

by L Ng - Wednesday, 6 September 2023, 12:51 PM

Hi Glenn

I figured it out and it was simple. the cause is because I am colourblind :-) the error link is in red.. I am colourblind green and red so it was hard for me to pick out the red amongst the list :-)

now all I have to fix is that check_latex error.. and the sending of email