[Solved] DB Error: Unknown column 'gossip' in 'field list' [OJS master]

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'

image

Where might be the problem and how do I debug it? I don’t see fatal error in my php error_log.

Hi @anupent

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…)…

Best,
Bozana

1 Like

HI @bozana,

I used master branch and ran DB upgrade as well

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.

Thanks.

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.

Hi @cxl

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?

Best,
Bozana

hi @bozana,

i am using OJS 3.1.1. What version of OJS database is best suited for this?

Will try your instructions. Thank you very much.

Hi @cxl

I am not sure if I understand the question correctly, but:
Here are the OJS 3 requirements listed: https://pkp.sfu.ca/ojs/ojs_download/ i.e:

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.)

Thus, MySQL >= 4.1, for example, should be fine :slight_smile:

Or do I misunderstand the question?

Best,
Bozana

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.