SQL Error after upload database with the extension discussion_languages

ash3T

I have resolve the following issue:

-- Indexes for table `discussion_languages`
--
ALTER TABLE `discussion_languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `discussion_languages_code_unique` (`code`)

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

The screenshot after I upload the database

The screenshot after I made changes to the database

I am not sure the same situation happens to others. However, I guess it's good to make a notes, just in case, this will be helpful to someone else in the future. Cheers!

clarkwinkelmann

ash3T which extension provides that table?

We've seen these errors pop up in the past when a long table prefix was used, but here it looks like there is no table name prefix? I'm not sure what the default max_key_length is in MySQL. If the developers didn't see the error the default value is probably longer.

ash3T

clarkwinkelmann I believe it is this extension https://discuss.flarum.org/d/23702-friendsofflarum-discussion-language

Yes, it seems that "discussion_languages_code_unique" is set to be varchar 255 which is too long.