an error installing an extension: com_phocacart_v4.0.5.zip

Phoca Cart - complex e-commerce extension
napravnik
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 08 Nov 2022, 10:26

an error installing an extension: com_phocacart_v4.0.5.zip

Post by 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: an error installing an extension: com_phocacart_v4.0.5.zip

Post by 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í?
If you find Phoca extensions useful, please support the project
Danjerab
Phoca Newbie
Phoca Newbie
Posts: 8
Joined: 10 Dec 2022, 12:06

Phoca Cart a po instalaci v Joomla 4

Post by 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
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 13 Dec 2022, 04:58

Re: an error installing an extension: com_phocacart_v4.0.5.zip

Post by mcmarco »

i have the same situation.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: an error installing an extension: com_phocacart_v4.0.5.zip

Post by 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
If you find Phoca extensions useful, please support the project
AlainR
Phoca Enthusiast
Phoca Enthusiast
Posts: 50
Joined: 24 Jul 2018, 16:33

Re: an error installing an extension: com_phocacart_v4.0.5.zip

Post by 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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: an error installing an extension: com_phocacart_v4.0.5.zip

Post by Jan »

Hi, really hard to say. In fact, I have no experiences with such behaviour, so really cannot give clue advice there. :idea: So if it works and whole system works correctly, then this can be the right way for your environment :idea: I don't think there should be some hidden issue so if it works, then it is OK.
If you find Phoca extensions useful, please support the project
Post Reply