Bugfix/purgeengine regex

[alfredosilvestre-natixis]

Description

When running the cron script to purge centstorage data, the partitions are not being detected.

This is fixed on the regex that has extra backticks and does not recognize properly the values for the last created partition.

Fixes #11122

Type of change

• [x] Patch fixing an issue (non-breaking change)
• [ ] New functionality (non-breaking change)
• [ ] Breaking change (patch or feature) that might cause side effects breaking part of the Software
• [ ] Updating documentation (missing information, typo...)

Target serie

• [x] 20.10.x
• [x] 21.04.x
• [x] 21.10.x
• [x] 22.04.x (master)

How this pull request can be tested ?

1. On any install execute the script : /usr/share/centreon/cron/centstorage_purge.php
2. The log should show many entries with "Partition will be delete"

Checklist

• [x] I have followed the coding style guidelines provided by Centreon
• [ ] I have commented my code, especially new classes, functions or any legacy code modified. (docblock)
• [ ] I have commented my code, especially hard-to-understand areas of the PR.
• [ ] I have made corresponding changes to the documentation.
• [x] I have rebased my development branch on the base branch (master, maintenance).

[lpinsivy]

hi @alfredosilvestre-natixis can you rebase your branch because this PR include more than 500 commit O_O

[alfredosilvestre-natixis]

Hello, sorry there was some issue with the github online edit, it should be ok now 😄

[lpinsivy]

thank you @alfredosilvestre-natixis.

To help us to test, on which DBMS and version did you have this problem?

[alfredosilvestre-natixis]

Yes of course, we are using MySQL 8.0.21-commercial Enterprise Server, Centreon version centreon-web-21.10.7-1.el8.noarch

This is the same issue as #10591

[sonarqube-decoration[bot]]

SonarQube Quality Gate

10 Bugs
0 Vulnerabilities
0 Security Hotspots ( 100.0% reviewed)
3344 Code Smells

0.0% Coverage
4.3% Duplication