SQL error on creating custom fields in Hikashop 3.3.0

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.5
-- PHP version -- : 7.0.27
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
1060 Duplicate column name 'product_tessssst'

Hi
Today I upgraded from starter to business edition. When I create any new custom field I get the below error:

An error has occurred.
1060 Duplicate column name 'product_tessssst'

but the field gets created, and if you delete the field it is NOT deleted from the Database.
also all other sorts of issues happen when using this custom field.

I have made a fresh Joomla install and only installed Hikashop business to it and the same problem happened.

Please this is urgent as I intend to use many custom fields on the website.

Thank you for your attention, but, still there is a problem with the field as it is not deleted from the DB after deleting it from Hikashop and only the field title appears in the shopping cart and check out and email but not its value.

I think more work needs to be done.

Thanks again for your attention.

Thanks for the reply, could you explain why only the custom field title appears in the shopping cart and check out and email but not its value? it's empty!

Thanks

Thank you for your reply,
so this happened with me using both versions of Hikashop (3.3.0\3.2.2 )so maybe I'm missing something,

I want to customize the products to be suitable for a (tour product) so I will have to add many custom fields, some of them are text written by me, others to be filled by the client on the front end before check out and on check out.

steps I took : create custom field > go to product page and add the content > buy the product and checkout of shopping cart> receive the email.

I did not do any customization to the email templates, they are the default ones.

in Version 3.3.0 if I used a date field with a simple calendar selector this scenario would happen:
I add the date at the back end and it displays the field name and content on the front end, thats great, but, If I later on delete the content of the field in the back end the front end still displays the field name and the content is just zeros 00:00:00:00:00 which I don not want to appear in the front end because there is not a set date for the tour.

they also don't appear in the order backend

I did some testing and you are correct, I didn't enter the data in the varient because it is common for the product and all the varients and so entering it multiple times is a waste of time and can lead to human error !
Is there a way to call certain costume fields from the product page and not the varients?

Also you are correct I have the same issue with the date being all zero because I noticed in the DB that's not a 'null' value but the 00:00:00:00:00 value. How can this be solved?

Hi
Believe it or not, but, now I tried to reproduce the error with a new field that I created and it did not happen!! but I have a screen shoot of an error msg when that happened, I will attach it.

At that time I had connected two product custom fields together, the first one was (do you want to set a date? | radio button | value Yes, No) and the second one with the date field to appear on the condition that the first field value was (Yes).

nicolas wrote: Hi,

Make sure that you're using a custom field of the type "advanced date picker". With a "date" type field, it's possible that it won't work properly in some cases with Joomla 3...specially if you change the format of the date.