Hi @asmecher,
With reference to the thread, https://forum.pkp.sfu.ca/t/running-production-ojs-site-with-git-for-dummies-like-me/29705/15
I managed to pack a .tar.gz file and updated my localhost.
Now most of the things runs fine except “Submissions” in my dashboard.
As soon as I login, I am taken to http://localhost/index.php/JLMC/login/signIn with following error message. On refreshing the browser I go to dashboard with blank contents.
DB Error: Unknown column 'gossip' in 'field list'
Where might be the problem and how do I debug it? I don’t see fatal error in my php error_log.
What OJS code/branch do you use and is your DB on exactly the same status? – Recently there were some changes of the “gossip” column in the master branch, that also needed DB upgrade (and also new npm install, npm run…)…
After your above post, I realized that I skipped the npm parts. Then I started from the beginning, ran the npm commands and then packed into tar.gz file. I upgraded my localhost and ran DB upgrade. Now, I got everything working file.
hi i also get the same error everytime i log in to ojs. how do i upgrade the DB and NPM? where do i locate the “gossip” column. i can’t seem to find it in our tables. thanks.
Hmmm… Do you also use git? – If so please see the README on OJS installation https://github.com/pkp/ojs/blob/master/README.md, there you can find the commands for NPM.
If you are using the release package, you should not do anything with NPM – everything is already there, I think.
For DB upgrade see the part “Upgrading the OJS database” in the upgrade README: ojs/UPGRADE at ojs-3_1_0-1 · pkp/ojs · GitHub.
Also, what OJS version are you exactly using?
PHP 5.6 or later with MySQL or PostgreSQL support
A database server: MySQL 4.1 or later OR PostgreSQL 9.1.5 or later
UNIX-like OS recommended (such as Linux, FreeBSD, Solaris, Mac OS X, etc.)
hi @bozana, checked my db and it is up to date. i cannot log-in now. after entering my user name and password, it still says "Unknown column ‘gossip’ in ‘field list’. unlike before when i refresh it or click back i instantly get logged in, it doesn’t happen now though. i stay logged out.