The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Horde Address Book Add Entry Error

Discussion in 'General Discussion' started by trparky, Sep 13, 2005.

  1. trparky

    trparky Well-Known Member

    Joined:
    Apr 23, 2003
    Messages:
    184
    Likes Received:
    1
    Trophy Points:
    0
    Whenever we try to add a new entry to a Horde Address Book, we get this error message.
    There was an error adding the new contact. Contact your system administrator for further help.DB Error: no such field

    This is the structure of the turba_objects database table.

    CREATE TABLE `turba_objects` (
    `object_id` varchar(32) NOT NULL default '',
    `owner_id` varchar(255) NOT NULL default '',
    `object_name` varchar(255) default NULL,
    `object_alias` varchar(32) default NULL,
    `object_email` varchar(255) default NULL,
    `object_homeaddress` varchar(255) default NULL,
    `object_workaddress` varchar(255) default NULL,
    `object_homephone` varchar(25) default NULL,
    `object_workphone` varchar(25) default NULL,
    `object_cellphone` varchar(25) default NULL,
    `object_fax` varchar(25) default NULL,
    `object_title` varchar(255) default NULL,
    `object_company` varchar(255) default NULL,
    `object_notes` text,
    `object_type` varchar(255) NOT NULL default 'Object',
    `object_members` blob,
    PRIMARY KEY (`object_id`),
    KEY `turba_owner_idx` (`owner_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    Any ideas?

    We do have a ticket open with Cpanel, so if a tech that walks these forums wants the ticket number, I will give it to them.
     
  2. anton_latvia

    anton_latvia Well-Known Member
    PartnerNOC

    Joined:
    May 11, 2004
    Messages:
    348
    Likes Received:
    3
    Trophy Points:
    18
    Location:
    Latvia
    cPanel Access Level:
    Root Administrator
    Hi,
    did you solve this problem?

    Anton
     
  3. trux

    trux Registered

    Joined:
    Oct 8, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Possible fix for address book add entry error

    Hello,

    I had the same problem on our servers. Did a little research and noticed that the fields on the new add.php page don't match the fields in table turba_objects. I was able to fix the error by adding the following 4 columns to turba_objects. I'm not 100% sure this is the only thing that needs to be done, but so far just adding these columns has gotten things working on two of our Cpanel server. Hopes this helps!

    Added the following columns to table turba_objects:

    object_pgppublickey text Yes NULL
    object_smimepublickey text Yes NULL
    object_freebusyurl varchar(255) Yes NULL
    object_uid varchar(255) Yes NULL


    I-Tul
    Design & Software
    http://www.i-tul.com
     
  4. trux

    trux Registered

    Joined:
    Oct 8, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    possible fix

    OK. After my last post I thought the actual SQL I used might be more helpful. So, here it is:

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



    I-Tul
    Design & Software
    http;//www.i-tul.com
     
Loading...

Share This Page