Pull Request resolves # .

• I read the Generative AI policy and my contribution is either not created with the help of AI or is compatible with the policy and GNU/GPL 2 or later.

Summary of Changes

while running long (translation task from gsoc project) tasks on a site, I noticed that some runs were missing from Execution History.

The duration column of #__scheduler_logs is DECIMAL(5,3), so it can only hold up to 99.999 seconds. when a run takes 100 seconds or more saving its Execution History row fails and the error gets ignored. The task itself runs fine and its last run and exit code are updated but the run never shows up in the execcu history. This happens for both successful and failed runs.

This PR widens the column to DECIMAL(8,3) (NUMERIC(8,3) on PostgreSQL) in the install SQL and allso adds update files for existing sites.

Testing Instructions

You can use any long scheduled task that should take more than 99.999 seconds for it's execution.

Or we create a situation like that by:
1 Create a file sleep.php in the site root:

<?php
set_time_limit(0);
sleep(105);
echo 'ok';

2 then go to System -> Manage -> Scheduled tasks -> New > search and select "GET Request".
Configure it by giving an title and use URL: https://<your site>/sleep.php and leave the Request Timeout at 120. now Save&Close.

3 Click Run task on the new task. It takes about 105 seconds.
4 Open Execution History - look at rows (before and after of this PR)

Note : Apply the PR, then make sure to update DB by:
System -> Maintenance -> Database --> Update Structure, and run the task again.

Actual result BEFORE applying this Pull Request

The task finishes successfully after about 105 seconds, but Execution History shows no entry for the run.

Expected result AFTER applying this Pull Request

The run appears in Execution History with a duration of about 105 seconds.

Link to documentations

Please select:

• Documentation link for guide.joomla.org:

• No documentation changes for guide.joomla.org needed

• Pull Request link for manual.joomla.org:

• No documentation changes for manual.joomla.org needed