Replaced Column in Review Assignment

Software Support
1

Hi,
What happened in OJS 3.2.0.3!
I figure that the Replaced column in the review_assignment table removed during the update process.
and I couldn’t find which command or function did it?

I need this column and my data lost after upgrade to this version

2

Hi @mbabaei,

Is this a column you added? We currently use ADODB to manage the database schema, and during upgrade it applies the schema files (see the <schema> elements in dbscripts/xml/upgrade.xml`) to the current database. If it sees a column in the database that’s not in the descriptor, it drops it. If you’re adding columns to the database, make sure you also add them to the descriptor!

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like
3

Yes your right, I know that but I want to know that why replaced column deleted from Review_Assignment table?!

I can’t find anything in schema about this problem !

Thanks in advanced

4

Hi @mbabaei,

What version did you upgrade from?

Regards,
Alec Smecher
Public Knowledge Project Team

5

My old version: 3.1.2.4
And I upgrade my system to ojs-3.2.1-1

6

Hi @mbabaei,

The replaced column existed in the review_assignments table for OJS 2.x to 3.1.x, but was removed with this set of changes in 3.2.0. It has never been used in 3.x, but would have hung around with any data that was upgraded from 2.x. Were you using that column for your own purposes?

Regards,
Alec Smecher
Public Knowledge Project Team

7

@asmecher, Yes i used it for specific purpose.