Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed: Field 'password' doesn't have a default value

[Lefteris Tsintjelis via dovecot]

Hi, after upgrading my database I kept on getting those errors. It seems 
like later versions of databases have strict mode enabled by default and 
it must either be disabled or change the dovecot database schema. 
Besides the password, would anyone know what other fields must be 
changed to the dovecot schema and have a default value? Is there any 
other dovecot schema for strict mode?

Lefteris