What is the correct procedure to clean up unused plugin tables? Somehow throughout the life of our FogBugz installation we've managed to accrue a lot of plugin tables. It looks l …

Possible Duplicate: How do I delete cases? I want to clear all of the cases from my database and reset the autonumber back to 1. How can I do this easily? Or at least, ho …

Hi. I am developing a plugin where I wish to get a list of case id's (i.e. ixBug) of cases that have a certain value in a custom field. I'm thinking that the SQL could look like …

I've run into a problem with the way the wiki's are stored. To create a report of just the Wiki articles created, you have to join the revisions and wikipage tables. If each page …

Could someone post a good my.cnf / my.ini file for use with FogBugz? (see also MySQL gotchas)

I wanted to download a local copy of the FogBugz database of our FogBugz On Demand account. But after 4 hours I canceled the operation - the progress bar showed something like 5 pe …

I tried to use a COALESCE in a CBugQuery in a plugin I'm writing and FogBugz threw an exception: System.ArgumentException: Unknown function: COALESCE Since MySQL and SQL Serv …

I'm considering running FogBugz myself, but need to know how much I need to know about SQL Server or MySQL to do so safely.

MySQL seems to be bogging down. How can I find what it's spending its time on?

What has to change where in the Fogbugz 8 configuration when a database is moved from one SQL Server instance to another? Anything special needed to be done when the old DB is SQL …

I heard that FogBugz support for Microsoft Access is being deprecated. Is that true, and what does that mean?

So, here's the scenario. Everything was working fine. Then i stupidly installed AD on my server, and then un-installed it. This caused all sorts of user errors. After unsuccessfu …

Hello, I have a question about executing a specific type of SQL query through the wrapper exposed to the plugins: My plugin has a database table which contains an "ixPerson" colu …

How can you import all of your cases from another issue/bug tracker?

I resolved several cases with a 'duplicate' resolved status and entered the case of which I believed both were duplicates. A coworker disputed that the cases were duplicates. I've …