-
- 16 Posts
I just checked my MODX evo 1.0.4's database and found that the table 'modx_event_log' has 90011 records and 258.42 MB data size - it is overly large!
What is causing the large data size?
Can I truncate the table?
-
- 953 Posts
It is large because no-one has cleared it for years
Log into the control panel: reports => system events: press "clear log"
You will probably have a lot of errors due to PHP compatibility issues, 1.0.4 doesn't support recent versions of PHP
And
Go into the control panel: reports => manager actions: press "search"
You will get a report - in the top of the report there is a link stating "empty the log file", click it and the user logs will be deleted as well
Go back to your DB and you will see that it has shrunk in size
-
- 1,118 Posts
I assume no issues in emptying the modx_event_logo from PHPMyadmin? Myn is so big it hangs the manager!
-
- 953 Posts
No, shouldn't be any problem doing so - I do it as well sometimes