Specified key was too long; max key length is 1000 bytes
ALTER TABLE `core_attachments_map` ADD KEY `map_lookup` (`location_key`(250),`id1`,`id2`)
I wanted to know how we can fix this in order to update to the lastest version
It appears background processes are stuck according to the stats in my admin panel. There are certain threads that have 10 comments, but the homepage says there are 5 comments.
That thread has 10 comments, but the homepage says 5. I think cause the background processes are stuck. Any idea how to fix this?
BTW, I tried to manually run the batch and it returned an error.