Deleting an asset through the DB

Squiz Matrix Support
1

I need to completely remove all assets of a certain type from my system because I have messed up an upgrade. What is the best method for deleting an asset from the system when I don't know the asset ids but do know the type code?


Is there a DB Query for this?

2

[quote]
I need to completely remove all assets of a certain type from my system because I have messed up an upgrade. What is the best method for deleting an asset from the system when I don't know the asset ids but do know the type code?



Is there a DB Query for this?

[/quote]





Hi Nic,



Did you try scripts/remove_assets_of_type.php??

3

[quote]
Did you try scripts/remove_assets_of_type.php??

[/quote]



Ah, didn't realize that was there. Thank you!

4

[quote]
Ah, didn't realize that was there. Thank you!

[/quote]



Yea, quiet a few pretty handy scripts in there.

You are welcome.



Regards,



Ash