Warning
You do not have a menu item pointing to the list all Akeeba Ticket System categories for the English (United Kingdom) language. Ticket links may be broken until you add such a menu item.
#1029 – Asset Table Feature
![](https://secure.gravatar.com/avatar/e90166f238861b05fd100476feecf4a8.jpg?s=64&d=mm)
![](https://secure.gravatar.com/avatar/4e6cac3aa64eb2fe5cc0eb572b6e0226.jpg?s=64&d=mm)
Hello Robin,
this is quite strange. LittleHelper first asks Joomla to clear the recycled items; if that fails, it then proceeds to delete assets and related articles. So either way the assets should get deleted.
Before deleting anything, a .sql backup file is stored in the /tmp folder; there you can see what was deleted and have a list of all the ids. Additionally, the deleted ids are stored in the error log.
I have made a note to check the delete feature, but it will be handled in approx three weeks as we're delivering a large project now.
This will not solve your issue though; as I understand you still have tons of assets that match nothing: those can be removed with a lot of caution with direct database access, use something like this: select the third word in the dot-separated asset column 'name', i.e. the article id, and LEFT JOIN the articles table (#__content), and select the ASSETS that have no corrensponding article. The selection substring is repeated for your convenience
SELECT a.id AS ASSET_ID, a.name, SUBSTRING_INDEX(SUBSTRING_INDEX(a.name, '.', 3), '.', -1) as articleId, c.id
FROM `#__assets` AS a
LEFT JOIN
`#__content` as c
ON c.id=SUBSTRING_INDEX(SUBSTRING_INDEX(a.name, '.', 3), '.', -1)
WHERE a.name like '%content%' and a.name like '%article%' AND isnull(c.id)
![](https://secure.gravatar.com/avatar/a6aaaaf5d124132f358752c7d72d4b44.jpg?s=64&d=mm)