Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 Technical
 WordPress for Ecommerce Templates
 Error: Specified key was too long ...
Author « Topic »  

GRN
Advanced Member

158 Posts

Pre-sales questions only
(More Details...)

Posted - 05/09/2019 :  12:28:16  
Hi there,

ECT 7.0.5, WP 5.2

I am trying to update from 7.0.4 to 7.0.5 and keep getting the following error ...

'Checking for devicenotifications upgrade
Adding devicenotifications table
Terminated but with errors
Specified key was too long; max key length is 767 bytes'

And have uploaded the files a couple of times.

Thanks.

Glenn

Andy
ECT Moderator

95440 Posts

Posted - 05/09/2019 :  13:28:36  
Hi Glen

I think this may be the issue https://stackoverflow.com/questions/53955427/mysql2error-specified-key-was-too-long-max-key-length-is-767-bytes-for-table

Can you look in the admin database utility to see what collation you are using?

Andy

Please feel free to review / rate our software

GRN
Advanced Member

158 Posts

Pre-sales questions only
(More Details...)

Posted - 05/09/2019 :  13:37:45  
Hi there,

I cannot access the ECT control panel now, just get the header with no menu options nor any info below the header. But I checked a similar site and it is showing latin1_swedish_ci, so I suspect the site with the error is the same.

Thanks.

Glenn

Andy
ECT Moderator

95440 Posts

Posted - 05/09/2019 :  14:00:44  
Do you have access to phpmyadmin via the hosting control panel as the collation can be changed there directly?

Andy

Please feel free to review / rate our software

GRN
Advanced Member

158 Posts

Pre-sales questions only
(More Details...)

Posted - 05/09/2019 :  14:12:17  
Hi there,

Yes. I selected the database and it shows the latin1_swedish_ci collation. Not being real proficient with it, I tried changing the collation via operations, collation, utf8_general_ci, go; the update was successful, but the collation did not change; ran the ECT update again anyway and it completed this time; checked the database again and devicenotifications table did update with the utf8_general_ci collation. The front-end and back-end seem to work OK and a test order went through. So I guess this means all is OK??

When you check the collation via the ECT admin it still shows the latin1_swedish_ci version, should I change it to the utf8_general_ci??

Thanks.

Glenn

Andy
ECT Moderator

95440 Posts

Posted - 05/09/2019 :  14:16:19  
Personally I wouldn't change anything now.

Andy

Please feel free to review / rate our software

GRN
Advanced Member

158 Posts

Pre-sales questions only
(More Details...)

Posted - 05/09/2019 :  14:34:25  
OK, sounds like a plan.

Thanks again.

Glenn
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.02 seconds. Snitz Forums 2000