Error Saving - after update

  • Posts: 1
  • Thank you received: 0
10 years 8 months ago #148667

Getting an error "Error Saving" in a red block when trying to save a product

-- url of the page with the problem -- : www.securityproductsonline.co.za/adminis...ikashop&ctrl=product
-- HikaShop version -- : Starter: 2.2.3
-- Joomla version -- : 2.5
-- PHP version -- : 5.2
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- :
500 - An error has occurred.
JDatabaseMySQL::query: 1054 - Unknown column 'product_warehouse_id' in 'field list' SQL=INSERT IGNORE INTO `tbn4f_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_msrp`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Dummy Product','','','','','','','Dummy_Product','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','','1395136659','1395136659' )

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

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 8 months ago #148742

Hi,

That's because the update of the database structure didn't work properly during the update process:
www.hikashop.com/support/support/documen...lity-issues.html#SQL
As explained there, you'll have to manually run the ALTER query to add the product_warehouse_id column to your hikashop_product table and it will then work properly again.

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

Time to create page: 0.056 seconds
Powered by Kunena Forum