Describe the issue or problem
Error when upgrade ojs 3.4.0.8 to 3.4.0.9 with error:
[Thu Oct 09 12:10:45.175126 2025] [php:notice] [pid 1744:tid 1892] [client 127.0.0.1:50833] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table usage_stats_total_temporary_records add index ust_load_id_context_id_ip_ua_url(load_id, context_id, ip, user_agent, canonical_url)), referer: http://localhost/3409/index.php/index/install/upgrade
Steps I took leading up to the issue
For example:
- Go to upgrade page
- Click on Upgrade Button
- See error
What application are you using?
For example, OJS 3.3.0-8
Additional information
Please add any screenshots, logs or other information we can use to investigate this problem.