Cannot import database to host after 5.7.13 to 8.5.1
Has anyone seen this, and can offer any help? I'm stuck here.
Error SQL query: -- -- Indexes for table `AreaLayoutPresets` -- ALTER TABLE `AreaLayoutPresets` ADD PRIMARY KEY (`arLayoutPresetID`), ADD KEY `arLayoutID` (`arLayoutID`), ADD KEY `arLayoutPresetName` (`arLayoutPresetName`) MySQL said: Documentation #1709 - Index column size too large. The maximum column size is 767 bytes. [ Back ]
I think there are some command-line (and maybe phpMyAdmin) solutions in the forum for forcing the collation to something else.
I had insurmountable trouble with the latest version of xampp, which still doesn't fully support the new c5 encoding. I think c5 8.5 can still work with the earlier encoding.
I've see this (https://github.com/concrete5/concrete5/issues/7707#issuecomment-479911751) but it doesn't seem to do anything for me.
I'm hoping someone has a fix.