Just fyi, this is the normal upgrade procedure - you always have to run the sql queries manually when you upgrade to another major version.
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> > *export@google.com
> > 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:
> > \\r\\n*
> > END:VCARD\',
> > `name`=\'LADA\', `email`=\ *'export@google.com\'* ,
> > `firstname`=\'ladislav\',> > `words`=\' lada *export@google.com* lan Bank\' WHERE
> > `surname`=\' Bank\',
> > contact_id=?BT/e21360c6
> > 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/