FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

Fogbugz database indexes on fogbugz.Bug

I was hoping to write some reports using the instructions outlined in the using Access with Fogbugz documentation ( http://www.fogcreek.com/FogBugz/kb/howto/AccessReports.html )

Unfortunately, MS Access is puking as there is apparently a limit on number of indexes assigned to a given table.

In this case, Access' limit is 32, and the table has 60.

Are all 60 indexes needed (ie, do I need to use something other than Access) or is there a problem with my table?

I can post the list of indexes if anyone wants/needs to see them.
Joey Send private email
Monday, October 19, 2009
 
 
Hi Joey,

JohnFx suggests using a view on the Bug table so you don't have to remove any of the indices:

http://fogbugz.stackexchange.com/questions/309/create-reports-using-microsoft-access/339#339
Jacob Krall Send private email
Monday, October 19, 2009
 
 
Thanks for the update, that worked perfectly.

We run a MySQL database, and I used the following sql to create my view (for anyone else that might use it)

create view vwBug as select * from fogbugz.Bug;

I was then able to import/link that table into Access.

Thanks,

joey
Joey Send private email
Tuesday, October 20, 2009
 
 

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.