Admin Dashboard timing out after update to 8.13

[auxilex]

I do not have any 3rd party modules installed on the dashboard however after updating to 8.13 the page times out. I have the max_execution_time set to 10 minutes and had no  issues prior to 8.13. The machine WHMCS is hosted on is not having any issues and all other pages in the client/admin area load properly. Any ideas as to the cause?

[WHMCS John]

Hi @auxilex,

Please can you enable the MySQL Slow Query Log, and then replicate the issue: https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html

Please share here any queries taking longer than 1 second to execute.

[File_Explorer]

Can confirm this is happening - only on the admin home page

slow query log shows the below - already opened a ticket with whmcs to see if they can sort this out because it's pretty annoying

 

select SUM((amountin - fees - amountout) / rate) from `tblaccounts` left join `tblinvoiceitems` on `tblaccounts`.`invoiceid` = `tblinvoiceitems`.`relid` and `tblinvoiceitems`.`type` = 'Invoice' where `date` between '2025-01-01 00:00:00' and '2025-12-31 23:59:59' and `tblinvoiceitems`.`id` is null limit 1;

[TheHostingHeroes]

I have this issue too!

I'm on 8.13.1

Edited Wednesday at 02:31 PM by TheHostingHeroes

[WHMCS John]

Hi @File_Explorer @TheHostingHeroes,

Some users have reported poor performance of this query is resolved by updating their MySQL server version. So please try that first.

As a workaround you can remove the /modules/widgets/Billing.php file.

[TheHostingHeroes]

we're using MariaDB 11.4 and WHM doesn't have anything newer.

i'll try removing the widget, thanks

[File_Explorer]

Removing the widget works yes, still working with someone via the ticket 

[auxilex]

4 hours ago, File_Explorer said:

Removing the widget works yes, still working with someone via the ticket 

I was hoping this would be solved in 8.13.1 but I guess not. Please post any permanent solution besides removing the widget if they find one. Thanks!