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

Posted in ‘Joomla Little Helper support’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Saturday, 10 October 2015 09:02 UTC
socialexchange@robinspost.com
If relevant, give us some technical details to reproduce the issue you're reporting Joomla version:3.4 PHP version:5.4 Server: (apache) Server OS: (linux)   Hi, I used the little helper plugin to delete articles in trash bin but the extension did not delete the assets in the asset table for the articles. It only deleted the articles not the asset records for them.   How do I get little helper to delete the asset records for the deleted articles?   Is this possible?   I had to use the ACL manager to delete the asset records and that took me 2 weeks.   I have a large database of articles.   Please get back to me on how I can delete the asset records for the articles.   Thanks, Robin
Wednesday, 14 October 2015 07:57 UTC
hpjadmin

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)

 

Wednesday, 04 November 2015 02:40 UTC
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.