I cleaned up my unused 1.9? osTicket by deleting all tickets and some settings. After this I upgraded it to 1.10 to start new on another focus. Now I get sometimes error-mails:
Duplicate entry '557-266-D' for key 'file-type'<br /> <br />I was afraid, that there are some zombie-records in the database. So I tried to check this:select * from osticket.ost_attachment left join (osticket.ost_file) on (osticket.ost_attachment.file_id = osticket.ost_file.id) where osticket.ost_file.id IS NULLI get no records :-(If I ask to the duplicate record (select * from `ost_attachment` where `file_id` = 266 and `type` = 'D' and `object_id` = 557) i see, that the field name is NULL, but I have more nameless records - I guess this is normal.NielsSystem-Information: