[SOLVED] Problem adding new products and editing the existing ones

[gabri_lb]

Hi,

 

I have a Prestashop install version 1.5.5.0.

 

I am having problems adding new products and editing the existing ones.

An error occurred while updating object. product ()

 

I have followed a topic where I must modify the database doing this:

 

alter table ps_product add column redirect_type int (10) ;
alter table ps_product_shop add column redirect_type int (10) ;

 

But id did not work.

I need help with this!!!!!

 

PS:

This id the whole error:

 

Unknown column 'id_product_redirected' in 'field list'

INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '2', '1', '0', '0', '0', '1', '0', '0', '', '0', '0', '0', '0', '0', '1', '404', '0', '1', '0000-00-00', 'new', '1', '0', 'both', '0', '0', '2013-10-20 19:40:36', '2013-10-20 19:40:36')

Edited October 20, 2013 by vekia (see edit history)

[gabri_lb]

I found the solution by doing this:

 

alter table ps_product add column id_product_redirected int (10) ;
alter table ps_product_shop add column id_product_redirected int (10) ;

 

I seemed to be the same error with a different column. I hope to help someone else if had the same problem

[vekia]

hello

thank you for information that you solved it and of course how you did that.

im going to mark this thread as [solved]

 

you can also mark own topics as solved

here are the instructions:

 

 

[sOLVED] Topic
If, after posting a topic, you find a solution to your problem, please indicate it in your post and describe the solution.
Furthermore if you are the author of the topic for which a solution has been found, please edit your topic title to mark it as [sOLVED].

To mark a topic as [solved] :
- Edit the first post of your topic by clicking on the "Edit" button,
- Click on the "Use full editor" button,
- Add the "[solved]" string at the beginning of your topic title and click on the "Submit Modified Post" button.