Am Mittwoch, den 14.06.2006, 10:05 +0200 schrieb Rudolf Harney:
Hi,
another try, now in english:
we use otrs 2.0.4 with an external (mySQL) customer DB.
Customergroups can't be created. (If we disable the external customer db, it works.)
Is it not posible, to use customer Groups with an external customer db?
I found it myself: We had to add a table "valid" into the customer db and we hat to add a column "valid_id" into the customerdb-table. the mysql code looks like: ALTER TABLE otrs_myusertable ADD COLUMN valid_id smallint(6) DEFAULT 0; UPDATE otrs_myusertable SET valid_id=1; mysql> CREATE TABLE valid ( -> id smallint(6) AUTO_INCREMENT DEFAULT NULL, -> name varchar(50) UNIQUE, -> create_time datetime DEFAULT '0000-00-00 00:00:00', -> create_by int(11) DEFAULT 0, -> change_time datetime DEFAULT '0000-00-00 00:00:00', -> change_by int(11) DEFAULT 0, -> PRIMARY KEY (id) -> ); INSERT INTO valid (name, create_time, create_by, change_time, change_by ) VALUES ('valid', '2006-06-14 15:30:00', 1, '2006-06-14 15:30:00', 1) INSERT INTO valid (name, create_time, create_by, change_time, change_by ) VALUES ('invalid', '2006-06-14 15:30:00', 1, '2006-06-14 15:30:00', 1) INSERT INTO valid (name, create_time, create_by, change_time, change_by ) VALUES ('invalid-temporarily', '2006-06-14 15:30:00', 1, '2006-06-14 15:30:00', 1) Rudolf