Installation error width database key error

sunlix / ProcessAbbreviate

Easily mark up and manage abbreviations

http://www.zenmotion.de

2 stars 0 forks source link

Installation error width database key error #2

Closed aw73 closed 7 years ago

aw73 commented 7 years ago

On Processwire 3.0.61 and PHP 7.1.4 I have this error on module install

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes Failed to init module: Abbreviate - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tool_processwire.abbreviations' doesn't exist

sunlix commented 7 years ago

Hi, on what encoding runs your installation? utf8 or newer utf8mb4? I think it is utf8mb4 - I will have a look.

aw73 commented 7 years ago

Yes I used MariaDB and I have to configure it in utf8mb4. varchar(191) is a good alternative ;-)

sunlix commented 7 years ago

thanks, i will submit a patch.

proesswire offers a special method to got the needed info.