Publishing problem

Hello
We are trying to use OJS and we’re facing such a problem. Be kind and help us as soon as possible because we need the issue have fixed asap - we are University having our Journal.

We install your project according to instruction on your webpage. We create the submission, and when we press Schedule For Publication button, the submission changes it status to Scheduled. And we cannot see it published on the website.

Waiting for your help !

Best Regards,
Liana Arustamyan
ANAU, IT Center

I think you have to publish issue as well

Thank you for your answer
But we have published the issue,
what else can be the reason ?

Is the article assigned to the issue that is published?

Yes, it is assigned.

If it is possible we can give youy access to enter and examine the issue from inside.

An article has scheduled status, like in this example:
screencapture-ojs-3-2-1-test-index-php-psp-workflow-index-208-5-2020-09-16-10_53_24
when the issue isn’t published (it’s listed in the future issues)
screencapture-ojs-3-2-1-test-index-php-psp-manageIssues-2020-09-16-10_57_49

If the article is still scheduled and doesn’t appear on the front-end but the issue is published, do you have access to the database to check how data regarding the publication looks there?

Thanks for yor answer and help.
We have the same problem here. We have the article scheduled and we it doesn’t appear in front. We also have the database permission.
Can I give you further information ?

Best Regards
Liana

You would need to know issue id and publication id.
Probably, the easiest way to identify it is with the browser’s developer tools.
If Google Chrome, right mouse click on the issue in the list - in the dropdown menu choose inspect. There would be an HTML code of the element:

<a href="http://ojs-3.2.1.test/index.php/psp/$$$call$$$/grid/issues/back-issue-grid/edit-issue?issueId=12" id="cell-12-identification-edit-button-5f630cd3ab462" title="Edit" class="pkp_controllers_linkAction pkp_linkaction_edit pkp_linkaction_icon_">Vol. 4 No. 3 (2019): Test Title for the Issue </a>

Inside the link the query part (?issueId=12) points the internal issue id.
The same for the publication - on the publication page, the aria label attribute of the tablist div (menu of the publication with tabs on the left), contains the id of the publication that you can see with dev tools:

<div role="tablist" aria-label="Publication details for version 174" class="pkpTabs__buttons">

Another way can be finding all that by a submission id, which appears in the URL, e.g.:

http://ojs-3.2.1.test/index.php/psp/workflow/index/208/5

208 here is the submission id.
To find current publication id run this query in the database:

SELECT current_publication_id FROM submissions WHERE submission_id = '208'

In my case, it returns 174.
Then, using this id, find issue id:

SELECT setting_value FROM publication_settings WHERE publication_id = '174' AND setting_name = 'issueId'

In the issues table look at the published column status of the issue:

SELECT published FROM issues WHERE issue_id = '12'

1	
		

In the publications table look for the status column of the publication:

SELECT status FROM publications WHERE publication_id = '174'

3