> For the complete documentation index, see [llms.txt](https://phplime-envato.gitbook.io/qrexorder/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://phplime-envato.gitbook.io/qrexorder/error-while-importing-the-database.md).

# Error while importing the database?

<mark style="color:red;">If you get BLOB/TEXT column ‘</mark><mark style="color:red;">**whatsapp\_enable\_for’**</mark> <mark style="color:red;"></mark><mark style="color:red;">can’t have a default value program ‘mysql’ finished with non-zero</mark>

The error gets because your MySQL / database doesn't support Default JSON format.

Then you have to remove all strict mode and have to set&#x20;

<figure><img src="/files/3wTI0dVseaboPPjf5ibX" alt=""><figcaption></figcaption></figure>

```sql
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
```

If you can't remove, then contact to you hosting provider they will remove it.

check the link <https://stackoverflow.com/questions/38433603/mysql2error-blob-text-geometry-or-json-column-body-cant-have-a-default-v>

## **Solution 2**:

Remove <mark style="color:red;">**whatsapp\_enable\_for**</mark> fields from restaurant\_list table from the database then import the database. After import the database successfully add the field manually <mark style="color:red;">**whatsapp\_enable\_for**</mark>   LONGTEXT NULL.\
Using this method, you have to enable WhatsApp from login as restaurant > WhatsApp configuration.