HI, im upgrading OJS from 2.4.8.1 to 3.2.0-1 when goes to
[code: Installer Installer::convertSupplementaryFiles]
appears the fllowing error:
PHP Fatal error: Uncaught Error: Call to undefined method ArticleGalley::setSubmissionId() in /repository/ojs/ojs-3.2.0-1/classes/install/Upgrade.inc.php:1077
Stack trace:
#0 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->convertSupplementaryFiles(Object(Upgrade), Array)
#1 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction(Array)
#2 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#3 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#4 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/cliTool/UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#5 /repository/ojs/ojs-3.2.0-1/tools/upgrade.php(22): UpgradeTool->execute()
#6 {main}
thrown in /repository/ojs/ojs-3.2.0-1/classes/install/Upgrade.inc.php on line 1077
Hi @Humberto_Blanco_Cast,
Can you double-check your OJS version? OJS 3.2.1 hasn’t been released yet.
Regards,
Alec Smecher
Public Knowledge Project Team
excuses the correct version its 3.2.0-1
Hi @Humberto_Blanco_Cast,
Thanks, that helps; could you try the following?
Please let me know if this works, and if not, what error message you get.
Regards,
Alec Smecher
Public Knowledge Project Team
@asmercher
thanks, I applied that and this is the results
[code: Installer Installer::convertQueries]
[code: Installer Installer::migrateFiles]
WARNING: Unable to find a match for “1-3-1-SM.pdf” in “datos/journals/1//articles/1/”. Skipping this file.
WARNING: Unable to find a match for “1-5-1-RV.pdf” in “datos/journals/1//articles/1/”. Skipping this file.
WARNING: Unable to find a match for “1-19-1-CE.pdf” in “datos/journals/1//articles/1/”. Skipping this file.
WARNING: Unable to find a match for “9-1308-1-SM.pdf” in “datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-1309-2-RV.pdf” in “datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-1309-1-RV.pdf” in “datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-5451-1-ED.pdf” in “datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-1310-1-CE.pdf” in “datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “9-5452-1-LE.pdf” in “datos/journals/2//articles/9/”. Skipping this file.
WARNING: Unable to find a match for “200-634-1-SM.pdf” in “datos/journals/2//articles/200/”. Skipping this file.
WARNING: Unable to find a match for “200-635-1-RV.pdf” in “datos/journals/2//articles/200/”. Skipping this file.
WARNING: Unable to find a match for “2802-9909-1-CE.pdf” in “datos/journals/5//articles/2802/”. Skipping this file.
WARNING: Unable to find a match for “2802-9908-1-SM.pdf” in “datos/journals/5//articles/2802/”. Skipping this file.
[code: Installer Installer::convertSupplementaryFiles]
PHP Notice: Undefined index: in /repository/ojs/ojs-3.2.0-1/classes/install/Upgrade.inc.php on line 1091
PHP Fatal error: Uncaught Exception: DB Error: Field ‘file_id’ doesn’t have a default value Query: INSERT INTO submission_galleys (locale, submission_id, remote_url, label) VALUES (?, ?, ?, ?) in /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), ‘INSERT INTO sub…’)
#1 /repository/ojs/ojs-3.2.0-1/classes/install/Upgrade.inc.php(1091): DAO->update(‘INSERT INTO sub…’, Array)
#2 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->convertSupplementaryFiles(Object(Upgrade), Array)
#3 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction(Array)
#4 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#6 /repository/ojs/ojs-3.2.0-1/lib/pkp/classes/cliTool/UpgradeTool.inc in ojs/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php on line 70
Hi @Humberto_Blanco_Cast,
That’s progress, believe it or not!
Try the following, after restoring your database and files directory from backup, but before running the upgrade script:
ALTER TABLE article_galleys MODIFY COLUMN file_id INT;
This will relax the NOT NULL
constraint on that column that’s causing problems.
Regards,
Alec Smecher
Public Knowledge Project Team
It worked, thank you very much.Now a new error appears in the process
[data: dbscripts/xml/upgrade/3.0.2_update.xml]
[note: docs/release-notes/README-3.0.2]
[code: Installer Installer::moveReviewerFiles]
ERROR: Reviewer files with ID 6357 from review assignment 222 could not be found in the database table submission_files
ERROR: Reviewer files with ID 6633 from review assignment 240 could not be found in the database table submission_files
ERROR: Reviewer files with ID 8393 from review assignment 671 could not be found in the database table submission_files
ERROR: Reviewer files with ID 13489 from review assignment 1769 could not be found in the database table submission_files
ERROR: Reviewer files with ID 18256 from review assignment 2749 could not be found in the database table submission_files
ERROR: Reviewer files with ID 22120 from review assignment 3616 could not be found in the database table submission_files
ERROR: Reviewer files with ID 20793 from review assignment 3646 could not be found in the database table submission_files
ERROR: Reviewer files with ID 22899 from review assignment 4184 could not be found in the database table submission_files
ERROR: Reviewer files with ID 25427 from review assignment 4665 could not be found in the database table submission_files
ERROR: Reviewer files with ID 26515 from review assignment 4816 could not be found in the database table submission_files
ERROR: Reviewer files with ID 30756 from review assignment 5641 could not be found in the database table submission_files
[code: Installer Installer::fixAuthorGroup]
[data: dbscripts/xml/upgrade/3.0.0_reviewer_files.xml]
ERROR: Upgrade failed: DB: Column ‘review_round_id’ cannot be null
Hi @Humberto_Blanco_Cast,
That’s another issue; there are a few forum threads about that message, and as I recall, some users have found these SQL statements helpful: Upgrade to 3.0.0: pkey violation on review_rounds · Issue #1921 · pkp/pkp-lib · GitHub
Regards,
Alec Smecher
Public Knowledge Project Team