auxilex Posted May 21 Share Posted May 21 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? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted May 22 WHMCS Support Manager Share Posted May 22 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. 0 Quote Link to comment Share on other sites More sharing options...
File_Explorer Posted June 4 Share Posted June 4 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; 0 Quote Link to comment Share on other sites More sharing options...
TheHostingHeroes Posted June 4 Share Posted June 4 (edited) I have this issue too! I'm on 8.13.1 Edited June 4 by TheHostingHeroes 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted June 4 WHMCS Support Manager Share Posted June 4 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. 0 Quote Link to comment Share on other sites More sharing options...
TheHostingHeroes Posted June 4 Share Posted June 4 we're using MariaDB 11.4 and WHM doesn't have anything newer. i'll try removing the widget, thanks 0 Quote Link to comment Share on other sites More sharing options...
File_Explorer Posted June 4 Share Posted June 4 Removing the widget works yes, still working with someone via the ticket 0 Quote Link to comment Share on other sites More sharing options...
auxilex Posted June 4 Author Share Posted June 4 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! 0 Quote Link to comment Share on other sites More sharing options...
Kailash Posted Monday at 01:31 PM Share Posted Monday at 01:31 PM Any fix available without removing that file? 0 Quote Link to comment Share on other sites More sharing options...
sahostking Posted Monday at 07:04 PM Share Posted Monday at 07:04 PM same issue with us. I upgraded mariadb from 10.6 to 11 which is the latest and still the same issue. So I had to rename the billing.php file so long until they resolve this or provide a hotfix. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.