Error while importing the database?
Last updated
Last updated
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.
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.
check the link