Re: [RCU] Structure of Contacts table in the latest Roundcube

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