[SOLVED] Error when changing the product category

[rcristov]

Hello,

 

I use PrestaShop™ 1.5.5.0 and every time i go change a product form one category to another one i got the error's that is not possible to connect the object. product to category and the error trying to remove the tags that already exits.

 

Thanks,

 

Rcristov

[vekia]

hello

 

can you show your error code?

it's first time when i see message like that.

just copy paste message / share printscreen

[rcristov]

Hello Vekia,

 

My prestashop is translate to portugues but i copy the error here and gona try to translate:

 

An error occurred while setting priorities.

An error occurred while saving the attachments of the product.

An error occurred while trying to remove previous tags.

An error occurred while connecting the object. For product categories

 

Thanks,

 

rcristov

[rcristov]

Hello again,

 

Forgot to put the print screen

 

[rcristov]

Problem solve after digging in the forum i found the solution.

 

Just run this command in SQL and solve this issue.

 

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

 

I fount this in the folling link

 

http://www.prestashop.com/forums/topic/213042-upgrade-to-1530-problems/

 

Thanks,

 

Rui Cristovao

[vekia]

hello

 

thank you for sharing solution, it will be helpful for merchants with similar issues

i marked whole topic as [sovled]

 

with regards,

Milos

[wissammessad]

Hello,

 

i have tried to paste 

 

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

 in my SQL and i get the following error

 

Error

SQL query:

 

alter table ps_product add column redirect_type int (10) ;

 

MySQL said: 

#1060 - Duplicate column name 'redirect_type' 

 

 

 

 

[vekia]

message that you see means that you already have this column in your table, you cant create two the same columns