search

marcelmika / lims

LIMS - Messenger for Liferay (Free)
http://lims.io
Other
7 stars 11 forks source link

Specified key was too long; max key length is 767 bytes: create unique index IX_9738C4E2 on Limsmuc_Conversation (conversationId);_ [Sanitized] #201

Closed bill2004158 closed 9 years ago

bill2004158 commented 9 years ago

create table Limsmuc_Conversation ( cid LONG not null primary key, conversationId VARCHAR(256) null, conversationType INTEGER, updatedAt DATE null, syncIdSUC LONG );

create unique index IX_9738C4E2 on Limsmuc_Conversation (conversationId);

it will happend if that error if charset is utf.

fix: change conversationId to VARCHAR(255)

marcelmika commented 9 years ago

fixed by setting the size of conversationId column to 255