Pscleaner check&fix disabling PayPal currency checkbox

[bocianl]

Describe the bug

Every time after making a pscleaner check&fix PayPal payment checkbox was disabled.

Steps to Reproduce

Steps to reproduce the behavior:

1. Go to payments and check PayPal checkbox currency - is enabled.
2. Go to pscleaner and click check&fix
3. Go to payments and check that PayPal checkbox now is disabled

Movie with a problem:
https://bck2233.tinytake.com/tt/NDIwOTk2MF8xMzEyMjEyOQ

Additional information

• PrestaShop version: 1.7.6.4
• PHP version: 7.1 - 7.2
• Pscleaner module: 2.0

[prestashop-issue-bot]

Thanks for opening this issue! We will help you to keep its state consistent

[florine2623]

Hi @bocianl ,
Thanks for your report.
I manage to reproduce the issue with PS 1.7.6.4 and PS 1.7.5.2 & the ps_cleaner v2.0.0.
When we click on Check & fix for the "FUNCTIONAL INTEGRITY CONSTRAINTS" section, the preference for module PayPal gets unchecked & we have like a green alert

The following queries successfuly fixed broken data:
DELETE FROM `ps_module_currency` WHERE `id_currency` NOT IN (SELECT `id_currency` FROM `ps_currency`)
1 line(s)

I’ll add this to the debug roadmap so that it’s fixed. If you have already fixed it on your end or if you think you can do it, please do send us a pull request!
Thanks!