⚠️Error while importing the database?

If you get BLOB/TEXT column ‘whatsapp_enable_for’ can’t have a default value program ‘mysql’ finished with non-zero

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

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 whatsapp_enable_for fields from restaurant_list table from the database then import the database. After import the database successfully add the field manually whatsapp_enable_for LONGTEXT NULL. Using this method, you have to enable WhatsApp from login as restaurant > WhatsApp configuration.

Last updated

Was this helpful?