Overview

Updating database tables directly (or via SQL scripts) may result in receiving API errors on the FogBugz UI.

Solution

FogBugz SQL database stores its data in multiple tables that are related to each other. For example, case data is stored in several related tables.

If these tables are not updated in sync and as per the original design, then data gets inconsistent and the FogBugz UI will not be able to display it correctly. Also, the built-in ElasticSearch search engine will not be able to process the new data.

When trying to do bulk data updates via a script we recommend using only the scripts available on the articles from our Help Center (since these are tested) or using the FogBugz API (since it provides a standardized and consistent interface).