Error On updating process

[Atherys]

Specified key was too long; max key length is 1000 bytes
/home/www/atherys.com/public_html/system/Db/Db.php::2181

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

[Jim M]

I have transferred this to a ticket to better suit you with this issue, obtain access, and escalate this ticket to be further investigated. Please see our email asking for further access details 🙂 .

[Atherys]

12 minutes ago, Jim M said:

I have transferred this to a ticket to better suit you with this issue, obtain access, and escalate this ticket to be further investigated. Please see our email asking for further access details 🙂 .

are you able to contact our alt contact to deal with it?

[Jim M]

6 minutes ago, Atherys said:

are you able to contact our alt contact to deal with it?

they can reply to the email if they are authorized for support.

[Atherys]

14 minutes ago, Jim M said:

they can reply to the email if they are authorized for support.

the alt contact checked their email and didnt see anything

[Jim M]

Just now, Atherys said:

the alt contact checked their email and didnt see anything

you would need to provide them the email, I'm afraid. 

[Marc]

I see from your ticket this appears to be an issue with your table types not all being INNODB and collation issues. Once those are resolved, that should solve the issue for you