discordianfarmer
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Hotfixes
Everything posted by discordianfarmer
-
Truncate was the magic word. After that we were able to turn off the debugging mode that had been running for who knows how long.
-
Running DELETE FROM `tblmodulelog` WHERE `date` < '2015-12-01 00:00:00' gives a total number of locks exceeds the lock table size.
-
I think I found my answer with can clear all log records from admin area, or using this SQL command:TRUNCATE `tblmodulelog`;or delete all records before March 2016DELETE FROM `tblmodulelog` WHERE `date` < '2016-03-01 00:00:00';
-
Our WHMCS tblmodulelog is over 76 GB and we do not know how to trim it to work with it properly. Is there a SQL command I can use to trim it? PHPmyadmin times out when trying to load the table.
