Upgrade error from 3.1.2.1 to 3.3.0-6 / A database error has occurred: SQLSTATE[HY000]: General error: 1366 Incorrect string value

Current version: 3.1.2.1 (July 25, 2019 - 07:44 PM)**

Server Information

Setting Name: Setting Value
OS platform: Linux
PHP version: 7.4.19
Apache version: Apache/2
Database driver: mysqli
Database server version: 5.7.33

When I try to update 3.1.2-1 to 3.3.0-6 I get the following error:
I tried it a few times but did not get any results.
Anyone have a suggestion?

Errors occurred during installation:

  • A database error has occurred: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xCE\xB1-lac…’ for column ‘setting_value’ at row 1 (SQL: INSERT INTO publication_settings(publication_id, locale, setting_name, setting_value) SELECT s.current_publication_id, ss.locale, ss.setting_name, ss.setting_value FROM submissions as s LEFT JOIN submission_settings as ss ON (ss.submission_id = s.submission_id) WHERE ( setting_name IN (‘abstract’, ‘cleanTitle’, ‘copyrightHolder’, ‘copyrightYear’, ‘coverage’, ‘coverImage’, ‘licenseUrl’, ‘locale’, ‘prefix’, ‘rights’, ‘source’, ‘subtitle’, ‘title’, ‘type’) OR setting_name LIKE ‘%pub-id%’ ) )
    Upgrade Open Journal Systems _ Open Journal System

When I try to update 3.1.2-1 to 3.2.1.3 I get the following different error:

A database error has occurred: Incorrect table definition; there can be only one auto column and it must be defined as a key
Upgrade Open Journal Systems - Google Chrome 2021-

Hi @kerimsarigul

It seems that you have mix collation in your database. Could you please review it and double check that everything (DB and tables) are using utf8 as charser encoding ?

An user had this very same issue and resolved forcing all DB to this charset:

Best,
Israel

1 Like

After several attempts, I successfully updated from 3.1.2.1 to 3.3.0.7.
How did I troubleshoot problems I encountered before?
-I converted MyISAM tables in the database to InnoDB.
-I made the database structure utf8_general_ci.

Çeşitli denemeler sonrası 3.1.2.1’den 3.3.0.7’ye başarılı bir güncelleme gerçekleştirebildim.
Daha önce karşılaştığım sorunları nasıl giderdim?
-Veri tabanındaki MyISAM tablolarını InnoDB’ye dönüştürdüm.
-Veritabanının yapısını utf8_general_ci yaptım.

1 Like