Revisions - FogBugz Knowledge Exchange

Return to Answer

Remove unnecessary word

view source

edited Sep 13 at 23:23

James McLeod♦
2,895●1●4●10

A warning about modifying the database directly...

I had to do delete a cross-reference yesterday (I added an incorrect cross-reference to a case which had the potential to cause huge confusion). After I deleted the bad entry from the bugrelation table, I also deleted the corresponding event from the bugevent table. Unfortunately, this had been the last bugevent for the bug, and so FogBugz couldn't find the event corresponding to the ixBugEventLatest field in the bug table and refused to display it in any filters...

I used this to look for other instances where I might have inadvertently deleted the last bugevent for a bug:

SELECT b.ixBug,MAX(ixBugEvent),b.ixBugEventLatest
  FROM bug b
  JOIN bugevent e
    ON b.ixBug = e.ixBug
 WHERE (SELECT MAX(x.ixBugEvent)
          FROM bugEvent x
         WHERE x.ixBug=e.ixBug) <> b.ixBugEventLatest
GROUP BY e.ixBug;

pretty linebreaks

view source

edited Dec 18 2009 at 20:50

adambox♦♦
19.2k●12●41

A warning about modifying the database directly...

I used this to look for other instances where I might have inadvertently deleted the last bugevent for a bug:

SELECT b.ixBug,MAX(ixBugEvent),b.ixBugEventLatest
  FROM bug b
  JOIN bugevent e
    ON b.ixBug = e.ixBug
 WHERE (SELECT MAX(x.ixBugEvent)
          FROM bugEvent x
         WHERE x.ixBug=e.ixBug) <>b.ixBugEventLatest <> b.ixBugEventLatest
GROUP BY e.ixBug;

view source

answered Dec 18 2009 at 17:41

James McLeod♦
2,895●1●4●10

A warning about modifying the database directly...

I used this to look for other instances where I might have inadvertently deleted the last bugevent for a bug:

SELECT b.ixBug,MAX(ixBugEvent),b.ixBugEventLatest FROM bug b JOIN bugevent e ON b.ixBug = e.ixBug WHERE (SELECT MAX(x.ixBugEvent) FROM bugEvent x WHERE x.ixBug=e.ixBug)<>b.ixBugEventLatest GROUP BY e.ixBug;