Does anyone know what these rows are for?

Is it safe to remove them? Since they seem to be mostly empty?

Note: this is assets table!

enter image description here

  • why you want to remove them?
    – FFrewin
    Dec 29, 2015 at 14:07
  • @FFrewin I've removed 100,000 articles and 80,000 tags. I thought I would give an assets table a clean too :)
    – user6981
    Dec 29, 2015 at 15:47
  • I have added an answer - with a few updates that most likely will answer your question.
    – FFrewin
    Dec 29, 2015 at 16:27

2 Answers 2


@Salivan, I see why you want to remove those assets now. Just curious: how did you remove the articles and tags? via database or within Joomla?

Now to remove the assets, you should make sure that these are orphaned ones and are not relating to current data.

If you have removed everything then you could clear these assets as well - but first backup the table in case something breaks.

If those assets are related to articles that are still in the db, then you shouldn't delete them. If you try to do this manually then there will be work, as you will have to deal with finding tags and articles that are still there.

You might have some better luck by using the ACL_MANAGER component, which deals with fixing assets - it might be able to remove those orphaned assets.

You can ask the developer if the extension is able to remove those particular orphaned assets, before purchase.


Actually, I did a quick test with aclmanager to see if it deals with the assets for content-items and tags: added a tag to an article, then deleted the tag and the article within Joomla admin, run the acl_manager extension, but the corresponding assets is still in the db.

So I guess some kind of "manual" approach should be followed in order to clear those assets.

Update 2:

I have some better news, regarding the assets. They are able to be recreated if they do not exist, for any remaining articles/tags. So, if you delete all the assets of type #__ucm_content.xxx, even for articles/tags that exist, they can be recreated by doing re-saving the articles - or doing some kind of batch changing (.e.g change category for many articles).

So, I would suggest, in a test environment, you can do your trials with these and work on the database to see how things go.

  • I removed articles and tags via cli tool I wrote, it uses J models... from gui it would be impossible to delete so many articles without going crazy.
    – user6981
    Dec 29, 2015 at 22:45
  • I deleted all articles and tags btw.
    – user6981
    Dec 29, 2015 at 22:45
  • @salivan, Then you can just delete those #__ucm_content entries from the assets table.
    – FFrewin
    Dec 30, 2015 at 7:09

The #__ucm_content database table is used to store tags for core extensions, so I would not remove them, else you may get an error along the line in the future.

See more information tags with extensions here:


hope this helps

  • this is in assets table not _ucm_content
    – user6981
    Dec 29, 2015 at 10:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.