1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Horde addressbook issue after upgrade

Discussion in 'Plesk for Windows - 8.x and Older' started by mrbister, Jun 30, 2005.

  1. mrbister

    mrbister Guest

    0
     
    Hi!

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

    [​IMG]

    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
     
  2. ntxmac

    ntxmac Guest

    0
     
    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!
     
  3. botsman

    botsman Guest

    0
     
    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;
     
  4. mrbister

    mrbister Guest

    0
     
    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 :))
     
  5. DaveNET@

    DaveNET@ Guest

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

    David
     
  6. ntxmac

    ntxmac Guest

    0
     
    Hi

    this worked a charm for us!

    Thanks for the help.
     
  7. belinda

    belinda Guest

    0
     
    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,
     
  8. tstevens

    tstevens Guest

    0
     
    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
     
  9. inCharge.co.uk

    inCharge.co.uk Guest

    0
     
    Re: myaddressbook error adding contact

    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
     
  10. Cyber

    Cyber Guest

    0
     
     
Loading...