How do I unpublish/publish an article from the database?

[simgiallorosso]

i use ojs pkp 3.4.0-8

Good morning. I’m having a problem with some very old DOIs, inserted manually, without using the Medra plugin, many years ago.
The DOIs are visible on the article’s web page, but they don’t appear in the DOI management section of the administration.

To make them appear, I have to unpublish and republish all the old articles one by one.

Once this is done, the DOI appears in the DOI management section, and I can sync and register again.

I have to do this whole operation to have the XML files updated on Medra and CrossRef for the similarity check.

The question is:

In the database, which table, field, and value do I need to change to unpublish and republish an article?

I wanted to see if this inserts the DOI.

Do you have any other solutions to the problem?

Thanks everyone.

[rcgillis]

Hi @simgiallorosso,

Could you please note which version of OJS you’re using (e.g. 3.4.0-7)? Please include this information in your post, as it will assist others in making accurate suggestions to remedy issues.

Best regards,

Roger
PKP Team

[simgiallorosso]

and the value of unpublish?

thanks so much

[deanting]

Hi @simgiallorosso you can set status value in table “publications“ to control whether an article is published:
1.get the submission id;
2.SELECT * FROM publications WHERE publication_id=(select current_publication_id from submissions where submission_id=160);
3.set publications table row,status=5 is published,status=3 is unpublished

[simgiallorosso]

solved!

In the submission table, the stage_id field is set to 1.

It was set to 4; now the DOIs appear.