Can't delete attachments

[Darksome]

filedataid	userid	DateLine	Thumbnail_Dateline	filesize	filehash	thumbnail_filesize	extension	importattachmentid	width	height	thumbnail_width	thumbnail_height	refcount
1	6	2009-07-04 01:15:23	2011-06-03 14:04:05	233801	a5098d77bf2f3fbf6e1cf11bbdbd5ae8	3107	jpg	15	0	0	0	0	0
2	19	2009-07-04 01:21:04	2011-06-03 14:04:05	305219	623fb0da0a16d7adca2d6d149a433ef9	4254	jpg	16	0	0	0	0	0
3	19	2009-07-04 01:29:36	2011-06-03 14:04:05	290635	89f500a25380dad3743fcf734ecc2906	4753	jpg	17	0	0	0	0	0
4	16	2009-07-04 01:39:34	2011-06-03 14:04:05	247151	ffb579b2813e3d868fda6354f25bc5ce	2998	jpg	18	0	0	0	0	0
6	13	2009-07-04 01:50:53	2011-06-03 14:04:05	57116	07de7cc6d732a91aafbb893beff7b40f	2935	jpg	20	0	0	0	0	0
7	6	2009-07-04 01:51:14	2011-06-03 14:04:05	200844	38ab8caf2e89fc5c1e1671dfe1ec0b9e	4597	jpg	21	0	0	0	0	0
8	32	2009-07-04 03:19:08	2011-06-03 14:04:05	183249	7ad2cef18ca3de001d2a9215a972617e	3233	jpg	22	0	0	0	0	0
9	32	2009-07-04 03:35:00	2011-06-03 14:04:05	186845	a4a083e2ba9ce375d0918e6fb943bbb9	5542	jpg	23	0	0	0	0	0
10	32	2009-07-04 03:42:53	2011-06-03 14:04:05	143642	9f71ffd857c1536157e059f1b1aa40ac	3303	jpg	25	0	0	0	0	0

Here's the first 10 entries from that query. I've tried dropping the importattachmentid column and it made no difference.

[Andy]

Install a test forum which is complete stock. Use phpmyadmin and compare the filedata structure between the stock forum and your forum. Also compare the attachments table structure between the two.

[AusPhotography]

@Darksome... that data looks ok, and they *should* delete. Ticket time

[Steve Machol]

I could not duplicate this problem on an unmodified 4.1.5 test forum with no add-ons. When I permanently deleted a post with an attachment, the attachment file was also removed from the file system. I did a before and after list of the directory to confirm this.

[monet]

I was trying to figure out how to Delete Attachments as well and came upon this thread. I'm running 4.1.5 so maybe it may not apply for other VB versions, but I found a simpler way to delete attachments after uploading it. Apparently it is not as easy as clicking the box on the attachment and "X"ing it out because there's no "X".

Admin CP > Attachments > Attachment Statistics > (from there you can locate who is attaching the largest/most files...could be yourself) > delete