[Obm] SQL error adding admin user for a newly created domain

[Thomas Cataldo]

On Thu, 2009-07-16 at 17:34 +0200, Tim Verhoeven wrote:
> Hi,
> 
> 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)

The "userobm_kind" field is limited to 12 characters. You should enter
values like "Mr, Miss, Lord, Sir", not Administrator ;-)