Problem: In Customers->Custom Fields add a new Custom field with Location = Affiliate and save. Now in "Location" column you'll see the string "text_affilia" instead of "Affiliate" (which is the value for the language key "text_affiliate").
Reason: Type of 'location' column in 'xxx_custom_field' table of your database is VARCHAR(7). Size of "Affiliate" string is 9. Data too long for a column.
Solving: You need to change VARCHAR(7) to VARCHAR(9) for 'location' column in 'xxx_custom_field' table. You can run query:
where xxx - is you prefix.
Code: Select all
ALTER TABLE xxx_custom_field MODIFY location VARCHAR(9) NOT NULL;
Have a nice day!