Gagal Upgrade OJS Versi 3.2.1.4 ke versi 3.3.0-8

[agil]

Selamat malam para master.

Beberapa hari kemarin saya mencoba melakukan upgrade OJS dari versi 3.2.1.4 ke versi 3.3.0-8
Proses upload file OJS versi baru berjalan dengan baik
dan saya copy di OJS versi lama file :
– config.inc.php
– public/
kemudian saya timpahkan ke OJS baru. kemudian file config.inc.php "installed" udaj saya ubah "On" menjadi "off"

Namun hasil setelah saya akses URL OJS baru dan lakukan upgrade, proses upgrade tidak berjalan, hanya muncul kalaman putih setelah saya mengklik tombol Upgrade Open Journal Systems

Lebih jelasnya saya sertakan gambar di bawah ini.

 

[rbchosting]

Kemungkinan ada kesalahan pada konfigurasi servernya, coba cek error log nya aja dulu, atau permission foldernya,

saya belum pernah install OJS sih jadi mungkin suhu yang lain bisa membantu menjelaskan

 

[agil]

Kemungkinan ada kesalahan pada konfigurasi servernya, coba cek error log nya aja dulu, atau permission foldernya,

saya belum pernah install OJS sih jadi mungkin suhu yang lain bisa membantu menjelaskan

#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[05-Oct-2021 11:01:52 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('set names '' co...', Array)
#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[05-Oct-2021 11:02:56 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('set names '' co...', Array)
#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[05-Oct-2021 11:04:17 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('set names '' co...', Array)
#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[05-Oct-2021 11:04:23 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('set names '' co...', Array)
#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[05-Oct-2021 11:08:15 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('set names '' co...', Array)
#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[05-Oct-2021 1134 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('set names '' co...', Array)
#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[05-Oct-2021 12:52:12 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('set names '' co...', Array)
#1 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names '' co...')
#2 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConn in /home/unnxid/public_html/ejurnal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

 

[agil]

itu error lognya

 

[rbchosting]

PHP nya versi berapa? Kalau saya googling sih OJS 3.3 minimal PHP 7.3 dan MySQL/MariaDB 4.1 atau PostgreSQL 9.5

 

[agil]

PHP nya versi berapa? Kalau saya googling sih OJS 3.3 minimal PHP 7.3 dan MySQL/MariaDB 4.1 atau PostgreSQL 9.5

Recommended system requirements

• PHP >= 7.3.0; you are currently using PHP 7.3.30
• MySQL >= 4.1 or PostgreSQL >= 9.1.5
• Apache >= 1.3.2x or >= 2.0.4x or Microsoft IIS 6
• Operating system: Any OS that supports the above software, including Linux, BSD, Solaris, Mac OS X, Windows

 

[mas.satriyo]

[05-Oct-2021 11:01:52 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in

kayaknya dari charset db ada yg error
pake mysql/mariadb versi berapa? php versi berapa?

 

[agil]

kayaknya dari charset db ada yg error
pake mysql/mariadb versi berapa? php versi berapa?

Apache Version 2.4.48
MySQL Version 10.3.31-MariaDB-cll-lve
PHP Version 7.4.23 (sebelumnya pakai 7.3.30 dan saya coba naikan ke versi 7.4 tetap belum berhasil)



Recommended system requirements

• PHP >= 7.3.0; you are currently using PHP 7.4.24
• MySQL >= 4.1 or PostgreSQL >= 9.1.5
• Apache >= 1.3.2x or >= 2.0.4x or Microsoft IIS 6
• Operating system: Any OS that supports the above software, including Linux, BSD, Solaris, Mac OS X, Windows

 

[mas.satriyo]

MySQL Version 10.3.31-MariaDB-cll-lve

coba sql-nya pakai mysql, jangan mariadb
beberapa aplikasi 'mutlak' minta mysql
kami pengalaman terima keluhan user untuk aplikasi erp, mailing manager (kelola surat keluar-masuk, bukan webmail), aplikasi kelola buku/perpus, dsb. pakai mariadb tidak jalan, tapi pakai mysql lancar

coba buat server staging dulu di lokal untuk 'bermain' config

 

[Milea Adnan]

edit config/database.php

paramater charset dan collation, cb diganti dengan :

'charset' => 'utf8', 'collation' => 'utf8_unicode_ci',