Hi everybody
Ever since I upgraded to the 0.8x version I get the following error when I want to add something to the address book:
Dec 18 10:37:38 mailsrv roundcube: [ID 702911 user.notice] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement] Dec 18 10:37:38 mailsrv roundcube: [ID 702911 user.error] DB Error: MDB2 Error: no such field Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO contacts (user_id, changed, del, "vcard", "name", "email", "firstname", "surname", "words") VALUES (2, now(), 0, 'BEGIN:VCARD VERSION:3.0 N:test;test;;; FN:test test EMAIL;TYPE=INTERNET;TYPE=HOME:test@test.com END:VCARD', 'test test', 'test@test.com', 'test', 'test', ' test test@test.com')] [Native message: ERROR: column "words" of relation "contacts" does not exist LINE 1: ..."vcard", "name", "email", "firstname", "su in /path/to/program/include/rcube_mdb2.php on line 727 (POST /?_orig_source=0?_task=addressbook&_action=save) Dec 18 10:37:38 mailsrv roundcube: [ID 702911 user.notice] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
It seems that during the upgrade process the additional tables or relations to the database were not created. What do I have to create in order to fix this? Is there a script for PostgreSQL?
Thanks, Juerg