View Revisions: Issue #21994

Summary 0021994: issue with attachments cannot be moved between projects with different upload directories (uploads saved in file system)
Revision 2016-11-30 11:24 by dregad
Description

I use file system based attachment uploads.

When attempting to move an issue with attachments between projects with different upload directories I see:

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0001064: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 for the query: 
UPDATE mantis_bug_file_table
SET folder=?
WHERE bug_id=?
AND id =?.

After pressing the back button,
a) the bug still resides in the source project
b) the first attachment of the issue is displayed strike through and marked "(Attachment missing)"
c) the stored attachment file on the file system has actually been moved to the upload Folder of the destination project

[EDIT: breaking long line to avoid scrolling]

Revision 2016-11-30 10:20 by tk
Description

I use file system based attachment uploads.

When attempting to move an issue with attachments between projects with different upload directories I see:

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0001064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 for the query: UPDATE mantis_bug_file_table
SET folder=?
WHERE bug_id=?
AND id =?.

After pressing the back button,
a) the bug still resides in the source project
b) the first attachment of the issue is displayed strike through and marked "(Attachment missing)"
c) the stored attachment file on the file system has actually been moved to the upload Folder of the destination project