I experienced a bug with the Asset extension. When you find assets by name,
when you press the bulk update button and change one value, the name of the
search gets assigned to all assets.
Having found this, i wanted to delete all assets and reinsert them. So i
changed their status to deleted and tried again but got an error with the
asset import csv extension.
So then i did a very foolish thing, and went over mysql and deleted the
assets i wanted from the RTxAssets table.
When i want to import them again, i now get all kinds of errors regarding
 [Thu Oct 16 18:33:17 2014] [error]: Couldn’t create role groups for
asset 14504 (/opt/rt4/local/plugins/RT-Extension-Assets/lib/RT/Asset.pm:275)
 [Thu Oct 16 18:33:17 2014] [error]: Failed to create asset for row
303: Couldn’t create role groups for asset
 [Thu Oct 16 18:36:53 2014] [error]: Couldn’t create a role group of
type ‘Owner’ for RT::Asset 18517: Role group exists already
So i guess that means i need to delete those roles manually as well, but i
haven’t been able to find the table for that. Can someone give me a hint?
View this message in context: http://requesttracker.8502.n7.nabble.com/Issue-when-deleting-Assets-and-recreating-with-roles-tp58863.html