Submission SciELO

The SciELO publishing system is a component of the SciELO methodology and uses the Open Journal Systems (http://pkp.sfu.ca) as support for managing and publishing journals in electronic format.

New Submission On-line

The New Submission On-line is a development that intends to merge the SciELO Submission version of the OJS based on OJS 2.2.X with the new OJS version 2.3.X. The merge involves develop new features available only in SciELO/OJS to become part of the last OJS version.

Full Documentation

Update process of OJS 2.2.1 to OJS 2.3.3-1

Migration Database ‘Scieloojsprod’ to the original version OJS 2.3.3-1.

* Step 1 - Preparing the environment

1.1 - Install the original version of OJS 2.2.1, fulfilling all the required steps, creating the database MySQL and naming it as 'scieloojsprod'.

1.2 - Restore the database 'scielojsprod' from the DUMP file that was generated from the production version.

$mysql –u root –p scieloojsprod < [dump.sql]

* Step 2 - Data Processing

2.1 - Making of duplications lifting on table 'copyed_assignments', column 'article_id'. for deletion conformed a criterion taking the value 0 (zero) to column 'copyeditor_id'. To observe the possibility of more than two hits.

Example: 

SELECT article_id, copyed_id, COUNT(*) 
FROM copyed_assignments 
WHERE article_id <> '' AND copyeditor_id = 0 
GROUP BY article_id HAVING COUNT(*) > 1 
ORDER BY COUNT(*) DESC;

2.2 - Build a QUERY to select duplicates to be eliminated, conformed a criterion for 'article_id' used earlier.

Examples:

SELECT * FROM copyed_assignments WHERE article_id = 9856;
SELECT * FROM copyed_assignments WHERE article_id = 6932;

2.3 - Delete records conformed criterion for 'copyed_id'.

Examples:

DELETE FROM copyed_assignments WHERE copyed_id = 5258;
DELETE FROM copyed_assignments WHERE copyed_id = 7436;

2.4 - Delete table 'subscritions' (under review).

Examples:

DELETE FROM ‘subscriptions’;

* Step 3 - Upgrade the application

3.1 - Download and apply ‘patch from OJS 2.2.1' available at PKP. 

$sudo wget http://pkp.sfu.ca/ojs/download/patch/ojs-2.2.1_to_2.3.3-1.patch.gz

$patch  –p1 < ojs-2.2.1_to_2.3.3-1.patch

* Step 4 - Resolving the problem of performance (select reviewers on article page) 

Access page: http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=6068

Apply the diff command: diff -b -i 6068.diff


The files:

classes/security/RoleDAO.inc.php 
classes/submission/editor/EditorSubmissionDAO.inc.php 
classes/submission/sectionEditor/SectionEditorSubmissionDAO.inc.php 
lib/pkp/classes/core/PKPApplication.inc.php 
lib/pkp/classes/security/UserGroupDAO.inc.php 
lib/pkp/classes/user/InterestDAO.inc.php 
lib/pkp/classes/user/PKPUserDAO.inc.php

Another way to update:

Get the ojs from Github 

URL: http://github.com/pkp/ojs.git

Get Source: git clone http://github.com/pkp/ojs.git

OBS: from this option you have to prepares the database, the steps 1 to 2.4 as above, after look the follow that resolve one bug.

Resolving the problem of performance (select reviewers on article page) 

Access page: http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=6068

Apply the diff command: diff -b -i 6068.diff


The files:

classes/security/RoleDAO.inc.php 
classes/submission/editor/EditorSubmissionDAO.inc.php 
classes/submission/sectionEditor/SectionEditorSubmissionDAO.inc.php 
lib/pkp/classes/core/PKPApplication.inc.php 
lib/pkp/classes/security/UserGroupDAO.inc.php 
lib/pkp/classes/user/InterestDAO.inc.php 
lib/pkp/classes/user/PKPUserDAO.inc.php

* Step 5 - Replacement file

Copy the file SubmissionEditHandler.inc.php to the folder /pages/sectionEditor .

The code of this file has been changed to correct an error when selecting 'edit articles', as described in http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=6450#p26291

Attachments