Author Topic: Roundcube upgrade problem  (Read 2835 times)

Offline Jane1

  • Newbie
  • *
  • Posts: 6
Roundcube upgrade problem
« on: October 03, 2011, 11:20:51 AM »
I tried to upgrade to the latest version but it did not finish properly.
 I received this error
 
 Your configuration files are now up-to-date!
 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']
 
 
 
 Can anyone help?
 Thanks

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,855
Roundcube upgrade problem
« Reply #1 on: October 03, 2011, 11:39:42 AM »
Quote
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.

you need to update your database schema.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and moreā€¦

Offline Jane1

  • Newbie
  • *
  • Posts: 6
Roundcube upgrade problem
« Reply #2 on: October 03, 2011, 01:26:37 PM »
Thanks for the reply.
By what MySQL commands shall I issue from console to update my database schema?
Or is there a better way how to update the database schema?
 Thanks for help.( I am a newbie with roundcube)

Offline Jane1

  • Newbie
  • *
  • Posts: 6
Roundcube upgrade problem
« Reply #3 on: October 03, 2011, 02:14:10 PM »
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!