⚠️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

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 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