- https://docs.google.com/spreadsheets/d/1cuXyDeH2SimHHcpfxUcym52GNOWCnGQWxg3payeH1hU/edit?usp=sharing
- No results
- No results
So, how should we proceed about this?
Thank you for your attention.
Regards,
Suporte
Hi @Suporte
The review assignments with ids = (0, 1042, 1063, 1066, 1182, 1184, 1197, 1198, 1427) seems to be totally identical. I wonder that there is id = 0… 
However, you would now need to delete all but one. Please take a look in the DB table review_files, which review does it contain:
select * from review_files where review_id IN (0, 1042, 1063, 1066, 1182, 1184, 1197, 1198, 1427)
I hope there is only one there 
All the others you can then remove from the DB table review_assignments:
delete from review_assignments where review_id IN (...)
It seems that there are no other dependencies in your DB – nothing was found in the DB table review_form_responses and notifications.
Then you could try the upgrade anew.
Best,
Bozana
We did it!
We couldn’t have done it without your help!
Thank you a lot!!! 
Regards,
Suporte
Now we trying to upgrade the version OJS 3.1.0-1 to OJS 3.1.1 and we had this error: 
Can you help us again? Thank you.
Regards,
Suporte
Hi @Suporte
Hmmm… Why didn’t you update directly to 3.1.1?
How does your DB table genres look like? – It seems that one of the default genres (that should have key = STYLE) is having key = null…
Best
Bozana
We started the process of upgrading to the new version a few days before you launch the new version in April, it turned out to be unnoticed, we apologize for that.
https://docs.google.com/spreadsheets/d/1elXC407q4HZe2z9jfYh-GQA1rg2bm5QIzX2FTy0jViM/edit?usp=sharing
Which one?
Regards,
Suporte
Hi @Suporte
Hmmm…
It seems like you also have some additional/custom genres…
For the default ones you would need to enter the appropriate key where key = NULL.
Because your genres also seem to be reordered, I am not sure where you would need to put what key :-
Here is how my i.e. default genres entries look like, in the DB table genres:
1 1 0 1 1 0 0 SUBMISSION
2 1 1 1 3 0 1 RESEARCHINSTRUMENT
3 1 2 1 3 0 1 RESEARCHMATERIALS
4 1 3 1 3 0 1 RESEARCHRESULTS
5 1 4 1 3 0 1 TRANSCRIPTS
6 1 5 1 3 0 1 DATAANALYSIS
7 1 6 1 3 0 1 DATASET
8 1 7 1 3 0 1 SOURCETEXTS
9 1 8 1 1 1 1 MULTIMEDIA
10 1 9 1 2 1 0 IMAGE
11 1 10 1 1 1 0 STYLE
12 1 11 1 3 0 1 OTHER
And the English names for them in the UI (Settings > Workflow):
Article Text
Settings
Research Instrument
Settings
Research Materials
Settings
Research Results
Settings
Transcripts
Settings
Data Analysis
Settings
Data Set
Settings
Source Texts
Settings
Multimedia
Settings
Image
Settings
HTML Stylesheet
Settings
Other
So, based on your components IDs (that you see when you want to click on “Edit” action in the UI components listing) and the components names you can enter the correct above listed keys in your DB table.
The keys must be unique!
For the custom components/genres, that you have created: you can either give them a unique key or leave in NULL.
Let me know if you would need any further help…
Best,
Bozana