I have 3 shops on TB, 2 of them I've updated recently to edge and the schema check is working again. This time there are lots and lots of 'fixes' most of them are size related:
Column ps_access.id_profile has data type int(10) unsigned instead of int(11) unsigned
But some of them offer to change the encoding:
Table ps_store should use character set utf8mb4/utf8mb4_unicode_ci instead of utf8/utf8_general_ci
And some of them I don't even know what they do:
Column ps_product_attribute.ecotax has data type decimal(17,6) instead of decimal(20,6)
The most conserning things are the encoding related. As far as I read the proposed one is better but could there be some some data corruption if I apply those fixes?
(backups are always made, no need to advise on that :) )
How safe is to apply the fixes there?
I have 3 shops on TB, 2 of them I've updated recently to edge and the schema check is working again. This time there are lots and lots of 'fixes' most of them are size related:
Column ps_access.id_profile has data type int(10) unsigned instead of int(11) unsigned
But some of them offer to change the encoding:
Table ps_store should use character set utf8mb4/utf8mb4_unicode_ci instead of utf8/utf8_general_ci
And some of them I don't even know what they do:
Column ps_product_attribute.ecotax has data type decimal(17,6) instead of decimal(20,6)
The most conserning things are the encoding related. As far as I read the proposed one is better but could there be some some data corruption if I apply those fixes?
(backups are always made, no need to advise on that :) )
Share this post
Link to post
Share on other sites