A forum for technical support discussion related to Fogbugz.
For some reason, I had the notion that as FB4 imports old attachments from the FileUploads folder, the attachments were deleted from disk. So:
1. Is this true?
2. If not, how can I determine when FB4 is done importing?
3. Once I find out that FB4 is done importing, can I delete the old attachments? (I know I need to keep FileUploads as a staging area.)
FogBugz should delete the attachments itself, you don't need to remove them.
Look in your registry under HKLM\Software\Fog Creek Software\FogBugz\[path to install]
for keys name
What are the keys and their values at?
The backfill keys are used to figure out what bugevent they are currently working on, and the *Stop key says what to stop at. If the normal key value > Stop key value, then it is done importing.
Well, I reset ixBugEventAttachmentBackfill to 1 based on another post in the forum, and it's up to 15581 right now. ixBugEventAttachmentBackfillStop is 175044.
But there are folders whose value is < 15581 still in the FileUploads folder, e.g. 15015, which still contain files. Should the files and folder have been removed?
Maybe you manually deleted cases from your system that had attachments. Look in the BugEvent table for that bugevent number and the corresponding ixBug. Then look in FogBugz at that ixBug number to see if that case exists. It will skip cases that have been deleted.
left outer join bug
on bugevent.ixbug = bug.ixbug
where bugevent.ixattachment <> 0
and bug.ixbug is null
There was only one such case. I've checked permissions; the same local account that runs the FogBugzMaint service has explicit full control on D:\Program Files\FogBugz4. Does the maintenance service record failed file deletions in a log?
BugEvent 15015 relates to Bug 2349, which exists in the database. I can access that case, and download its attached file.
BugEvent 15015 also relates to Attachment 1058. To make sure FB was grabbing the data from Attachment, I renamed FileUploads\15015\EPCCEM.ETX to EPCCEM.ETXq. I am still able to download the attachment.
The rescan is up to about 85000 (out of about 175000), but there still is no change in the number of files and folders in FileUploads.
This topic is archived. No further replies will be accepted.Other recent topics