Item custom field not saved

Hi,

Everything was working fine, but not the item custom field. It was set up properly where I could input in the product page, and it was in the cart database, until the checkout was completed.

I have set up the item custom field for a product. The whole checkout process was completed but I realised the input was not updated in the database "order_product", after the order was created. This error did not occur when I tried with sample data installation. But only occurred when it was a "clean" installation.

Where could the error be in?

Edit: Joomla log prompted database query "INSERT IGNORE INTO josvp_hikashop_order_product (order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id,order_product_tax_info,order_product_wishlist_id,order_product_shipping_id,order_product_shipping_method,order_product_shipping_price,order_product_shipping_tax,order_product_shipping_params)
VALUES (2,1,1,'Air Freight','AFE01','','0','',2,'',0,'','',0,0,'')"

This query didn't include the item custom field.

Painstakingly looked through the logs, fixed the problem via the database table "field", column "field_frontcomp" changed to "1". Thereafter, it works. There is definitely a bug here as the back-end administration page has no option of "front-end" but the coding takes into account of "front-end" data stored in the database table "field".

Please do look into this, since it could have further implication. Thank you.

Hi,

Since the 2.6.0 we've added a new custom field display system with new display options. For the fields to display properly, it requires to edit the custom fields and save them again in some cases (it will set the field_frontcomp value automatically).

Hi Nicolas,

I did edit and save again the item custom fields, and I'm not referring to the showing of fields. Despite having dhis "re-save", the database did not update the frontcomp value to 1. Hence, the bug has worsen. For your information, I did spent hours looking the forums for existing similar issue but to no avail.

Hi,

I've done a test to try to replicate the issue with HikaShop Business 2.6.4 and I don't have the problem. After creating a new custom item field and saving it, the field_frontcomp value is 1.

Hello,

My client also have similar prblem. But his current version is 2.6.3. Saving and re-saving did not worked.
So i also changed the value to 1 from phpmyadmin and it start saving the value and showing order details and email..

Thanks
Kishore

Hi,

Yes, there was such problem on the 2.6.3.
The problem was fixed in the 2.6..4