OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



DB Error: c.copyedit_revision in field list

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: c.copyedit_revision in field list

Postby habeas_corpse » Tue Sep 29, 2009 7:48 am

Hello.
it's my first topic here.

in my instalation show this Message "DB Error: c.copyedit_revision in field list"
what is this?

sorry for my bad english...
habeas_corpse
 
Posts: 5
Joined: Tue Sep 29, 2009 7:09 am

Re: DB Error: c.copyedit_revision in field list

Postby jmacgreg » Wed Sep 30, 2009 1:18 pm

Hi habeas_corpse,

Where does that error show exactly -- which page are you on, and what are you trying to do? Also, which version of OJS are you using?

Cheers,
James
jmacgreg
 
Posts: 4162
Joined: Tue Feb 14, 2006 10:50 am

Re: DB Error: c.copyedit_revision in field list

Postby habeas_corpse » Thu Oct 01, 2009 12:49 pm

my ojs version is OJS 2.2.2

this error message show when i click in /editor/submissions/submissionsInReview

thank you!
habeas_corpse
 
Posts: 5
Joined: Tue Sep 29, 2009 7:09 am

Re: DB Error: c.copyedit_revision in field list

Postby iltonbarbosa » Mon Feb 22, 2010 12:27 pm

Hi,
I'm have this problem too. What's the solution?
iltonbarbosa
 
Posts: 2
Joined: Mon Feb 22, 2010 10:53 am

Re: DB Error: c.copyedit_revision in field list

Postby jmacgreg » Thu Feb 25, 2010 12:06 pm

Hi iltonbarbosa (& apologies to habeas_corpse for dropping the thread),

I can't replicate this at all. Can you confirm that you are getting this error on the same page? Where does it appear? Do you see only an otherwise blank page and this error, or does it appear within the page? And can you give us some detail on your OJS, server and MySQL versions?

Cheers,
James
jmacgreg
 
Posts: 4162
Joined: Tue Feb 14, 2006 10:50 am

Re: DB Error: c.copyedit_revision in field list

Postby nevermind182004 » Wed Mar 10, 2010 3:29 am

hello, i got the same problem too specifically on Editors Role(..editor/submissions/submissionsArchives). After upgrading OJS 2.2.2 to 2.2.4, when I edit on some topic in the Journal Articles, i also encounter this error.. This appear on a white blank page and the error message. Any ideas? :(

DB Error: Unknown column 'c.copyedit_revision' in 'field list'

Apache: 2.2.6
PHP Version: 5.2.5
MySQL Version: 5.0.45
nevermind182004
 
Posts: 86
Joined: Mon Apr 20, 2009 6:02 pm

Re: DB Error: c.copyedit_revision in field list

Postby mcrider » Tue Mar 16, 2010 10:07 am

Hi folks,

The column in question does exist in OJS 2.2.2 and above, so you are likely experiencing a faulty upgrade process. If its too late to redo the upgrade process, You should be able to get away with adding the column to the copyed_assignments table (e.g. run this SQL script):
Code: Select all
ALTER TABLE copyed_assignments ADD COLUMN copyedit_revision BIGINT(20)


Cheers,
Matt
mcrider
 
Posts: 952
Joined: Mon May 05, 2008 10:29 am
Location: Vancouver, BC

Re: DB Error: c.copyedit_revision in field list

Postby nevermind182004 » Tue Mar 16, 2010 7:38 pm

Hey! thanks Matt. works fine now :)
nevermind182004
 
Posts: 86
Joined: Mon Apr 20, 2009 6:02 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 1 guest