Upgrade from 2.4.8.1 to 3.1.0

Upgrade from 2.4.8.1 to 3.1.0

Hello OJS community. I’m new to OJS and I was recently asked if I could help with the upgrade to a new version.

Two errors that I get are

  1. 500 internal server due to
    openat(AT_FDCWD, “/home/admin/domains/***/files/journals/3//articles/23/”, O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC)

= 4
17:50:07 getdents(4, {{d_ino=8520758, d_off=5414650472540660654,
d_reclen=32, d_name=“submission”, d_type=DT_DIR} {d_ino=6425520,
d_off=7203442428009459052, d_reclen=24, d_name=“…”, d_type=DT_DIR}
{d_ino=7864578, d_off=7325576877962405209, d_reclen=24, d_name=“.”,
d_type=DT_DIR} {d_ino=7864580, d_off=9223372036854775807, d_reclen=32,
d_name=“public”, d_type=DT_DIR}}, 32768) = 112
17:50:07 getdents(4, {}, 32768) = 0
17:50:07 close(4) = 0
17:50:07 stat(“/home/admin/domains//files/journals/
3//articles/23//submission/23-64-1-RV.docx", 0x7ffd49614dc0) = -1 ENOENT
(No such file or directory)
17:50:07 stat("/home/admin/domains/
/files/journals/
3//articles/23//public/23-64-1-RV.docx”, 0x7ffd49614dc0) = -1 ENOENT (No
such file or directory)

  1. A database error has occurred: Illegal mix of collations (latin2_general_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation ‘replace’

Before going to error #1 I would like to get the encoding right. So below is source Data Base info, destination Data Base info and config.inc.php for both version. I’m after reading several topics and in one of them I saw that it should be utf8 instead of utf-8 in config for version 3.0. Is that the same for 3.1? Is there anything else I should do? All help much appreciated. Thank you.

Source DB

Server charset: UTF-8 Unicode (utf8)
Server connection collation: utf8_general_ci

Data base > Operations
Collation: utf8_general_ci

Data base > Structure
Majority of tables have collation set to latin2_general_ci
There are 7 tables (articles, email_log, email_templates_default_data, issue_settings, journal_settings, rt_searches, users) with collation set to utf8_general_ci

Destination DB

Server charset: UTF-8 Unicode (utf8)
Server connection collation: utf8mb4_unicode_ci

Data base > Operations
Collation: utf_general_ci

Data base > Structure
Inherited from source

Source config.inc.php OJS 2.4.8.1

[i18n]

locale = pl_PL
client_charset = utf-8
connection_charset = latin2
database_charset = On
charset_normalization = utf-8

Destination config.inc.php OJS 3.1.0

[i18n]

locale = en_US
client_charset = utf-8
connection_charset = utf-8
database_charset = On
charset_normalization = utf-8

locale = pl_PL commented out as upgrade link is not showing