tool_excimer\tool_excimer_purge_page_group_test::test_purge - Excimer failing in unittest

[MichaelReyesCatcan]

Reporting this issue causing unit test failure. Due to having two entries with the same month and year. This error occurred because we are on the 29th day of August. When it went 7 months before it is retrieving March instead of February. Maybe the 29th of February is causing an issue.

There was 1 error:

1) tool_excimer\tool_excimer_purge_page_group_test::test_purge
dml_write_exception: Error writing to database (ERROR:  duplicate key value violates unique constraint "phpu_toolexcipagegrou_namm_uix"
DETAIL:  Key (name, month)=(, 202403) already exists.
INSERT INTO phpu_tool_excimer_page_groups (month,fuzzydurationcounts) VALUES($1,$2) RETURNING id
[array (
  'month' => 202403,
  'fuzzydurationcounts' => '',
)])

/var/www/site/lib/dml/moodle_database.php:497
/var/www/site/lib/dml/moodle_read_slave_trait.php:293
/var/www/site/lib/dml/pgsql_native_moodle_database.php:341
/var/www/site/lib/dml/pgsql_native_moodle_database.php:1132
/var/www/site/lib/dml/pgsql_native_moodle_database.php:1180
/var/www/site/admin/tool/excimer/tests/tool_excimer_purge_page_group_test.php:59
/var/www/site/lib/phpunit/classes/advanced_testcase.php:80

[glepod]

Bug in PHP strtotime()
https://www.php.net/manual/en/function.strtotime.php#128577