WeBWorK Main Forum

Issues with Library Browser

Issues with Library Browser

by Darin Engel -
Number of replies: 4

We recently upgraded to 2.19 for the spring semester. All our past and current WW courses are unable to access the Library Browser. When we open in each course we get : 

  • 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 925.

I went into Upgrade Courses and upgraded all the databases. I tried several commands in the /opt/webwork/webwork2/bin that chatgpt suggested I run, including this manual .pl script. But it didn't work. Any advice would be great. 


In reply to Darin Engel

Re: Issues with Library Browser

by Glenn Rice -

Have you tried running the bin/OPL-update script?  That looks like it is your problem.  The pgf.libraryroot column is an OPL database column, not a course database column.

In reply to Glenn Rice

Re: Issues with Library Browser

by Darin Engel -

Thanks for the reply. What is the command I should run on the server? Let's say, for instance, I'm a dumb guy who has a vague understanding of this CLI. 

In reply to Darin Engel

Re: Issues with Library Browser

by Glenn Rice -

Assuming that you have done everything in the installation manual at https://webwork.maa.org/wiki/Installation_Manual_for_2.19_on_Ubuntu (including adding /opt/webwork/webwork2/bin to your PATH), then the command is "OPL-update" without the quotes.

If you don't have the path set up, then it is "/opt/webwork/webwork2/bin/OPL-update" again without the quotes..

In reply to Glenn Rice

Re: Issues with Library Browser

by Darin Engel -

There we go, having that ubuntu install guide helped. This webwork upgrade was done by a different tech in my university. I don't think he set up everything 100%. I had to give my self permissions to use "git pull origin" command/the entire webwork-open-problem-library folder. After that I could do that and then properly run OPL-update command. After that the library tab started working for all my classes, Thanks for the help!