Roundcube Community Forum

I tried to upgrade to the latest version but it did not finish properly.
 I received this error
 
 Your configuration files are now up-to-date!
 WARNING: Database schema needs to be updated!
 Missing columns in table 'contacts': words
 
 Open /home/roundcube/SQL/mysql.update.sql and execute all queries below
the comment with
 the currently installed version number.
 MDB2 Error: no such field (-19): _doQuery: [Error message: Could not
execute statement]
 [Last executed query: PREPARE
 mdb2_statement_mysql_206ebea3942ba0794abf09aeec52fe83c1a87f81d FROM
'UPDATE
 contacts SET changed=now(),
`vcard`=\'BEGIN:VCARD\\r\\nVERSION:3.0\\r\\nN:
 Blak;lan;;;\\r\\nFN:LADA\\r\\nEMAIL;type=INTERNET:[email protected]\\r\\n
END:VCARD\',
 `name`=\'LADA\', `email`=\'[email protected]\', `firstname`=\'ladislav\',
`surname`=\' Bank\',
 `words`=\' lada [email protected] lan Bank\' WHERE contact_id=? AND
user_id=? AND
 del<>1']
 [Native code: 1054]
 [Native message: Unknown column 'words' in 'field list']
 
 
 
 Can anyone help?
 Thanks

QuoteWARNING: Database schema needs to be updated!
Missing columns in table 'contacts': words

Open /home/roundcube/SQL/mysql.update.sql and execute all queries below
the comment with
the currently installed version number.

you need to update your database schema.

Thanks for the reply.
By what MySQL commands shall I issue from console to update my database schema?
Or is there a better way how to update the database schema?
 Thanks for help.( I am a newbie with roundcube)

I solved the problem
I opened
/home/roundcube/SQL/mysql.update.sql and executed
ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`;
ALTER TABLE `contacts` CHANGE `vcard` `vcard` LONGTEXT /*!40101 CHARACTER SET utf8 */ NULL DEFAULT NULL;
ALTER TABLE `contactgroupmembers` ADD INDEX `contactgroupmembers_contact_index` (`contact_id`);

TRUNCATE TABLE `messages`;
TRUNCATE TABLE `cache`;

Now it seems to work GREAT!