Hello !
I am trying to export my products from my old prestashop 1.7.2.3 database to my new store database which runs latest 1.7.6.4
I exported/imported tables ps_products categories,atributes ,images,combinations and other I needed.
Front office works fine !
Problem is in Backoffice !
I can't update any products info !
I can't add New product,
I cant'dublicate product !
When I press add to cart button it redicerts to Dahbord main page .
I enabeled DEBUG MODE and get this when I pres add to cart button !
Unknown column 'additional_delivery_times' in 'field list'<br /><br /><pre>INSERT INTO `prstshp_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '1', NULL, '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2020-03-12 18:00:43', '2020-03-12 18:00:43', '3')</pre>
When I export back original ps_product table everthing works fine !
In new 1.7.6.4 ps_product table structure there is 53 rows
But in old 1.7.2.3 is only 50 rows additional_delivery_times' and two others is missing
I should add them ? How ?
Or there is another solution ?
Thanks !