Migration of 1.1.9 and 1.1.10 article files errors

[tmreyno]

Hello,

working on some test migrations of 1x installs and running into problems. This is affecting 1.1.9 and 1.1.10 ojs migration to 2.1.0-1. first I am not sure if this is a coding error or permissions error on my part.

The reason for coding error suspect is the /ojs_test file has two year files 2005 and 2006. the warning and error messages says ojs_test2005/*doc and ojs_test2006/*doc and not ojs_test/2005/*doc or ojs_tes/2006/*doc. I did not look at the code to see how these errors are generated but may just be a error message typo.

Since the ojs_test directory and files have been changed to chmod 777 to remove permission issues during testing I am at a small loss as to where to determine the casue of these warnings and thus failure to import.

Here is snippet of the repeated list during import. Please advise!

Warning: filesize(): Stat failed for /directory/where/ojs/1x/files/located/ojs_test2005/HO-2005-6.doc (errno=2 - No such file or directory) in /directory/where/ojs/2.1.0-1/files/located/classes/site/ImportOJS1.inc.php on line 1442

Warning: copy(/directory/where/ojs/1x/files/located/ojs_test2005/HO-2005-6.doc): failed to open stream: No such file or directory in /directory/where/ojs/2.1.0-1/files/located/classes/file/FileManager.inc.php on line 135
Failed to copy file /directory/where/ojs/1x/files/located/ojs_test2005/HO-2005-6.doc


Terry Reynolds
Reynolds Data Communications

[asmecher]

Hi Terry,

Generally, OJS 1.x is configured with a slash at the end of its files directory; try updating the files directory to explicitly contain a slash at the end. You should be able to do something like the following:

• 1. Get the current file path to see if it needs a slash appended

  Code: Select all

  SELECT chFilePath FROM tbljournalconfig;

• 2. Add a slash to the end of it

  Code: Select all

  UPDATE tbljournalconfig SET chFilePath = CONCAT(chFilePath, '/');

  (Note: The above query was corrected according to the note below)

I haven't checked to see what effects this may have on a live installation of OJS 1.x, so you may wish to perform this change on a duplicated database that's not being used for a live OJS 1.x instance.

Regards,
Alec Smecher
Open Journal Systems Team

[tmreyno]

Hi Alec,

Thanks for the suggested fix but the syntax ; was incorrect. instead of

Code: Select all

UPDATE tbljournalconfig SET chFilePath = CONCAT(chFilePath, ';');

it should read as

Code: Select all

UPDATE tbljournalconfig SET chFilePath = CONCAT(chFilePath, '/');

Once that was worked out all went well. Throughout the docs and ojs v2.x website there are lots of little typos in the instructions that can sometime cause weird problems such as what I recently experienced. These are simple problems such as the hanging "/" path problems but are a pain non-the-less.

Cheers,

Terry Reynolds
Reynolds Data Communications