ucm_history table

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Locked
JohnWi
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 176
Joined: Mon Jan 30, 2012 11:02 am

ucm_history table

Post by JohnWi » Tue Mar 31, 2015 7:52 pm

Hi.

Might someone explain to me what "ucm_history" is in the Joomla" database?

Can I truncate it without problem?

Thanks

User avatar
NathanHawks
Joomla! Ace
Joomla! Ace
Posts: 1900
Joined: Wed Oct 02, 2013 6:17 pm
Location: Washington state, U.S.
Contact:

Re: ucm_history table

Post by NathanHawks » Tue Mar 31, 2015 7:54 pm

There is a new feature, revision history, which lets you undo a change to your articles. It is enabled via Article Manager -> Options. The ucm_history table contains previous versions of articles. Truncating that table will simply remove your ability to roll-back articles to those versions you have previously stored; they will be replaced (new entries will appear in ucm_history) if you truncate the table but resume working on your site without disabling the feature. If you want to keep it from regrowing, turn off that feature.
Save time - hire me for your Joomla to-do list! http://nathanhawks.us/joomla

User avatar
changlee
Joomla! Explorer
Joomla! Explorer
Posts: 389
Joined: Tue Nov 20, 2007 11:05 am
Location: Greece
Contact:

Re: ucm_history table

Post by changlee » Tue Aug 25, 2015 7:41 am

And if I disable the revision history, how can I clear that table.

It is 150MB !
If you do not programm your life, someone else will do it for you.
SMTP Newsletter APP: https://www.emailbat.com

benedictford
I've been banned!
Posts: 19
Joined: Wed Oct 21, 2015 3:00 pm
Contact:

Re: ucm_history table

Post by benedictford » Fri Oct 23, 2015 10:12 pm

I have a strong suspicion you can only do that manually?

User avatar
changlee
Joomla! Explorer
Joomla! Explorer
Posts: 389
Joined: Tue Nov 20, 2007 11:05 am
Location: Greece
Contact:

Re: ucm_history table

Post by changlee » Wed Oct 28, 2015 1:57 pm

Yes, I sent it to black hole :-)
If you do not programm your life, someone else will do it for you.
SMTP Newsletter APP: https://www.emailbat.com


Locked

Return to “General Questions/New to Joomla! 3.x”