View Issue Details

IDProjectCategoryView StatusLast Update
0021733mantisbtattachmentspublic2020-03-30 16:13
Reportervboctor Assigned Tovboctor  
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Product Version1.3.1 
Target Version2.23.0Fixed in Version2.23.0 
Summary0021733: Attachments should be linkable to notes in db
Description

When a user adds a note and an attachment together they should be linked in the db. We can use heuristics to link existing attachments that are upload by users within small N seconds of time they posted a note.

Tagsschema

Relationships

related to 0021727 closedvboctor Show attachments inline with notes 
has duplicate 0022262 closedatrol Including more than two attachments to a note 
has duplicate 0023261 closedatrol Reference to a note containing a file 
related to 0009802 closedvboctor Support attachments associated with private notes 
related to 0023026 new 'Edit' button on bugnotes with only attachments 
related to 0024577 closedvboctor Deleting a note, should delete associated attachments 
related to 0026098 closeddregad Update ERD diagram to reflect new field in bug_file table 
related to 0026489 closeddregad Note gets separated from attachments 
related to 0026835 closedatrol Database Server error while adding file to project 

Activities

cproensa

cproensa

2016-10-01 05:57

developer   ~0054103

I strongly suggest to normalize mantis_bug_file_table into:
file table
file relations table

The relation table should be able to link a file to a bug_id, a note_id, etc

The point about heuristics should not be included in this task, as it's not relevant once the data is linked at db level.
I mean, heuristic could be used as a tool to easily link a file to a note at upload time, but not later in time.

polzin

polzin

2017-01-05 05:00

reporter   ~0054935

This is fixed, right?

atrol

atrol

2017-01-05 05:06

developer   ~0054937

Last edited: 2017-06-16 07:37

This is fixed, right?

Not fixed, there is no link in db.
Maybe you got confused by 0021727

vboctor

vboctor

2019-07-22 01:44

manager   ~0062404

PR: https://github.com/mantisbt/mantisbt/pull/1529