Re: [opsview-users] User web interface error

[Duncan Ferguson]

On 17 Nov 2009, at 22:16, Federico Sirtori wrote: Hi all,   i’m working on Opsview C.E. 3.3.2   I’ve added a new contact and have created new role but when I log in I receivr this error:   Opsview error: DBIx::Class::ResultSet::update_or_create(): DBI Exception: DBD::mysql::st execute failed: Duplicate entry 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; ' for key 1 [for Statement "INSERT INTO useragents ( id, last_update) VALUES ( ?, ? )" with ParamValues: 0='Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)', 1='2009-11-17 22:07:12'] at /usr/local/opsview-web/script/../lib/Opsview/Web/Controller/Root.pm line 364 We record the browser user agent information within the opsview database so we can gather stats about what browsers people are using (when this option is ticked in the system preferences) - this allows us to improve our development and testing cycles for what people actually use, not what we think people should be using :) In your specific case your user agent string is longer than the column width in the database - the best fix is to run the following in the opsview database    ALTER TABLE useragents MODIFY COLUMN id varchar(760) NOT NULL; I will put this back into our code shortly.   Duncs   --  Duncan Ferguson Senior Developer Opsera Limited | Unit 69 Suttons Business Park Reading | Berkshire | RG6 1AZ | UK Phone:   +44 (0) 845 057 7887 Mobile:   +44 (0) 7968 148 748 Skype:   duncan_j_ferguson     Email:   duncan.fergu...@opsera.com www.opsera.com Opsera Limited is registered in the UK under Company Number 5396532. Our registered office is Gorse View, Horsell Rise, Woking, Surrey, GU21 4RB.

_______________________________________________
Opsview-users mailing list
Opsview-users@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-users