an error installing an extension: com_phocacart_v4.0.5.zip

[napravnik]

Na nové Joomla4 jsem nainstaloval Phoca Cart a po instalaci mi to dalo tuto chybu. Můžete mi poradit kde je chyba.

-----
JInstaller: :Install: Error SQL Index column size too large. The maximum column size is 767 bytes.
Extension installation aborted.
Package Install: There was an error installing an extension: com_phocacart_v4.0.5.zip
danger
Error installing package

[Jan]

Ahoj, to vypadá na nějaký problém v Joomle a databázové struktuře. Zkus zapnout debug mode a instalovat znovu, jestli to nenapíše více detailů. Co je to za databázi? Je aktuální?

[Danjerab]

Phoca Cart a po instalaci mi to dalo tuto chybu. Můžete mi poradit kde je chyba.

-----
JInstaller: :Install: Chyba Velikost sloupce indexu SQL je příliš velká. Maximální velikost sloupce je 767 bajtů.
Instalace rozšíření byla přerušena.
Instalace balíčku: Při instalaci rozšíření došlo k chybě: com_phocacart_v4.0.5.zip

[mcmarco]

i have the same situation.

[Jan]

Hi, Phoca Cart does not install itself, it is installed by Joomla Extension Manager component, so seems like there is some problem. When you enable debug mode, do you get more information?

BTW, try to see this topic, I think, this is the same problem:
https://www.joomlapolis.com/forum/147-p ... -767-bytes

Jan

[AlainR]

@Jan, do you think it's a solution to change all CHARSET=utf8mb4 and all DEFAULT COLLATE=utf8mb4_unicode_ci to CHARSET=utf8 and to DEFAULT COLLATE=utf8_unicode_ci ?

I did it and I was able to install Phoca Cart without error. Now I configure it and it doesn’t seem to be a problem: I was able to create 2 categories and 3 products, install the modules and display the cart and categories on the site.

[Jan]

Hi, really hard to say. In fact, I have no experiences with such behaviour, so really cannot give clue advice there. So if it works and whole system works correctly, then this can be the right way for your environment I don't think there should be some hidden issue so if it works, then it is OK.