fix potential error in reports purge query #16988

Description:

should fix https://github.com/matomo-org/matomo/issues/16978

Thought it was a PHP 8 issue but looks like it's actually always been a bug maybe. I tweaked the code to reproduce this but in the end I think it happens maybe when you enable report purging but don't keep any periods or so.

Noticed must be this query because it says: near &<a href='/039'>#039</a>;AND idarchive &gt;= ? AND idarchive &lt; ?&<a href='/039'>#039</a>; at line 3',

Review

• [ ] Functional review done
• [ ] Usability review done (is anything maybe unclear or think about anything that would cause people to reach out to support)
• [ ] Security review done see checklist
• [ ] Code review done
• [ ] Tests were added if useful/possible
• [ ] Reviewed for breaking changes
• [ ] Developer changelog updated if needed
• [ ] Documentation added if needed
• [ ] Existing documentation updated if needed

I can confirm this solved the errors, many thanks!