Since day one of my XenForo installation , I have been facing this error.
I have tried everything :
and what not.
Every few hrs the user_id column goes missing automatically.
I have to restore backups all the time :(
I would appreciate some...
Can anyone help me with a simple mySQL command to grab 10 mod logs from the last 24 hrs from the xenforo DB?
I just need to do a basic script so that the mods can see the logs themselves (only number of actions they have performed).
I wish to delete the following:
1. Soft Deleted Threads
2. Mod logs
3. Admin logs
and other unwanted logs/old Pms which could keep the database size low for backups :)
I would appreciate some help!
I have just converted my vBulletin board to XenForo
I have been having problems with my session_activity table (MEMORY TABLE).
It has overheads on the table and every few hrs, it goes empty (Queries start building up up in mySQL process list : Copying to tmp table) leading to downtime with...