Hi,
OJS 3.1.1-2
I can not associate a DOI with a particular article.
The OJS runs the error:
Errors occurred processing this form[The given DOI suffix is already in use for another published item. Please enter a unique DOI suffix for each item.]
I also could not find the DOI in the database:
select * from submission_settings where setting_name = ‘pub-id :: doi’ and setting_value like ‘%[DOI Prefix / DOI Suffix]%’;
Can someone help me?
Regards,
Tarcisio Pereira.
Hi,
Any news?
Regards,
Tarcisio Pereira
Hi @Tarcisio_Pereira . Can you do this?
mysqldump -u youruser -p ojs > backup.sql
egrep -iR 'Your_DOI_suffix' backup.sql
Do you assign the DOIs only to the articles, or also for other objects like issues or galleys?
What kind/type of suffix do you use?
Best,
Bozana
@juanito I can’t mysqldump because its a postgresql database 
But, I done the equivalent in postgresql dump and nothing was found.
egrep -iR ‘10.1108/INMR-03-2018-0013’ 2019.01.22_00.50.01_revistas.sql
@bozana
So far as I know, we use DOI only in articles.
I double checked the configuration of the doi plugin. Just articles.
I’m searching for ‘10.1108/INMR-03-2018-0013’
Regards.
Tarcisio Pereira
And…
SELECT * FROM submission_settings WHERE setting_value='INMR-03-2018-0013';
?
What are you suffix settings – are you using the custom suffix of a pattern?
Best,
Bozana
Voila!
SELECT * FROM submission_settings WHERE setting_value=‘INMR-03-2018-0013’;
submission_id | locale | setting_name | setting_value | setting_type
---------------±-------±-------------±------------------±-------------
152369 | | doiSuffix | INMR-03-2018-0013 | string
(1 row)
For what this ‘doiSuffix’ is used for? Why it’s not ‘pub-id :: doi’?
@bozana
Individual custom DOI suffix for each published item.
Thank you both!
Tarcisio Pereira
I assume you are using 3.x version. If custom suffix is used, it will be first saved with/as that setting_name. Then, first when you assign the DOI (select the appropriate check-box and save the form), the DOI will be assigned and saved with/as the setting_name pub-id::doi.
When custom suffixes are used, every time you save the suffix/form, it will be checked if there is already a same DOI and a same suffix (because it could be saved/created but not assigned yet). Thus, it seems that you already created/saved such a suffix for another object/article, but haven’t assigned the DOI to that article yet.
Best,
Bozana