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