The queries return:
SELECT DISTINCT setting_name FROM user_settings WHERE locale IS NOT NULL;
setting_name
----------------------------
givenName
filterSection
affiliation
orcid
profileImage
signature
apiKey
filterEditor
familyName
citation-editor-hide-intro
preferredPublicName
apiKeyEnabled
biography
(13 rows)
SELECT DISTINCT setting_name FROM user_settings WHERE locale IS NULL;
setting_name
--------------
(0 rows)
It looks like we have all the settings localized?
I also run this solution since the issue described in Error when updating from 3.1.2-4 to 3.2.0-1 with postgres - #4 by asmecher appears
ALTER TABLE journal_settings ALTER COLUMN setting_type DROP NOT NULL
Edit:
We’ve downgraded to php 7.4 and this error (and the next one) went away. Maybe a section could be added in the upgrade, that php 7.4 should be used? Updated to fix the typo in the postgres queries. After the update there seems to be three more rows in the first result.