Uncategorized / Unable to add contacts and identities in Roundcube webmail

  • ratheesh
  • 4002 Views
  • 0 Comment
  • No tags

Roundcube mail
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`

0 Comments
Leave a comment
OUR SERVICES
OUR TECHNOLOGIES