Horde Address Book Error

If you face this error in Adding email addresses in your Horde address book and you receive this error "There was an error adding this object. Contact your system administrator for further help."

Then try this Fix as it is provided by Cpanel support itself.

To correct the problem with the Horde address book not working correctly, you will need to SSH into your server as root, and type "mysql" to get a mysql prompt. Enter the following queries, and your problem should be fixed:

CREATE TABLE horde.turba_objects (object_id varchar(32) PRIMARY KEY,owner_id varchar(255),object_name varchar(255),object_alias varchar(32),object_email varchar(255),object_homeAddress varchar(255),object_workAddress varchar(255),object_homePhone varchar(25),object_workPhone varchar(25),object_cellPhone varchar(25),object_fax varchar(25),object_title varchar(32), object_company varchar(32),object_notes text); insert into mysql.tables_priv values("%","horde","horde","turba_objects","root@localhost",now()+0,"Select,Insert,Update,Delete",""); flush privileges;


It worked like a charm for me on one of My server.

=====================================================================================
If you are unable to login to the horde showing you following error :

A fatal error has occurred:

DB Error: connect failed

[line 108 of /usr/local/cpanel/base/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.


And horde DB is missing from mysql,

Then :

To create horde db in mysql use following command.

$>mysql < /usr/local/cpanel/base/horde/scripts/db/create_mysql.sql

Then run

$>/scripts/resethorde
$>/scripts/fullhordereset