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! > 2011/10/3 <[email protected]> > > > ** > > Can anyone send me a structure of Contacts table in version 0.6 I > > upgraded to that version but have a problem with contacts. > > > > Same happened to me, added that error of session expired > > > > > During updating I received the error > > > > > > 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'] > > > > > > Thanks for help > > > > > > > > -- > > List info: http://lists.roundcube.net/users/ > > BT/d8b50aa5 > > > > > > > -- > Saludos!! > > Luciano Andino > GNU/Linux user #185103 > Santa Fe - Argentina > ----------------------------------------------- > -- List info: http://lists.roundcube.net/users/ BT/8f4f07cd
