Horde Address Book Error

[jpfour23]

I can't figure out why I can't post address's in the address book... I use Horde Email setup by Cpanel. When I submit to add an address entry I get the following error:

There was an error adding this object. Contact your system administrator for further help.

Can anyone help?

Thanks!!
JP

cPanel.net Support Ticket Number:

[nickn]

We are experencing the same problem, have opened a ticket (ticket # 19558)

cPanel.net Support Ticket Number:

[jpfour23]

Sorry.. I way new here. Where do you post tickets and how do you view them.

Thanks,
JP

cPanel.net Support Ticket Number:

[nickn]

http://www.cpanel.net under support there is a option for opening up support tickets.

cPanel.net Support Ticket Number:

[jpfour23]

I don't see anything about support tickets.... i see a place for bugs... is that what you are referring to?

Excuse my ignorance.

JP

cPanel.net Support Ticket Number:

[nickn]

Support Request Form link.

cPanel.net Support Ticket Number:

[jpfour23]

anyone heard anything new about this??

cPanel.net Support Ticket Number:

[hostit1]

I am having the same problem. Can't create an contact in the address book. At one time it worked, then it just stopped. Maybe from a Cpanel upgrade????

cPanel.net Support Ticket Number:

[nickn]

Stuff has a tendancy of breaking on upgrades, open a ticket, only effective way to get this resolved

cPanel.net Support Ticket Number:

[hostit1]

Thanks for the response. I did create a trouble ticket and awaiting for a response.

Tim

cPanel.net Support Ticket Number:

[jdarow]

I just ran into this issue and hoping someone already knows th fix. Thanks in advance!

cPanel.net Support Ticket Number:

[hostit1]

jdarow,

CPanel was able to fix this issue. A guy named Darren actually was able to fix it. I asked Darrent what when wrong, and he wrote:


"Apparently on a handful of servers the tubra.
objects table is getting dropped, however our
;developers have yet to find out why. It's&nb
sp;only happened on about 4 servers (that&nb
sp;we know of) out of thousands so they
haven't had much luck in reproducing it. If&n
bsp;it comes back let us know."


Thanks,
Darren

cPanel.net Support Ticket Number:

[nat]

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;

cPanel.net Support Ticket Number:

[Silverado]

Has anyone else tried this?
Did it work for you?
Just want to make sure before we jump into that.

cPanel.net Support Ticket Number:

[nat]

Worked for me, but I guess you mean anyone other than me. Think I might be trying to screw up your machine? The above instructions came directly from cpanel support. If you open a cpanel ticket, you will probably get a reply that has those instructions in it pretty quickly. My e-mail I received from them seemed to be a template. I figured I would post the instructions on the forum so that anybody having the same problem would not have to bug cpanel about it and then wait for a response.

All of the above can be copied and then paste on one line at the mysql command prompt.