ojs3.0.2 is master journal .
i’m export 1 issue

install new ojs3.0.2 and create journal and add user “learnjournal” (journal manager).
use Native XML plugins for import issue

complete (no php error)

issue show 0 item

submission table have data

In 5 issues have 3 issue are complete and 2 issue are same problem
file 7.6 mb for test dropbox
thank you
Hi @OhnO395,
Did you check in the “Future Issues” tab to see whether there are duplicates of that issue?
Regards,
Alec Smecher
Public Knowledge Project Team
Future issues are anything.

All submission show in Unassigned state “Copyediting”.

If i’m manual add to issue, it warning.

it show in issue.

how to fix it?
i found problem in table published_submissions in ojs3.0.2 site to export.

date_published = NULL
i’m migrate 2.3.6 → 2.4.8.2 -->3.0.2
Hi @OhnO395,
Can you confirm that just correcting the date_published
resolved the issue? Off the top of my head, I don’t think we’re depending on date_published
that way.
Regards,
Alec Smecher
Public Knowledge Project Team
-
I migrated ojs2.3.6 → ojs2.4.8.2 → ojs3.0.2. ojs3.0.2 is the master for export.
I found in a table “published_submissions” column date_published = NULL ( this is the problem )
-
If import this issue, it shows 0 item

and there’s no any new data in the table "published_submissions"
-
I exported issue and diff it with issue to add date_published = 2016-11-25 00:00:00 (not null)
this result

-
If i use importing file which have date_published, as shown

and it has new data in the table "published_submissions"
And I am sure it is the real problem.
Regards,
sarathoon
Hi @OhnO395,
Thanks – I found an already resolved issue describing this:
https://github.com/pkp/pkp-lib/issues/2516
Regards,
Alec Smecher
Public Knowledge Project Team
posible option
- fix db by submission date published = published date published
UPDATE published_submissions AS U1, issues AS U2 SET U1.date_published = U2.date_published WHERE U2.issue_id = U1.issue_id and U1.date_published is null
or fast sql but it syntax error i can’t fix it T_T
update published_submissions SET published_submissions.date_published=issues.date_published from published_submissions inner join issues on published_submissions.issue_id=issues.issue_id where published_submissions.date_published is NULL
- fix to XML file (add date_published=“DATE”)