FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at

Posts by Fog Creek Employees are marked:

Release Notes
Network Status

HELP - Upgraded - But "No cases were found that matched"!!!!

I have upgraded to 4.0.  Before upgrading I had a number of open cases.

Open Cases Byu Project Bug|Feature|Inquiry
projectname 5 0 0
Anotherproject 13 3 0

When I select a project, or try any filter what so ever, I always get...

"No cases were found that matched"

What's wrong?

When I create a new case, it does shows up.  But I simply can not view any cases that existed before the upgrade!!
George Leithead Send private email
Tuesday, March 8, 2005
The maintenance service is rebuilding links in your database and the cases will show up.  Wait about fifteen minutes or so...

Basically right now all your bugs are joined to bugevent 1, but you manually deleted cases from your database so you are missing that bugevent.  It's a temporary situation while the maintenance services builds the correct links for each bug to its latest bugevent.

You can watch it in the registry if you like..

HKLM\Software\Fog Creek Software\FogBugz\pathtoinstall\

Look for all the *Backfill numbers.. they should go up every 15 seconds.
Michael H. Pryor Send private email
Tuesday, March 8, 2005

I am looking at the *backfill numbers, but in three hours, these numbers have not changed!

I have also checked the Maintenance Service, and it has stareted, and there are no "events" indicating that there is a problem.  I have even tried stopping and starting this service, but nothing changes!
George Leithead Send private email
Tuesday, March 8, 2005
Hi There,

I had the same problems. In my case the maintenance service didn’t work properly. Look in your data base using a SQL browser.

      Select * from bug

Look into the column named ixBugEventLatest. There shouldn’t appear the value 1.

Or better use

      select * from bug where ixBugEventLatest = 1

Should be empty an emty result.

If not the cases wouldn’t appear!!!!

To update this manually please use the command

update Bug set ixBugEventLatest = (select max (ixBugEvent) from BugEvent where Bug.ixBug = BugEvent.ixBug)

But be careful and backup your data base before.


p.s. This is based on MsSQL.
Gabriel Sieben Send private email
Thursday, March 17, 2005

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.