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

[aarm]

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.

[geegee]

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

[zod]

I tested the solution here (as fresh install Prestashop 1.7.7.1) and it worked.

 

[hadrien01]

I can confirm it still works with Prestashop 1.7.8.3 (on Wampserver with MariaDB)

[astralabe]

Cela fonctionne , Merci.

a été néssésaire pour installé la boutique en local sur wamp avec la version prestashop_1.7.8.7.

[Zohaib-fk]

Thanks for sharing. It works.

File location \psroot\install\data\db_structure.sql

Before doing change

CREATE TABLE `PREFIX_accessory` (
  `id_product_1` int(10) unsigned NOT NULL,
  `id_product_2` int(10) unsigned NOT NULL,
  KEY `accessory_product` (`id_product_1`, `id_product_2`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4 COLLATION;

After doing change

CREATE TABLE `PREFIX_accessory` (
  `id_product_1` int(10) unsigned NOT NULL,
  `id_product_2` int(10) unsigned NOT NULL,
  KEY `accessory_product` (`id_product_1`, `id_product_2`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

[Propustrading]

Dated: 13 October 2022

I faced the very same issue during a fresh installation using wamp but this solution didn't work for me. I was still getting the error so I searched over youtube and found another solution where I had to change text type to dynamic and it worked. Video for reference: