Specified key was too long; max key length is 1000 bytes

On some MySQL installations you may run into this error on module installation:

Specified key was too long; max key length is 1000 bytes

This is a known bug within MySQL: https://bugs.mysql.com/bug.php?id=4541

To resolve please make sure your installation defaults to using InnoDb as the default storage engine:

set GLOBAL storage_engine='InnoDb';

Or for MySQL 5.6 and above:

SET GLOBAL default_storage_engine = 'InnoDB';

In future versions of the WHMCS Module Shop Module we will endeavour to prevent this error from occurring at all.

UPDATE: This issue has been resolved in version 1.0.1

  • 35 Users Found This Useful
Was this answer helpful?

Related Articles

Installation Instructions

The latest update to install instructions can be found here, and also in the module downloads...

System Requirements

All WHMCS System Requirements which can be found here:...

Upgrade Instructions

The module provides automatic update functionality, however if you prefer you can upgrade...