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 ;-) _______________________________________________ Obm mailing list [email protected] http://www.list.aliasource.fr/mailman/listinfo/obm
