You are viewing the PKP Support Forum | PKP Home Wiki

DB Error: Unknown column 'r2.stage_id' in 'on clause'

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

DB Error: Unknown column 'r2.stage_id' in 'on clause'

Postby vikki » Fri Mar 28, 2014 4:26 pm

Hi everybody!

I have a problem with the system and I would be grateful to you if you could help me solving it.

The OJS installed is version

The system seems to work well but when the editor accesses and clicks on the "submissions on review" he gets the following database error: "DB Error: Unknown column 'r2.stage_id' in 'on clause' "

Thank you in advance for all your help!
Posts: 5
Joined: Mon Mar 24, 2014 5:47 am

Re: DB Error: Unknown column 'r2.stage_id' in 'on clause'

Postby asmecher » Fri Mar 28, 2014 4:56 pm

Hi vikki,

That's a very old version of OJS; before spending too much time debugging, I'd suggest upgrading. It will likely fix the problem.

Alec Smecher
Public Knowledge Project Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: DB Error: Unknown column 'r2.stage_id' in 'on clause'

Postby vikki » Sun Mar 30, 2014 8:27 am

Fine. I have installed the last version. Now I have to export the DB. By the way, I have been looking for information about how to install/use "PHP CLI" or "PHP Command Line". Unfortunately I have not found any information about this. I post a new thrend about this relevant issue. Thanks
Posts: 5
Joined: Mon Mar 24, 2014 5:47 am

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 3 guests