Dear Sir.
After Altering DB, I altered DB Table one by one from php MyAdmin.
ran SQL like following
ALTER TABLE
elgg_config
CONVERT TO CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;
It appears that all tables have updated except the following three tables.
elgg_config
elgg_datalists
elgg_users_sessions
I get an error msg with all the above three tables. The error msg is:
#1071 - Specified key was too long; max key length is 1000 bytes
Before Collation was utf8_general_cim, but agter altering it now shows utf8mb4_unicode_ci for each table except the above three.
What should I do? Could anyone help me?
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- ihayredinov@ihayredinov
ihayredinov - 0 likes
You must log in to post replies.I don't really need utf8mb4 support on those tables, but you can first remove the keys, change encoding then try again.