# 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="https://2146617913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mj2njUbC19wDVDUSjgT%2Fuploads%2FkunPDPIeGFhIb9VPaf97%2FScreenshot_4.png?alt=media&#x26;token=82ec446d-f535-4473-967b-4b83c62bae9b" 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](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.
