Menu

Topic-icon Setup Error - Specified key was too long; max key length is 767 bytes

  • proftulioprado
  • proftulioprado's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
7 months 4 weeks ago #7403 by proftulioprado
I am trying to install Security Check Pro but the following message appears:

"SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes"

how can i solve this?
Attachments:

Please Log in or Create an account to join the conversation.

More
7 months 4 weeks ago - 7 months 2 weeks ago #7404 by Jose
Hi proftulioprado,

Securitycheck Pro's default database character set it’s utf8mb4 which includes support for storing emojis and other features. For sites running MySQL v5.7.7 and higher you do not need to do anything.

For those running MariaDB or older versions of MySQL you may hit this error. To solve it just update your mysql or your Mariadb database. If you don0t know how to do that please ask to your hosting provider.

Regards,
Jose
Last edit: 7 months 2 weeks ago by Jose. Reason: Add info

Please Log in or Create an account to join the conversation.

Time to create page: 0.073 seconds
Powered by Kunena Forum

Login or Sign In