CounterSoft Community Server

Welcome to CounterSoft Community Server Sign in | Join | Help
Home Forums

Gemini 3.0 Migration Issue - Missing issue attachments

Last post 05-28-2008, 9:47 PM by papadi. 5 replies.
Sort Posts:
  •  05-12-2008, 10:33 AM

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

  •  05-12-2008, 11:24 AM

    Re: Gemini 3.0 Migration Issue - Missing issue attachments

    Thank you for posting this.

    Below is the SQL to upgrade the attachments (providing you did not delete the old schema tables):

    DELETE FROM gemini_issueattachments

    SET IDENTITY_INSERT gemini_issueattachments ON

    INSERT INTO gemini_issueattachments (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 gemini_issues)

    AND ( commentid IN (SELECT commentid FROM gemini_issuecomments) OR commentid = 0)

    SET IDENTITY_INSERT gemini_issueattachments OFF

     

  •  05-12-2008, 11:32 AM

    Re: Gemini 3.0 Migration Issue - Missing issue attachments

    Looks good, thx :)
  •  05-28-2008, 4:18 PM

    Re: Gemini 3.0 Migration Issue - Missing issue attachments

    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!!!
  •  05-28-2008, 9:36 PM

    Re: Gemini 3.0 Migration Issue - Missing issue attachments

    This has been fixed for 3.0.1, which has been released earlier today.
  •  05-28-2008, 9:47 PM

    Re: Gemini 3.0 Migration Issue - Missing issue attachments

    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!
View as RSS news feed in XML