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

[MiguelPeixoto]

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 ?

[Nette]

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.  

[MiguelPeixoto]

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;

 

[Temam Awelu]

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

it worked for me 
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;