shazy8
June 14, 2023, 6:40pm
1
While upgrading to OJS version 3.4.0.0 from OJS 3.3.0.7 following error has occurred:
A database error has occurred: Exception: A row with setting_name=“submissionChecklist” found in table journal_settings without the expected setting_value. Expected an array encoded in JSON but found:
All submissions must meet the following requirements.
i) Eliminate non-standard abbreviation in the titles.
ii) Supply full name of author(s) including institutions.
iii) Abstract: (maximum) 250 words. Keyword: (minimum) 5 key words. Article: (maximum) 2000-3000 words (excluding references, tables/illustrations).
iv) The number of tables/illustrations should not exceed more than 5. References: (minimum) 18, recent last five years citation.
v) Cite tables/figures in the text in numerical order.
vi) Supply references in Vancouver style, accurately cited in the text in numerical order.
ix) All authors must sign Authorship Contribution form, confirming he or she has made the contributions listed in the form.
x) Author agreement is signed by all the authors (principal author and co-authors).
viii) Submit the paper via emails given below; sofia.kabir@gandhara.edu.pk and editor@jfinph.org.pk.
Fix or remove this row before upgrading. in /home1/jgnahspk/public_html/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php:308 Stack trace: #0 /home1/jgnahspk/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(235): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->PKP\migration\upgrade\v3_4_0{closure}(Object(stdClass), 0) #1 /home1/jgnahspk/public_html/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(291): Illuminate\Support\Collection->each(Object(Closure)) #2 /home1/jgnahspk/public_html/lib/pkp/classes/migration/upgrade/v3_4_0/PreflightCheckMigration.php(52): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->checkSubmissionChecklist() #3 /home1/jgnahspk/public_html/lib/pkp/classes/install/Installer.php(463): PKP\migration\upgrade\v3_4_0\PreflightCheckMigration->up() #4 /home1/jgnahspk/public_html/lib/pkp/classes/install/Installer.php(294): PKP\install\Installer->executeAction(Array) #5 /home1/jgnahspk/public_html/lib/pkp/classes/install/Installer.php(209): PKP\install\Installer->executeInstaller() #6 /home1/jgnahspk/public_html/lib/pkp/classes/install/form/UpgradeForm.php(49): PKP\install\Installer->execute() #7 /home1/jgnahspk/public_html/lib/pkp/pages/install/InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #8 [internal function]: PKP\pages\install\InstallHandler->installUpgrade(Array, Object(APP\core\Request)) #9 /home1/jgnahspk/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func(Array, Array, Object(APP\core\Request)) #10 /home1/jgnahspk/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false) #11 /home1/jgnahspk/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route(Object(APP\core\Request)) #12 /home1/jgnahspk/public_html/lib/pkp/classes/core/PKPApplication.php(373): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #13 /home1/jgnahspk/public_html/index.php(21): PKP\core\PKPApplication->execute() #14 {main}
please suggest how to fix this error.
1 Like
the same form me.
opened 11:21AM - 08 May 23 UTC
closed 06:40PM - 11 May 23 UTC
**Describe the bug**
During an OJS 3.3 to OJS 3.4 test upgrade the upgrade proc… ess fails with the error message:
```
[A pre-flight check failed. The software was successfully upgraded to 3.3.9.9 but could not be upgraded further (to 3.4.0.0). Check and correct the error, then try again.]
ERROR: Upgrade failed: DB: A row with setting_name="submissionChecklist" found in table journal_settings without the expected setting_value. Expected an array encoded in JSON but found:
{"0":{"order":44,"content":"Der Beitrag passt in den Scope von <em>FQS<\/em>."},"3":{"order":46,"content":"Bitte nutzen Sie unser Template und stellen Sie sicher, dass die inhaltlichen, formalen, stilistischen und bibliografischen Anforderungen der Hinweise zur <a href=\"https:\/\/www.qualitative-research.net\/index.php\/fqs\/submission\/guidelines\" target=\"_blank\" >Manuskriptgestaltung<\/a> umgesetzt wurden."},"1":{"order":34,"content":"Der zur Einreichung vorgesehene Beitrag wurde noch nicht veröffentlicht und ist auch nicht zur Veröffentlichung an einem anderen Ort vorgesehen. Andernfalls nehmen Sie bitte <em>vor Einreichung<\/em> Kontakt zur <a href=\"mailto:fqs@qualitative-research.net\">Redaktion<\/a> aufnehmen. "},"10":{"order":35,"content":"Für Beiträge, die aus Qualifikationsarbeiten (z.B. Dissertation) entstanden sind, akzeptieren wir in aller Regel nur eine Einzelautor*innenschaft. Betreuer*innen können nach erfolgreicher Begutachtung in einer Danksagung gewürdigt werden."},"11":{"order":36,"content":"\"Selbstplagiate\" bitte prinzipiell vermeiden, indem Teile aus bereits veröffentlichten Texten korrekt zitiert werden."},"2":{"order":37,"content":"Rechte bzw. Lizenzen für alle im Beitrag verwandten Materialien, Abbildungen usw. liegen bei den Autor*innen bzw. müssen vor Publikation eingeholt und im Text entsprechend ausgewiesen werden."},"4":{"order":38,"content":"<em>Gender Bias<\/em> bitte prinzipiell vermeiden, siehe die APA-Empfehlungen zu <a href=\"https:\/\/apastyle.apa.org\/style-grammar-guidelines\/bias-free-language\" target=\"_blank\" rel=\"noopener\">Bias-Free Language<\/a>."},"5":{"order":39,"content":"In <em>FQS<\/em> bereits verfügbare Veröffentlichungen wurden systematisch berücksichtigt."},"7":{"order":40,"content":"Anthropomorphismen bitte prinzipiell vermeiden: Nicht Beiträge oder Studien arbeiten, fragen, forschen, beschreiben usw., sondern die Forschenden bzw. Autor*innen (APA 6, Abschnitt 3.09 \"Precision and Clarity\", S.69)."},"9":{"order":41,"content":"Bitte die Vergangenheitsform verwenden, wenn die Arbeit anderer Autor*innen besprochen wird (APA 6, 3.18 \"Verbs\", S.78)."},"8":{"order":42,"content":"Texte von Nicht-Muttersprachler*innen müssen vor Einreichung sorgfältig muttersprachlich geprüft worden sein."},"12":{"order":47,"content":"Im Falle multipler Autor*innenschaft bitte vollständige Metatdaten für jede einzelne Person bei Einreichung eingeben."}}
```
despite the fact that the json string is correctly fromated.
**To Reproduce**
Steps to reproduce the behavior:
1. Perform a 3.3 to 3.4 Upgrade with a custom submission checklist.
**What application are you using?**
OJS 3.4
**Additional information**
The error originates in PreflightCheckMigration line 686.
$checklist = json_decode($value);
returns the checklist as type stdClass
which does not validate as array in:
if (is_null($checklist) || !is_array($checklist)) {...}
I temporariliy "fixed" this by changing line 686 to:
$checklist = json_decode($value, true);
which obviously renders !is_array($checklist) useless ...
Hi all,
It’s likely that this is caused by an upgrade that failed and then was attempted again. Are you sure you restored your OJS 3.3.0-x database from backup if the upgrade already failed?
Regards,
i have make now a new upgrade.
this is the error that appear
Fatal error : Uncaught Error: Call to undefined function Symfony\Component\Mailer\Transport\Smtp\Stream\proc_open() in /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/symfony/mailer/Transport/Smtp/Stream/ProcessStream.php:41 Stack trace: #0 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(251): Symfony\Component\Mailer\Transport\Smtp\Stream\ProcessStream->initialize() #1 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(194): Symfony\Component\Mailer\Transport\Smtp\SmtpTransport->start() #2 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/symfony/mailer/Transport/AbstractTransport.php(69): Symfony\Component\Mailer\Transport\Smtp\SmtpTransport->doSend() #3 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(136): Symfony\Component\Mailer\Transport\AbstractTransport->send() #4 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/symfony/mailer/Transport/SendmailTransport.php(74): Symfony\Component\Mailer\Transport\Smtp\SmtpTransport->send() #5 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/mail/Mailer.php(155): Symfony\Component\Mailer\Transport\SendmailTransport->send() #6 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(287): PKP\mail\Mailer->sendSymfonyMessage() #7 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/mail/Mailer.php(120): Illuminate\Mail\Mailer->send() #8 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Mail/Mailable.php(204): PKP\mail\Mailer->send() #9 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Traits/Localizable.php(19): Illuminate\Mail\Mailable->Illuminate\Mail{closure}() #10 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Mail/Mailable.php(197): Illuminate\Mail\Mailable->withLocale() #11 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(309): Illuminate\Mail\Mailable->send() #12 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(253): Illuminate\Mail\Mailer->sendMailable() #13 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/mail/Mailer.php(120): Illuminate\Mail\Mailer->send() #14 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Mail/MailManager.php(554): PKP\mail\Mailer->send() #15 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Mail\MailManager->__call() #16 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/scheduledTask/ScheduledTaskHelper.php(243): Illuminate\Support\Facades\Facade::__callStatic() #17 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/scheduledTask/ScheduledTaskHelper.php(173): PKP\scheduledTask\ScheduledTaskHelper->_sendEmail() #18 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/scheduledTask/ScheduledTask.php(170): PKP\scheduledTask\ScheduledTaskHelper->notifyExecutionResult() #19 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/migration/upgrade/v3_4_0/I8508_ConvertCurrentLogFile.php(44): PKP\scheduledTask\ScheduledTask->execute() #20 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/install/Installer.php(463): PKP\migration\upgrade\v3_4_0\I8508_ConvertCurrentLogFile->up() #21 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/install/Installer.php(294): PKP\install\Installer->executeAction() #22 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/install/Installer.php(209): PKP\install\Installer->executeInstaller() #23 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/install/form/UpgradeForm.php(49): PKP\install\Installer->execute() #24 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/pages/install/InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #25 [internal function]: PKP\pages\install\InstallHandler->installUpgrade() #26 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #27 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #28 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #29 /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/classes/core/PKPApplication.php(373): PKP\core\Dispatcher->dispatch() #30 /web/htdocs/amq.aiqua.it/home/backup33014/index.php(21): PKP\core\PKPApplication->execute() #31 {main} thrown in /web/htdocs/amq.aiqua.it/home/backup33014/lib/pkp/lib/vendor/symfony/mailer/Transport/Smtp/Stream/ProcessStream.php on line 41
this is the sreen shoot of the upgrade!
if I then go to administration it tells me that I have to upgrade from 3.3.0.14 to 3.4, when the upgrade is done
Its mean the upgradation is not sucessful, did you received the sucessful upgradation msg
Hi all,
The error:
Fatal error : Uncaught Error: Call to undefined function Symfony\Component\Mailer\Transport\Smtp\Stream\proc_open()
…is happening because the proc_open function has been disabled in your PHP configuration. OJS needs this function in order to send email; you’ll need to adjust your PHP configuration.
Regards,
Thank you @asmecher for pointing out the thread where the answer was already given but we are working on a shared server where proc_open is disabled now in this case there is any other solution available.
thank you
Hi @Azhar_Munir ,
I’m afraid that the proc_open function is required by the Symfony mailer, which OJS 3.4.0 uses to send email. If your shared host is truly unwilling to enable that function, you’ll have to move to another server.
Regards,
Hi Alec
Thank you for your support. Now the proc_open is enabled but we are still facing the same issue. Is there anything else we have to fix.
Azhar
Hi @Azhar_Munir ,
Check your error log. If it really is the same error message, perhaps you need to restart your web server in order for the configuration change to take effect. You can double-check by looking at your phpinfo information page; it can confirm whether the change to the disabled function list has actually taken effect.
Regards,
Hi @asmecher
Thank you so much for your support. now the problem is solved by restarting the web server.
Azhar Munir
1 Like
