Can't save products that have custom fields

  • Posts: 22
  • Thank you received: 0
11 years 3 months ago #115747

Hello,

I have created some custom fields for a specific category of products and when I try to save a new product I get a message that says "error can't save", when I modify an existing product and click save the following message appears: "error saving, at least another product with the same sku". Obviously, there is no other product with the same sku and the issue is caused by the custom fields.

These are the custom fields added:



This is the error when saving the product:


I've just seeing something weird in the frontend:

The products I've tried to modify show up a button with "select options" text on the category list:



And in the product page you can see a text that says "specifications":





Any ideas on how to get this solved?

Thanks

Attachments:
Last edit: 11 years 3 months ago by walter.

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

  • Posts: 2334
  • Thank you received: 403
11 years 3 months ago #115778

Hi there,

It sounds like something we already fixed, could you please download and install the last Hikashop version (2.2.0)?

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

  • Posts: 22
  • Thank you received: 0
11 years 3 months ago #115834

Yes, I re-installed the last version, just in case, and still the same thing: can't save products with custom fields

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

  • Posts: 2334
  • Thank you received: 403
11 years 3 months ago #115849

Well, if you indeed have the last version we'll need a back access as well as a FTP access to test it by ourselves.

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

  • Posts: 22
  • Thank you received: 0
11 years 3 months ago #115878

I'm sending you the details through a PM

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

  • Posts: 82730
  • Thank you received: 13343
  • MODERATOR
11 years 3 months ago #116130

Unfortunately you didn't provide a FTP access and the user account you provided didn't allow us to access the configuration of Joomla in order to turn on the debug mode. So we were able to confirm the problem on your website, but we couldn't debug it.

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

  • Posts: 82730
  • Thank you received: 13343
  • MODERATOR
11 years 3 months ago #116496

Great we got the FTP access now.

I went to your website backend to be able to debug the issue but now the backend access that you provided doesn't work anymore. We need both at the same time to be able to debug the issue.

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

  • Posts: 82730
  • Thank you received: 13343
  • MODERATOR
11 years 3 months ago #116535

I found the error on your website. It's this:

Unknown column 'producto_aerografo_deposito' in 'field list' SQL=UPDATE `ta25_hikashop_product` SET `product_name`='Aerógrafo Elite E7180',`product_url`='',`product_meta_description`='Aerógrafo Elite E7180. Aerógrafo de gravedad de doble accion con paso 0.25 mm. Aerógrafo con 6 años de garantía',`product_keywords`='',`product_page_title`='Aerografo Elite E7180',`product_alias`='aerografo-elite-e7180',`product_canonical`='',`product_code`='E7180',`product_tax_id`='11',`product_manufacturer_id`='22',`product_layout`='',`product_quantity`='-1',`product_min_per_order`='0',`product_max_per_order`='0',`product_sale_start`='',`product_sale_end`='',`product_msrp`='0.0000000',`product_weight`='1.000',`product_weight_unit`='kg',`product_length`='20.000',`product_width`='10.000',`product_dimension_unit`='cm',`product_height`='4.000',`product_published`='1',`product_access`='all',`product_group_after_purchase`='',`producto_aerografo_marca`='serf',`producto_aerografo_modelo`='sdf',`producto_aerografo_gatillo`='Doble Acción',`producto_a...

which means that you have a custom product field with the column name producto_aerografo_deposito but the column in the table hikashop_product of the database is missing.
There are several possibilities there:
- You created the field and there was an error preventing HikaShop from creating the column in the database.
- You inserted the field in the hikashop_field table and thus the system didn't create the column for the custom field in the hikashop_product table.
- You deleted the column of that hikashop_product table after creating the field.

So the solution is to either :
- delete the field and recreate it so that HikaShop can add the column name in the hikashop_product table
- add the column manually to the hikashop_product table via phpmyadmin

Note that you might have the same issue with other custom fields. If you turn on the "debug mode" option of the joomla configuration, you will be able to see the error which might be on another custom field column once you fix it for this one.

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

Time to create page: 0.093 seconds
Powered by Kunena Forum