Topic: webmail address book problems

[Henry]

I can't seem to add addresses to the webmail address book. I get a generic error message and a suggestion to contact my admin.

Happens from both the internal network and remotly from the internet.

I'm using 6.0 b3 with all updates.

Any ideas?

[DanB35]

What, exactly, is the "generic error message"?

[kmcelwain]

Having this same problem.  Thought I licked it with the password connecting to mySQL, fixed it and now IMP works but turba is still having a problem.

Do you have any idea where the username and password that turba uses is setup.

I know what it needs to be changed to I just have no idea where it is.

[kmcelwain]

Figured it out, and man was I like...duh.

The problem was the field names changed for turba after the upgrade but they didn't change in mySQL.

Ran the script through phpmyadmin and it works like a charm.

Just in case here it is.

Make sure you have the horde database selected when you run this.

ALTER TABLE turba_objects CHANGE object_homeAddress object_homeaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_workAddress object_workaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_homePhone object_homephone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_workPhone object_workphone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_cellPhone object_cellphone VARCHAR(25);

ALTER TABLE turba_objects MODIFY object_title VARCHAR(255);

ALTER TABLE turba_objects MODIFY object_company VARCHAR(255);

ALTER TABLE turba_objects ADD object_type VARCHAR(255) NOT NULL DEFAULT 'Object';

ALTER TABLE turba_objects ADD object_members BLOB;

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

[Henry]

Can you be a bit more low level for me? I don't know what the phpadmin stuff is?

[ergozd]

PhpMyAdmin - is a tool to handle MySQL databeses. You can find more info at http://phpmyadmin.net

1 - Install phpmyadmin contrib from
http://mirror.contribs.org/smeserver/contribs/nightspirit/

2 - Access phpmyadmin by typing
https://your-sme-ip-adress/phpmyadmin

login with admin and password

3 - choose database horde on the left
click on SQL and run script below (you can cut and paste)

ALTER TABLE turba_objects CHANGE object_homeAddress object_homeaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_workAddress object_workaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_homePhone object_homephone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_workPhone object_workphone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_cellPhone object_cellphone VARCHAR(25);

ALTER TABLE turba_objects MODIFY object_title VARCHAR(255);

ALTER TABLE turba_objects MODIFY object_company VARCHAR(255);

ALTER TABLE turba_objects ADD object_type VARCHAR(255) NOT NULL DEFAULT 'Object';

ALTER TABLE turba_objects ADD object_members BLOB;

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
 
 
Good luck.