OJS 3.4 installing problem

Software Support
1

**Get an error when installing ojs 3.4.0 **
Errors occurred during installation
A database error has occurred: SQLSTATE[42000]: 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 msgd_uc_load_context_submission_c_r_c_date(load_id, context_id, submission_id, country, region, city, date))

please note that i change the collation to utf8_unicode_ci

2

@asmecher Please help I am also facing the same issue

3

@asmecher Waiting please…

4

Hi all,

Ah, the index on columns load_id and city, both VARCHAR(255), in the table metrics_submission_geo_daily and 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!
Bozana