Bug Index column size too large. The maximum column size is 767 bytes.

[Tealk]

Hi,

when trying to install the add-on I get the following error message:

XF\Db\Exception: xf_dbtech_ecommerce_tickets_ticket: MySQL query error [1709]: Index column size too large. The maximum column size is 767 bytes. in src/XF/Db/AbstractStatement.php at line 217

but in my mysql config I would have already activated innodb_large_prefix

 

[Tealk]

I've narrowed down the problem.
I can only create varchar to 191.
$table->addColumn('license_key', 'varchar', 250)->setDefault('');

 

[Fillip H.]

What version of MySQL are you running?

 

[Tealk]

10.1.38-MariaDB
This is the last release on stable https://packages.debian.org/de/stretch/mariadb-server

 

[Fillip H.]

It's certainly not the latest available version in most distributions, that would be 10.3. In either case, I'll investigate further and get back to you when I have more information.

 

[Fillip H.]

The next version will see this resolved, you won't need to make any changes though as you already have it installed

 

[Tealk]

I adapted the installation to be able to install it.

Thank you.

 

[DragonByte Technologies]

Hello @Tealk,

We hope your ticket regarding DragonByte eCommerce: Tickets has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @Tealk,

As we have not heard back from you, your ticket regarding DragonByte eCommerce: Tickets has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.