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 jana1972@centrum.cz
** 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: *export@google.com \r\n* END:VCARD',name='LADA',firstname='ladislav',surname=' Bank',words=' lada *export@google.com* 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