Post by klavatron » Sun May 13, 2018 7:05 pm

Hi!
:o 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.
8) Solving: You need to change VARCHAR(7) to VARCHAR(9) for 'location' column in 'xxx_custom_field' table. You can run query:

Code: Select all

ALTER TABLE xxx_custom_field MODIFY location VARCHAR(9) NOT NULL;
where xxx - is you prefix.

Have a nice day!
Image

Image

Newbie

Posts

Joined
Sun May 13, 2018 5:52 pm

Post by klavatron » Mon May 14, 2018 11:12 pm

note: If you install OC it will create a column with length = 10, but if you then install upgrade /upload/install/model/upgrade/1004.php, line 26 will change the length to 7.

Here a small fix for it https://github.com/opencart/opencart/pull/6636

Newbie

Posts

Joined
Sun May 13, 2018 5:52 pm
Who is online

Users browsing this forum: Baidu [Spider] and 7 guests