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%’ ) )
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
