On Thu, Jul 16, 2009 at 5:34 PM, Tim Verhoeven<[email protected]> wrote: > > I'm getting these SQL errors : > > Database error: Invalid SQL: INSERT INTO UserObm ( userobm_domain_id, > userobm_timeupdate, userobm_timecreate, userobm_userupdate, > userobm_usercreate, userobm_login, userobm_password, > userobm_password_type, userobm_perms, userobm_uid, userobm_gid, > userobm_archive, userobm_hidden, userobm_datebegin, > userobm_account_dateexp, userobm_kind, userobm_lastname, > userobm_firstname, userobm_title, userobm_company, userobm_direction, > userobm_service, userobm_address1, userobm_address2, userobm_address3, > userobm_zipcode, userobm_town, userobm_expresspostal, > userobm_country_iso3166, userobm_phone, userobm_phone2, > userobm_mobile, userobm_fax, userobm_fax2, userobm_email , > userobm_delegation_target , userobm_delegation, userobm_description , > userobm_web_perms, userobm_web_all, userobm_web_list , > userobm_mail_perms, userobm_mail_ext_perms, userobm_mail_server_id, > userobm_mail_quota , userobm_email_nomade, userobm_nomade_perms, > userobm_nomade_enable, userobm_nomade_local_copy , > userobm_vacation_enable, userobm_vacation_datebegin, > userobm_vacation_dateend, userobm_vacation_message ) VALUES ( 2, > NOW(), NOW(), 1, 1, 'admin1', 'admin', 'PLAIN', 'admin', '1003', > '1000', 0, 0, null, null, 'Administrator', 'Administrator', '', '', > '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' , '' , > '', '' , 0, 0, '' , 0, 0, NULL, 0 , '', NULL, NULL, NULL , 0, null, > null, '' ) > PostgreSQL Error: 1 (ERROR: value too long for type character varying(12)) > Database error: Invalid SQL: INSERT INTO UserObmGroup > (userobmgroup_group_id, userobmgroup_userobm_id) VALUES (1, NULL) > PostgreSQL Error: 1 (ERROR: null value in column > "userobmgroup_userobm_id" violates not-null constraint) > > When I tried to create a admin user for a newly created domain. Anyone > any idea what is wrong here ? This is a fresh install using OBM 2.2.6 > and with PostgreSQL as DB. >
Did anyone had the change to have a look at this ? I'm stuck right now since I can't create a admin user for my normal domain, so I can't create normal users etc. If anything else is needed or if I need to test certain things, just let me know. Regards, Tim -- Tim Verhoeven - [email protected] - 0479 / 88 11 83 Hoping the problem magically goes away by ignoring it is the "microsoft approach to programming" and should never be allowed. (Linus Torvalds) _______________________________________________ Obm mailing list [email protected] http://www.list.aliasource.fr/mailman/listinfo/obm
