1. Please take a little time for this simple survey! Thank you for participating!
    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...