> ## Documentation Index
> Fetch the complete documentation index at: https://docs.t3planet.de/en/latest/llms.txt
> Use this file to discover all available pages before exploring further.

# Known Issues

> Faced Date field error when setting up an extension or analyzing the database?

## Resolving Date Field Error in Extension Setup and Database Analysis

**Faced Date field error when setting up an extension or analyzing the database? here is the solution!**

The problem occures because of SQL version> **sql\_modes**,

To fix this error you need to remove **NO\_ZERO\_IN\_DATE** and **NO\_ZERO\_DATE** from the sql\_modes variable.

For this operation, they need to run the below command in SQL.

```
set global sql_mode = 'ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
```

You can also fix this issues to Upgrading your MariaDB version to **>=10.5.xx**.