Error Upgrade OJS 2.4.3 to 3.1.2

I am Trying to Upgrade OJS to Version 3, Upgrade is failed and show error message like this:

ERROR: Upgrade failed: DB: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation ‘replace’

When i repeat the upgrade, a different error message show up like this :
image

Can anyone help me find this solution ?

Thank you.

Hi @AriefArfiansyah

You would need to restore from a backup when you try the upgrade a second time. OJS would have renamed the table by that point. You can’t “resume” an upgrade.

What are your database character encoding settings from config.inc.php? (please do not post your db password).

Cheers,

Hi @jnugent Thank you for reply,

I do restore and try upgrade again but still failed and same error message.

ERROR: Upgrade failed: DB: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation ‘replace’

You mean this settings Jason ?
image

Thank You.

Hi there,

Yes, those settings. If you’re not explicitly setting the database_charset or the connection_charset, you’re going to get whatever the database and connection libraries default to, which might be latin1, not utf8. You should take a look at your existing database and make sure that everything is the same. It sounds like some things are mismatched.

Cheers,

Hi @jnugent Thank you for reply,

So the OJS 3 should be Latin1 for database_charset & Connection_Charset ? because if i upgrade from 2.4.3 to 2.4.8 its fine with the same settings.

Thank you.

It should be whatever it currently is :slight_smile: You can find out by looking at your 2.4 database and running the following mysql command:

SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = "your-database-name";

Cheers,
Jason

Hi @jnugent Thank you for Reply,

My db setting :
image

My Config.inc.php :
image
db and config configuration are the same, what should I do? change to latin_1?

Thank You.