To many records in ps_order_state, ps_order_state_lang tables

[svetaines1]

Hello,

Few days ago, I had problem with Prestashop back-office Orders tab. After I rewrite whole database with new one, everything start working. I am not expert with databases, so looking for community advices

From my shop start I had 3 PayPal orders. After I check ps_order_state, ps_order_state_lang tables, I found there so many records with PayPal payment.

From page number 2 till page number 428!!!!! in ps_order_state_lang table was same records (see in attachment):

id_order_state (xx) id_lang (1) name (Authorization accepted from PayPal)

Please, someone advice me what was wrong?

Regards,
Vitalij

[rocky]

It's a bug in the PayPal v2.0 module that has been reported on the bug tracker. It has been marked as "Confirmed", so the PrestaShop team plan to fix it. Until they fix it, your only option is to manually delete all the extra order states.

[svetaines1]

Thank's Rocky,

At the moment I am using PayPal 1.7 version

[rocky]

It can't be PayPal v1.7 since it doesn't have an "Authorization accepted from PayPal" payment status. It uses "Awaiting PayPal payment". The "Authorization accepted from PayPal" wasn't added until v2.0.

[svetaines1]

Yes right! Before I use PayPal 2.0 and have problems with orders tab. After some database research I found what in some tables too many records. Now I am using PayPal 1.7.

I will try to google, maybe someone from community mad fix of PayPal module