OJS Upgrade error : from ojs-3.2.1-5 to ojs-3.3.0-19

Software Support
1

Hi Team,

i am getting following error while upgrading from ojs-3.2.1-5 to ojs-3.3.0-19 , kindly give the solution.

  • A database error has occurred: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘locale’ in ‘where clause’ (SQL: update event_log_settings set setting_value = {} where setting_name = originalFileName and locale is null and log_id = 7377)
2

@asmecher can you please help here…

3

Hi @suresh_patil,

It looks like you may have tried to run an upgrade on an installation that previously experienced a failed upgrade. If you already tried an upgrade once and experienced a failure, you’ll need to restore from backup before trying again.

Regards,
Alec Smecher
Public Knowledge Project Team

5

fresh installation all over again?

OR

dropping the DB, creating empty DB & restoring the backup (.sql) & running the upgrade command is enough? (this i did, still the same error)

6

Hi @suresh_patil,

It shouldn’t be necessary to create a fresh installation.

What is the full output of the upgrade command? (If you’re using the web-based upgrade tool, I’d suggest using the command line instead. It’ll give more information about the progress of the upgrade before the error.)

Regards,
Alec Smecher
Public Knowledge Project Team

7

Hi,

Thanks!

i have done fresh installation & completed upgradation successfully.

however a small issue:(note: its a OJS multisite instance)

URL: https://production.kristujayantijournal.com/

here

https://production.kristujayantijournal.com/index.php/KJKSP : doesn’t work - shows 500 error

but

ಸಂಪುಟ 3, ಸಂಚಿಕೆ 1, ಮಾರ್ಚ್ 2024 | ಕ್ರಿಸ್ತು ಜಯಂತಿ ಕನ್ನಡ ಸಂಶೋಧನ ಪತ್ರಿಕೆ (KRISTU JAYANTI KANNADA SAMSHODHANA PATHRIKE) - WORKS

all the links are working except the journal home page.

[10-Sep-2024 11:23:39 UTC] PHP Fatal error: Uncaught Error: Call to a member function getOption() on null in /home/tumakuru/kristujayantiproduction/cache/t_compile/b102e3605a8026cfea38e0c3476f11b0ba7ad7bb^e64e579388e5615e11e939b12134d6ae8679eba6_0.app.frontendpagesindexJournal.tpl.php:37
Stack trace:
#0 /home/tumakuru/kristujayantiproduction/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_66e02adaba10e5_80289746(Object(Smarty_Internal_Template))
#1 /home/tumakuru/kristujayantiproduction/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template))
#2 /home/tumakuru/kristujayantiproduction/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template))
#3 /home/tumakuru/kristujayantiproduction/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->rende in /home/tumakuru/kristujayantiproduction/cache/t_compile/b102e3605a8026cfea38e0c3476f11b0ba7ad7bb^e64e579388e5615e11e939b12134d6ae8679eba6_0.app.frontendpagesindexJournal.tpl.php on line 37

================================================

This error indicates a missing or null object being referenced, specifically when trying to call the getOption() function on a null value.

your inputs will be of great help here.

-Thanks

8

i resolved the issue. by enabling default theme for journals.

9

This topic was automatically closed after 14 days. New replies are no longer allowed.