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, <[email protected]> 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 <[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/e21360c6 >
-- List info: http://lists.roundcube.net/users/ BT/8f4f07cd
