Jump to content

Erros installing PS 1.7.7.0 - SQL Index column size too large. The maximum column size is 767 bytes


Recommended Posts

I'm doing a PS 1.7.7.0 fresh install and I'm getting this error: "SQL Index column size too large. The maximum column size is 767 bytes"

PHP version 7.3.24

Collation: Tried with utf8_bin and utf8mb4_bin

Does anyone know what the problem can be ?

Share this post


Link to post
Share on other sites
On 1/3/2021 at 2:06 PM, MiguelPeixoto said:

I'm doing a PS 1.7.7.0 fresh install and I'm getting this error: "SQL Index column size too large. The maximum column size is 767 bytes"

PHP version 7.3.24

Collation: Tried with utf8_bin and utf8mb4_bin

Does anyone know what the problem can be ?

I have got the same problem. It is my first Installation of a Webshop with a New hoster. I am just beginning my Business.  

Share this post


Link to post
Share on other sites

I managed to solve the problem temporarily, bu altering the sql instructions, creating the database. But PS Team shound incorporate these chnages urgently

The COLLATION must be previosuly set to utf8_general_ci

When upgrading to 1.7.7.0

Before applying the upgrade, run the following instructions:

ALTER TABLE `configuration` ROW_FORMAT=DYNAMIC;
ALTER TABLE `connections_source` ROW_FORMAT=DYNAMIC;
ALTER TABLE `customer` ROW_FORMAT=DYNAMIC;
ALTER TABLE `employee` ROW_FORMAT=DYNAMIC;
ALTER TABLE `order_state` ROW_FORMAT=DYNAMIC;
ALTER TABLE `page_type` ROW_FORMAT=DYNAMIC;
ALTER TABLE `smarty_cache` ROW_FORMAT=DYNAMIC;

 

For new installations:

Find the following file  "install/data/db_structure.sql"

Replace all

ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4 COLLATION;

WITH

ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COLLATION;

 

  • Like 2

Share this post


Link to post
Share on other sites

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