Unknown column 'product_condition' in 'field list'

  • Posts: 215
  • Thank you received: 4
  • Hikashop Business
3 months 3 weeks ago #289890

-- url of the page with the problem -- : www.car-and-tuning.nl
-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.6
-- PHP version -- : 7
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'product_condition' in 'field list'

When we want to delete categories attached to products we get this error when we are saving the product:

Unknown column 'product_condition' in 'field list'

Regards
Jan

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

  • Posts: 62706
  • Thank you received: 8985
  • MODERATOR
3 months 3 weeks ago #289895

Hi,

That's a column that was added in HikaShop 3.3.0
Click on the "check database" button of the HikaShop configuration and it should add it automatically.

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

  • Posts: 215
  • Thank you received: 4
  • Hikashop Business
3 months 3 weeks ago #289931

Nicolas,

Can you tell me in which tabel which field is missing?
This site won't run update database very well :-(

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

  • Posts: 62706
  • Thank you received: 8985
  • MODERATOR
3 months 3 weeks ago #289933

Hi,

It's the field "product_condition" of the table "hikashop_product".

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

  • Posts: 215
  • Thank you received: 4
  • Hikashop Business
3 months 3 weeks ago #289957

Nicolas,

I think I have a little problem with this site :-(.
The product table is 2.961.462 records and 870Mb. They have a lot of variants.

I know that the check database don't run due to server problems. I thought it was an 3.3.0 installation, but it is 3.2.2. I can't update to 3.3.0. I think due to the database update.

In 3.3.0 you added 5 fields to the product table.

What to do?

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

  • Posts: 62706
  • Thank you received: 8985
  • MODERATOR
3 months 3 weeks ago #289966

Hi,

Here is what you can do:
1. Add the missing fields in the product table manually in your PHPMyAdmin.
2. Delete the code corresponding to these fields in the install.hikashop.php file of the install package you can download on our website in the menu My account>My subscriptions.
3. Install that install package on your website via the Joomla installer. That will run the update to the 3.3.0 and it won't add these fields, but since they will be already there, it will work fine.

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

Time to create page: 0.083 seconds
Powered by Kunena Forum