When adding a new contact in Roundcube webmail, if you obtain the following error:
An error occured while saving
You can check for the error in the Roundcube log files:
tail -f /var/log/roundcube/errors
If you encounter the following error message
MDB2 Error: no such field (-19): _doQuery: [Error message:
Could not execute statement] [Last executed query: INSERT INTO contacts (user_id, changed, del, `vcard`, `name`,
`email`, `firstname`, `surname`, `words`) VALUES ...
[Native code: 1054] [Native message: Unknown column 'words' in 'field list']
field “words” does not exist in the table “contact” in roundcube’s database. You can fix the issue by inserting the missing field in roundcube’s database using the following command
ALTER TABLE `contacts` ADD `words` VARCHAR( 500 ) NULL DEFAULT NULL
If the error occurs when saving a new identity (which is because of a missing field “changed” in the table “identities”), you can use the following command to fix it.
ALTER TABLE `identities` ADD `changed` DATETIME NOT NULL DEFAULT ‘1000-01-01 00:00:00’ AFTER `identity_id`