Thanks for the guidance so far.
I am revisiting the issue now, and I am now getting a different error message when clicking upgrade on a module. It is:
Exception thrown by module ps_checkout on upgrade. Class Core_Foundation_Database_EntityManager does not exist
.png.022b5452a8f28f552bc9430097a16da2.png)