Phoca Forum

Using Joomla 4.3.0
Trying to install Phoca Cart 4.0.6 but get the following error message:

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.6.php

I've tried investigating the sql tables, but it apparently occurs in filling. Any idea how to fix?

Bob

How do I change the maximum index size in my database?

Hi, this is a common problem in db, try to see:
https://stackoverflow.com/questions/672 ... -767-bytes

The ROW_FORMAT=DYNAMIC solution should help.

Jan

Success. Thanks for the tip about setting ROW_FORMAT = DYNAMIC. Easy and Phoca Cart now installed on Joomla 4 DEVSITE

Hi, great to hear it.

Jan