OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Wrongly set DOI

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.

Wrongly set DOI

Postby Galactico » Wed Dec 11, 2013 9:20 am

Hello,
I have the following problem: two articles of newly created issue of my article have wrongly set DOI number. They don't have the article number, only part of DOI corresponding to journal number. I have no idea how I could correct it. I assume that I can't change it in database, since all DOIs are registered at http://dx.doi.org/. I also can't see any proper option in OJS.
Do you have any idea what I could do to change wrong DOI number so that it would be registered at http://dx.doi.org/ correctly? Thank you in advance!
Galactico
 
Posts: 4
Joined: Wed Dec 11, 2013 9:11 am

Re: Wrongly set DOI

Postby dbd » Thu Jan 16, 2014 12:38 pm

Did you ever find a solution to this. I was thinking it might be able to be edited at the database level of the OJS system?
dbd
 
Posts: 13
Joined: Fri Jul 19, 2013 1:24 pm

Re: Wrongly set DOI

Postby Galactico » Thu Jan 16, 2014 3:43 pm

Hello,
Yes, I have resolved this issue - I was able to change DOI number in database. Luckily, all DOIs had been already registered at http://dx.doi.org/ correctly even if they were showed wrong in OJS.
Galactico
 
Posts: 4
Joined: Wed Dec 11, 2013 9:11 am

Re: Wrongly set DOI

Postby dbd » Thu Jan 16, 2014 4:05 pm

great, that is what I did too which fixed the issue.
dbd
 
Posts: 13
Joined: Fri Jul 19, 2013 1:24 pm

Re: Wrongly set DOI

Postby Kurumor » Thu Jun 12, 2014 3:57 pm

Hello,

Can you please tell me which table to edit in the database?
I am having the same issue and can't find which table to modify.

Thanks in advance and sorry by my poor english
Kurumor
 
Posts: 2
Joined: Thu Jun 12, 2014 3:47 pm

Re: Wrongly set DOI

Postby asmecher » Thu Jun 12, 2014 4:13 pm

Hi Kurumor,

In recent releases of OJS 2.x this should be stored in the article_settings table. Search setting_value for your DOI.

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

Re: Wrongly set DOI

Postby Galactico » Fri Jun 13, 2014 8:37 am

All I had to do is the query like this:
update articles set doi='DOI_AS_STRING' where article_id=ID_NUMBER;
Galactico
 
Posts: 4
Joined: Wed Dec 11, 2013 9:11 am

Re: Wrongly set DOI

Postby asmecher » Fri Jun 13, 2014 9:35 am

Hi Galactico,

That will only work for OJS 2.3.x; for OJS 2.4.x, it's stored in article_settings as described above.

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

Re: Wrongly set DOI

Postby Galactico » Fri Jun 13, 2014 9:37 am

Oh, OK - thank you very much for correction.
Galactico
 
Posts: 4
Joined: Wed Dec 11, 2013 9:11 am

Re: Wrongly set DOI

Postby asmecher » Fri Jun 13, 2014 9:44 am

Hi Galactico,

No worries -- thanks for posting detailed instructions; there are still OJS 2.3.x users who will find them useful.

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

Re: Wrongly set DOI

Postby Kurumor » Tue Jun 17, 2014 5:19 pm

Hello asmecher and galactico,

Thanks from your help!!!

My version of OJS is 2.4.3.0 and DOI information was stored in the article_settings table (setting_value).

I will post my queries. It would be useful for someone else.

1. Query actual information
Code: Select all
mysql> SELECT * from article_settings WHERE setting_name like '%doi%' AND article_id=ID_NUMBER;


2. Update information (there are two rows to modify for each article)
Code: Select all
mysql> UPDATE article_settings SET setting_value='DOI_AS_STRING' WHERE article_id=ID_NUMBER AND setting_name='doiSuffix';
mysql> UPDATE article_settings SET setting_value='PREFIX/DOI_AS_STRING' WHERE article_id=ID_NUMBER AND setting_name='pub-id::doi';


I hope it help and thank you very much!!

Kurumor
Kurumor
 
Posts: 2
Joined: Thu Jun 12, 2014 3:47 pm


Return to OJS Technical Support

Who is online

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