Hi,
The error
BLOB/TEXT column 'codemelli' used in key specification without a key length
means you need to specify the length you want to take into account for the unique key because the column is of the "text" type.
So for example, you can use the MySQL query:
alter table ciofl_hikashop_user ADD UNIQUE(codemelli(100));
That way, it will only take into account the first 100 characters of the text in codemelli to be unique.
Basically, it depends on the length of the text you expect your users to enter in that field. But it's best to not make it too long.
HIKASHOP ESSENTIAL 49,95€The basic version. With the main features for a little shop.
HIKAMARKETAdd-on Create a multivendor platform. Enable many vendors on your website.
HIKASERIALAdd-on Sale e-tickets, vouchers, gift certificates, serial numbers and more!
MARKETPLACEPlugins, modules and other kinds of integrations for HikaShop
HIKAAUCTION 40€Add-on Create auctions and let your customers bid for products.
ACCESS THE CHECKOUTClick here to access the payment area
