A database error has occurred: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long

Software Support
1

I got an error while I try to setup ojs 3.4.

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

What can I do? Thank you,
Wolfgang

2

Same problem too. Have you solved this?

3

Hi,
I got the below error
Kindly help me
A database error has occurred: SQLSTATE[HY000] [1045] Access denied for user ‘ojs2’@‘localhost’ (using password: NO) (SQL: create table journals (journal_id bigint not null auto_increment primary key, path varchar(32) not null, seq double(8, 2) not null default ‘0’ comment ‘Used to order lists of journals’, primary_locale varchar(14) not null, enabled smallint not null default ‘1’ comment ‘Controls whether or not the journal is considered "live" and will appear on the website. (Note that disabled journals may still be accessible, but only if the user knows the URL.)’, current_issue_id bigint null) default character set utf8 collate ‘utf8_general_ci’)