Error while importing the database?
Last updated
Was this helpful?
Last updated
Was this helpful?
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
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.