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
Juerg Reimann skrev den 19-12-2012 10:36:
in order to fix this? Is there a script for PostgreSQL?
http://trac.roundcube.net/browser/github/SQL/postgres.update.sql?rev=83121ec...
search SQL/postgres.update.sql in your install
if not working still, show postgres layout as you have it
Hi Benny
Thanks, it didn't work out...the address book is still not working. This is my current db layout: http://pastie.org/5554369
-----Original Message----- From: users-bounces@lists.roundcube.net [mailto:users- bounces@lists.roundcube.net] On Behalf Of Benny Pedersen Sent: Wednesday, December 19, 2012 4:43 PM To: users@lists.roundcube.net Subject: Re: [RCU] db problem with address book
Juerg Reimann skrev den 19-12-2012 10:36:
in order to fix this? Is there a script for PostgreSQL?
http://trac.roundcube.net/browser/github/SQL/postgres.update.sql?rev=83121ec e
3348bfe09bb1026eace79a74a5ccf2c9
search SQL/postgres.update.sql in your install
if not working still, show postgres layout as you have it
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
-----Opprinnelig melding----- From: Juerg Reimann Sent: Wednesday, December 19, 2012 9:47 PM To: 'Roundcube Users mailing list' Subject: Re: [RCU] db problem with address book
Hi Benny
Thanks, it didn't work out...the address book is still not working. This is my current db layout: http://pastie.org/5554369
-----Original Message----- From: users-bounces@lists.roundcube.net [mailto:users- bounces@lists.roundcube.net] On Behalf Of Benny Pedersen Sent: Wednesday, December 19, 2012 4:43 PM To: users@lists.roundcube.net Subject: Re: [RCU] db problem with address book
Juerg Reimann skrev den 19-12-2012 10:36:
in order to fix this? Is there a script for PostgreSQL?
http://trac.roundcube.net/browser/github/SQL/postgres.update.sql?rev=83121ec e
3348bfe09bb1026eace79a74a5ccf2c9
search SQL/postgres.update.sql in your install
if not working still, show postgres layout as you have it
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2637/5470 - Release Date: 12/19/12
Juerg Reimann skrev den 19-12-2012 21:47:
Hi Benny
Thanks, it didn't work out...the address book is still not working. This is my current db layout: http://pastie.org/5554369
--- 1 2012-12-19 22:54:41.000000000 +0100 +++ postgres.initial.sql 2012-12-19 22:54:25.000000000 +0100 @@ -1,11 +1,12 @@ CREATE TABLE contacts (
NOT NULL,
ON UPDATE CASCADE, changed timestamp with time zone DEFAULT now() NOT NULL, del smallint DEFAULT 0 NOT NULL,
NULL,
NULL,
there is a diffrent to what is in 0.8.1, have you updated layout ?