I have just upgraded the OJS to 3.1.1.0 and I am no longer able to login to the admin page. The published papers were also not accessible. Following were the errors in the error_log file:
DB Error: Unknown column ‘gossip’ in ‘field list’ ← When I try to log in
DB Error: Unknown column ‘submission_id’ in ‘where clause’ ← When I try to view current paper.
I upgraded the OJS via the softaculous site in the cpanel. I realised that the OJS version in the softaulous is 3.1.1.0 but in the OJS panel itself is still 3.1.0.1. I managed to login in by refreshing the browser. The Submission dashboard seems to be empty when I clicked on it.
This is not solving the problem. I am still seeing the DB error messages. I realized that the submission tab is missing if I log in as an author. As an admin, the submission tab is just empty. Nothing is there.
Do I need to do anything to the existing database after the upgrade?
you login to your server and open config.inc.php file.
Then you modify installed = on to installed =off
Then you open your journal’s homepage in your browser. Follow whatever it says and click “upgrade”. See whether you get a message “successfully upgraded to ojs 3.1.1”
Once the upgrade is done, do not forget to make installed = on again.
I did an upgrade from 3.1.0-1 to 3.1.1, first bydecompressing the tar file, then by moving the my modified files over.
I ran the tool upgrade, and cleared caches.
Still showed that I needed to upgrade, and only the contents list would work - clicking on the article link showed an error of submission_id not found.
I will try again with a new installation, leaving our my modifications.
Hmm, I suspect something happened during the upgrade. I would suggest restoring from backup and trying it again – you should definitely see a “success” message at the end of the upgrade process. If the process apparently stops, but you don’t see the “success” message, then it very likely didn’t finish.
Regards,
Alec Smecher
Public Knowledge Project Team