You are viewing the PKP Support Forum | PKP Home Wiki

Back Issues

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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Back Issues

Postby lawrence » Mon Dec 19, 2005 11:07 am

Hi there,
I want to add "back issues" to a testing journal, whenever I pick "back issue" during creating a new issue, it turns out I get "future issue".

Is there anything that I may have overlooked?

Posts: 10
Joined: Mon Dec 19, 2005 11:00 am
Location: Edmonton, Canada

Postby asmecher » Mon Dec 19, 2005 11:18 am

Hi Lawrence,

When you're creating issues, they'll always show up in "Future Issues" until they're published. If you'd like to import back issues, the Articles & Issues XML import is the recommended method. The process you're using is fine too, but once you're finished, you may have to do a few things manually in the database:
  • For each issue in the issues table, set the date_published field to the date the back-issue was published. (Otherwise the date published is set to the date when you pressed the "Publish Issue" button.)
  • Find the issue_id of your most current issue and execute the following:
    Code: Select all
    UPDATE issues SET current = 0;
    UPDATE issues SET current=1 WHERE issue_id = (use your current issue_id here);

Alec Smecher
Open Journal Systems Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Back Issue - Thank You

Postby lawrence » Mon Dec 19, 2005 11:51 am

Hi Alec,

Thank you for your supra fast reply.

We have decided to add the back issue 'by hand' instead of converting the existing journal XML your OJS XML.

Posts: 10
Joined: Mon Dec 19, 2005 11:00 am
Location: Edmonton, Canada

Return to OJS Technical Support

Who is online

Users browsing this forum: Yahoo [Bot] and 3 guests