> For the complete documentation index, see [llms.txt](https://docs.docbits.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.docbits.com/administration-and-setup/settings/global-settings/document-types/table-columns/troubleshooting-1.md).

# Troubleshooting

## Here are solutions to common problems related to table column configurations:

**Incorrect column configurations:**

* **Problem:** Data is not displayed or stored correctly, possibly due to incorrect data types, missing constraints, or insufficient column names.
* **Solution:**

  Review the column configurations in the database table and make sure the data types are appropriate for each column.

  Add missing constraints such as NOT NULL or UNIQUE to improve data integrity.

  Rename columns to use more meaningful and unique names that accurately describe the column's contents.

**Problems caused by deleted columns:**

* **Problem:** After deleting a column from a table, problems occur because reports, queries, or application logic still reference that column.
* **Solution:**

  Review all reports, queries, and application logic to make sure there are no more references to the deleted column.

  Update all affected reports, queries, and application logic to reflect or remove the deleted column. If necessary, temporarily restore the deleted column and migrate the data to a new structure before permanently deleting it.

**Missing or inconsistent data:**

* **Problem:** Data is incomplete or inconsistent due to missing required fields or incorrect data types.
* **Solution:**

  Review the table structure and make sure all required fields are marked NOT NULL to ensure that important data is not missing.

  Perform data cleanup to correct inconsistent or invalid data and update data types if necessary to improve consistency.

**Performance issues due to missing indexes:**

* **Problem:** Queries on large tables are slow because important columns are not indexed.
* **Solution:**

  Identify the most frequently queried columns and add indexes to improve query performance.

  Be aware that too many indexes can also affect write and update performance, so balanced indexing is important.

By applying these solutions, you can resolve common table column-related issues and improve the efficiency, consistency, and performance of your database.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.docbits.com/administration-and-setup/settings/global-settings/document-types/table-columns/troubleshooting-1.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.