Gemini 3.0 Migration Issue - Missing issue attachments
Attachments that don't have commentids are not beeing migrated. I have quite a few attachements where the commentid is 0.
From the looks of it, these should migrated as NULL...
Morty
· 1 |
|
Monday, May 12, 2008, 11:33:04 AM |
0
|
Thank you for posting this. Below is the SQL to upgrade the attachments (providing you did not delete the old schema tables): DELETE FROM geminiissueattachments SET IDENTITYINSERT geminiissueattachments ON INSERT INTO geminiissueattachments (fileid, projectid, issueid, commentid, contenttype, contentlength, thefilename, filecontent, created) SELECT fileid, projid, issueid, CASE WHEN commentid = 0 THEN NULL ELSE commentid END, contenttype, contentlength, thefilename, filecontent, created FROM issueattachments WHERE issueid IN (SELECT issueid FROM geminiissues) AND ( commentid IN (SELECT commentid FROM geminiissuecomments) OR commentid = 0) SET IDENTITYINSERT geminiissueattachments OFF
|
||||
|
0
|
Looks good, thx :) |
||||
|
0
|
I understand that we are talking about a major bug in migration script here. And it seems that this fix is still not applied in the download package available. This means that people who download version 3 even today will lose data during migration!!! |
||||
|
0
|
This has been fixed for 3.0.1, which has been released earlier today. |
||||
|
0
|
This is unacceptable! |
||||
|