Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Gemini 3.0 Migration Issue - Missing issue attachments

web-app

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
Morty
Replies (5)
helpful
0
not helpful

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

 


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Looks good, thx :)


Morty
· 1
Morty
helpful
0
not helpful

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!!!


papadi
· 1
papadi
helpful
0
not helpful

This has been fixed for 3.0.1, which has been released earlier today.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

This is unacceptable!
I discovered today that my attachments are missing, 1 week after migrating. It took my 1 hour to fix this by partially migrating the missing recors from a backup I kept!
You should have fixed the problem right after it came to your attention!


papadi
· 1
papadi