Horde addressbook issue after upgrade

[mrbister]

Hi!

Anyone who have tried to make a new entry into the addressbook after upgrade? I get the following error message:

Private addressbook works fine, but not "my addressbook".

Checked the db-fields and it doesn't look that good, can't find that field, but it worked before the upgrade, my best guess is that others also have the same problem - or?

-Jonas

 

[ntxmac]

Hi all
we have the same problem.

this Message appears:

"There was an error adding the new contact. Contact your system administrator for further help.DB Error: no such field"

after trying to add a contact to "My Addressbook"



Any solution yet?


thanks!

 

[botsman]

Login to mysql on 8306 port , us horde databse and execute the following commands(simply copy&paste):

ALTER TABLE turba_objects ADD COLUMN object_uid VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_freebusyurl VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_smimepublickey TEXT;
ALTER TABLE turba_objects ADD COLUMN object_pgppublickey TEXT;
ALTER TABLE horde_prefs CHANGE COLUMN pref_uid pref_uid VARCHAR(200) NOT NULL;

CREATE TABLE horde_datatree (
datatree_id INT NOT NULL,
group_uid VARCHAR(255) NOT NULL,
user_uid VARCHAR(255) NOT NULL,
datatree_name VARCHAR(255) NOT NULL,
datatree_parents VARCHAR(255) NOT NULL,
datatree_order INT,
datatree_data TEXT,
datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
datatree_updated TIMESTAMP,

PRIMARY KEY (datatree_id)
);

CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);

CREATE TABLE horde_datatree_attributes (
datatree_id INT NOT NULL,
attribute_name VARCHAR(255) NOT NULL,
attribute_key VARCHAR(255) DEFAULT '' NOT NULL,
attribute_value TEXT
);

CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree TO horde@localhost;
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree_attributes TO horde@localhost;

CREATE TABLE horde_tokens (
token_address VARCHAR(8) NOT NULL,
token_id VARCHAR(32) NOT NULL,
token_timestamp BIGINT NOT NULL,

PRIMARY KEY (token_address, token_id)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_tokens TO horde@localhost;

CREATE TABLE horde_vfs (
vfs_id BIGINT NOT NULL,
vfs_type SMALLINT NOT NULL,
vfs_path VARCHAR(255) NOT NULL,
vfs_name VARCHAR(255) NOT NULL,
vfs_modified BIGINT NOT NULL,
vfs_owner VARCHAR(255) NOT NULL,
vfs_data LONGBLOB,

PRIMARY KEY (vfs_id)
);

CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path);
CREATE INDEX vfs_name_idx ON horde_vfs (vfs_name);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_vfs TO horde@localhost;

 

[mrbister]

Thanks for the post!
Plesk support helped me with my problem so I will pass on testing your solution. Others with the same problem maybe should post here if it works (which I bet it does )

 

[DaveNET@]

Glad to see this post. I had the same problem. So might try this too.

David

 

[ntxmac]

Hi

this worked a charm for us!

Thanks for the help.

 

[belinda]

We have the same problem. If the above sql code is the solution, can somebody feom Plesk officially approve it, so we can apply without hesitation? Or, will Plesk release a hot fix, patch for this issue?

Please advise.

Thanks,

 

[tstevens]

myaddressbook error adding contact

To fix this issue Per plesk support

This issue could be fixed by running the following script \Inetpub\vhosts\webmail\horde\turba\scripts\sql\turba_objects.mysql.sql at the MySQL management of Horde database

 

[inCharge.co.uk]

Re: myaddressbook error adding contact

Originally posted by tstevens
To fix this issue Per plesk support

This issue could be fixed by running the following script \Inetpub\vhosts\webmail\horde\turba\scripts\sql\turba_objects.mysql.sql at the MySQL management of Horde database

To run this script you'd have to drop 'turba_objects' first, losing any existing data. It's interesting that the script only contains a create statement for 'turba_objects' , which implies that the rest of the SQL above (CREATE TABLE horde_datatree etc) is not necessary. I ran the first 4 'alter's on turba_objects and now the address book works. So what does the rest of the SQL do?

ALTER TABLE turba_objects ADD COLUMN object_uid VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_freebusyurl VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_smimepublickey TEXT;
ALTER TABLE turba_objects ADD COLUMN object_pgppublickey TEXT;

Cheers
Julian

 

[Cyber]

Originally posted by ntxmac
Hi all
we have a same problem.

this Message appears:

There was an error adding the new contact. Contact your system administrator for further help.DB Error: no such field

after trying to add a contact to "My Addressbook"

Any solution yet?

thanks!