**Get an error when installing ojs 3.4.0 **
Errors occurred during installation
A database error has occurred: SQLSTATE: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table
metrics_submission_geo_daily add unique
please note that i change the collation to utf8_unicode_ci
@asmecher Please help I am also facing the same issue
@asmecher Waiting please…
Ah, the index on columns
city, both VARCHAR(255), in the table
metrics_submission_geo_monthly is too big and probably does not make sense. Somehow I was not aware of it back then, when implementing…
Please follow this issue for the fix: Use smaller data types for load_id and city in the metrics tables · Issue #9231 · pkp/pkp-lib · GitHub.
Thanks a lot!