Item custom field not saved

  • Posts: 3
  • Thank you received: 1
8 years 9 months ago #248995

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.

Last edit: 8 years 9 months ago by hikashi.
The following user(s) said Thank You: kishoreweblabs

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 1
8 years 9 months ago #249005

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.

Please Log in or Create an account to join the conversation.

  • Posts: 83993
  • Thank you received: 13605
  • MODERATOR
8 years 9 months ago #249007

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).

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 1
8 years 9 months ago #249038

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.

Please Log in or Create an account to join the conversation.

  • Posts: 83993
  • Thank you received: 13605
  • MODERATOR
8 years 9 months ago #249040

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.

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 1
8 years 5 months ago #259700

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


Available for paid hikashop consulting
www.kishoreweblabs.com

Please Log in or Create an account to join the conversation.

  • Posts: 83993
  • Thank you received: 13605
  • MODERATOR
8 years 5 months ago #259751

Hi,

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.076 seconds
Powered by Kunena Forum