Add to cart button redirects to main dashboard page

[johnxl]

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 !

 

 

 

 

[PrestaHeroes USA]

your migration failed and your shop is probably not salvageable on your own or even 50 forum posts.  It's not clear why you choose the method you did.

I recommend your fallback to original and start over.

Create a dev shop and use native PS upgrade method to upgrade your shop.

 

 

 

[johnxl]

18 minutes ago, El Patron said:

your migration failed and your shop is probably not salvageable on your own or even 50 forum posts.  It's not clear why you choose the method you did.

I recommend your fallback to original and start over.

Create a dev shop and use native PS upgrade method to upgrade your shop.

 

 

 

I transfered only my domain to new hosting !  I managed to install fresh PS instalation on new hosting because old one has 100 errors .

Now I got fresh working 1.7.6.4 PS instalation on my new hosting !

I only need to get my products !

 

Only place where they are is my old database on old hosting !

 

What can I do ?

How can I get products on new store ?

I'm really not a professional . 

 

I exported from my old database all ps_category tables one by one , and all ps_product tables and all image tables ! Then imported in to new database !

As I said front office works fine  . Problem with Backooffice !

 

Only thing that I can do is add all products manually !? It will take 100 hours   And I loose all google search results ?!

[PrestaHeroes USA]

well you should have copied shop to new hosting, created dev and and test native PS upgrade

the other option is there are modules that allow you to export and import to new PS versions.