[BUG] deleted packages cleanup doesn't work

[Minikea]

OCS Inventory version
Version : 2.11.1

Describe the bug
When you delete a package that have been deployed, you a line with "Unknown (deleted package)" on the deployment history of concerned computers

I clear this history with a SQL request :
DELETE DH FROM download_history DH LEFT JOIN download_available DA on DH.PKG_ID = DA.FILEID WHERE DA.FILEID IS NULL;
The request works and the history is cleared.
The bug is that it appeared to be temporary : the next day the lines "Unknown (deleted package)" are back.

To Reproduce
Steps to reproduce the behavior:

1. create a deployment package
2. deploy the package on some computers
3. delete the package once it is deployed successfully
4. purge the download_history from the ID of the package deleted
5. wait one day
6. the lines are back

Expected behavior
the lines stays deleted

addendum
I have these cron jobs:
/usr/share/ocsinventory-reports/ocsreports/crontab/cron_cve.php
/usr/share/ocsinventory-reports/ocsreports/crontab/cron_cve_computer.php

[Lea9250]

Hi @Minikea,

We do have a cron script in charge of clearing the history if the package has been deleted (cron_purge_history.php). However, even when using the script, I am able to reproduce the behavior you reported. We'll investigate the issue and keep you updated.

Regards,
Léa

[Lea9250]

HI @Minikea,

There is an open PR that should fix this issue on the server repository : OCSInventory-NG/OCSInventory-Server#445

If you are willing to test it, any feedback will be appreciated. Either way I will update this issue once this has been reviewed and hopefully merged.

Best regards,
Léa

[charleneauger]

Hi @Minikea,

Since the PR mentionned by @Lea9250 has been merged, I close the issue.

Best regards,
Charlene