Specified key was too long; max key length is 1000 bytes

Recent upgrade to 4.0 is giving database upgrade error. The error message is
“Specified key was too long; max key length is 767 bytes”

Your assistance is highly appreciated

Thanks in advance

• This reply was modified 3 years, 10 months ago by myetutors.

I had the same error “Specified key was too long; max key length is 1000 bytes” with 10.2.37-MariaD.
But then I tried with MySQL 5.7.32 and the database upgrade to 4.0 went fine.

Any help with MariaDB ?

• This reply was modified 3 years, 10 months ago by bassory99.

Hi @myetutors @mcworks

MySQL version older than 5.7 leads to this error. You need to update your MySQL to the newest version, and then update LearnPress 4.0 once again.
Please read the tutorial here https://docspress.thimpress.com/upgrade-database/

Thanks for replies, since i’m on a shared hosting upgrading I believe is a preserve of the host.. Even so I’ve noted the SQL version is 5.7.33-cll-lve

I have since then done it the hard way and yanked it out and installed afresh. however I now notice theming/styling issues and conflicts.

Hi, I have the same problem.
“Specified key was too long; max key length is 1000 bytes”

I see on my database (from cPanel > PhpAdmin) and see that my database are:
Database client version: libmysql – 5.6.43
(It means 5.6 isn’t it?)

But, I don’t know how to upgrade to 5.7.
Any input?

Thank you

Updated:
I already update mySQL to version: 10
(10.3.28-MariaDB-cll-lve – MariaDB Server)

But still, error when I click upgrade, still found this notification:

Upgrade Database.
Specified key was too long; max key length is 1000 bytes

Please help..

Hi @mcworks @kangaviv

LearnPress has been updated to version 4.0.1, you can update and retry the Update Database process.