Just fyi, this is the normal upgrade procedure - you always have to run the sql queries manually when you upgrade to another major version.

On Mon, Oct 3, 2011 at 8:13 PM, <jana1972@centrum.cz> wrote:
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\', `email`=\  *'export@google.com\'*  ,
> > `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
> -----------------------------------------------
>


--
List info: http://lists.roundcube.net/users/
BT/e21360c6