Jump to content

SQL error on query Index column size too large. The maximum column size is 767 bytes.


Recommended Posts

Can some on help to see whats wrong and how to repair?

An error occurred during installation...

You can use the links on the left column to go back to the previous steps, or restart the installation process by clicking here.

1: SQL error on query Index column size too large. The maximum column size is 767 bytes.

Share this post


Link to post
Share on other sites
  • 1 month later...

Hi

you could edit the file install/data/db_structure.sql and replace every occurance of

DEFAULT CHARSET=utf8mb4 COLLATION

with

DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

then klick the restart button and the install works..

but not sure if this has any long term impact on the shop

  • Thanks 1

Share this post


Link to post
Share on other sites
  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More