[horde] Problem with database of the vilma

Ali Nebi ali_20_f1 at yahoo.com
Wed Oct 4 08:10:12 PDT 2006


Hi, 
i installed the vilma aplication under horde and make a configuration to use pgsql for the database, i used the vilma.pgsql.sql and included it to horde database
I have a problem with this:

When i choose Mail Admin and try to creat a domain after submit, it returm me that i have a field with null value.
I looked what fielad i have in the database and i saw that i have a fielad called:  domain_key        VARCHAR(64)

here is the whole script for create the table:

CREATE TABLE vilma_domains (   domain_id         INT DEFAULT 0 NOT NULL,   domain_name       VARCHAR(128) DEFAULT '' NOT NULL,   domain_transport  VARCHAR(128) DEFAULT '' NOT NULL,   domain_max_users  INT DEFAULT 0 NOT NULL,   domain_quota      INT8 DEFAULT 0 NOT NULL,   domain_key        VARCHAR(64),    PRIMARY KEY  (domain_id),   UNIQUE (domain_name) );

i can't see in the scripts how is insert this value for domain_key.

Can you give me some direction, what i have to do for the repair this?

 		
---------------------------------
How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.


More information about the horde mailing list