[ojs3.0.2] import issue is problem. it can't show item in issue

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

  1. 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 )

  2. If import this issue, it shows 0 item

    and there’s no any new data in the table "published_submissions"

  3. I exported issue and diff it with issue to add date_published = 2016-11-25 00:00:00 (not null)
    this result

  4. 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

thank you very much.

Regards,
sarathoon

posible option

  1. 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

  1. fix to XML file (add date_published=“DATE”)