Upgrade database from OJS 2.4.2.0 to OJS 3.0.1

Aashish_Gurung · May 22, 2017, 7:08am

I am trying to update my odl OJS 2.4.x version to 3.0.1. I got this following error.

    [pre-install]
    [load: upgrade.xml]
    [version: 3.0.1.0]
[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml]
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptTimedViews.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptReferrals.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptBooksForReview.xml]
[data: dbscripts/xml/upgrade/remove_timed_views_bots.xml]
[code: Installer Installer::migrateCounterPluginUsageStatistics]
<h1>DB Error: Table 'jnhrc_server_old.metrics' doesn't exist</h1>ojs2: DB Error: Table 'jnhrc_server_old.metrics' doesn't exist

I tried the solution of this link link which is for OJS 3.0.2(mine is OJS3.0.1) but same error is still showing up. How can I fix this issue?

ctgraham · May 22, 2017, 1:11pm

Is there any reason you have selected OJS 3.0.1 instead of 3.0.2? The revision number change may be small, but the improvements between 3.0.1 and 3.0.2 are significant.

Two ways for you to approach this would be:

Upgrade to 2.4.3 (or later) first, then to 3.x
Upgrade to 3.0.2 from GitHub (the ojs-stable-3_0_2 branch has the needed fix, but the packaged .zip will not).

Aashish_Gurung · May 23, 2017, 2:29am

@ctgraham I got this project recently and it was already built using 3.0.1. There is the problem of not opening PDF and DOCX file. I am trying to solve this issue so thought to upgrade the old database to the new one. I will upgrade it to OJS stable 3_0_2 as you said.

Also, I want to know how OJS saves files in database and filesystem? If there is a file in “journals/1/articles/146/submission/proof/146-1-143-1-10-20130822.pdf” and “journals/1/articles/146/submission/proof/146-1-143-1-PB.pdf” then, how it is saved in database? How OJS access the file? Thank you.

ctgraham · May 23, 2017, 12:30pm

In OJS 3.x, the files are indexed in the database in the submissions_file table. Note that this changed substantially between 2.4.x and 3.x.

The class SubmissionFile represents these files from a code perspective, with DAO access via SubmissionFileDAODelegate.

SubmissionFile::_getFileName() is the method to look at in terms of mapping SubmissionFile attributes to the filename on disk:

github.com

pkp/pkp-lib/blob/044e0697ee305a84ff2deb6a921328a8e68dba8e/classes/submission/SubmissionFile.inc.php#L601-L619


	/**
	 * Generate the unique filename for this submission file.
	 * @return string
	 */
	function _generateFileName() {
		// Generate a human readable time stamp.
		$timestamp = date('Ymd', strtotime($this->getDateUploaded()));

		// Make the file name unique across all files and file revisions.
		// Also make sure that files can be ordered sensibly by file name.
		return	$this->getSubmissionId() . '-'.
			$this->getGenreId() . '-' .
			$this->getFileId() . '-' .
			$this->getRevision() . '-' .
			$this->getFileStage() . '-' .
			$timestamp .
			'.' .
			strtolower_codesafe($this->getExtension());
	}

Aashish_Gurung · May 25, 2017, 9:50am

@ctgraham Thank you for your time. I upgraded it to OJS3.0.2 and it’s working fine.