google-code-export / cpassman

Automatically exported from code.google.com/p/cpassman
0 stars 0 forks source link

Out of range value adjusted for column \'id_user\' at row 1 #267

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. New installation or upgrade
2. Click on an item in the item list panel
3.

What is the expected output? What do you see instead?
Load item details such as description, password, etc

What version of the product are you using?
2.1.6

On what operating system? With what Browser (IEx, FFx, ...)
IE8, F8

Please provide any additional information below.
Full sql error details-

document.getElementById("mysql_error_warning").innerHTML = "<b>MySQL Query 
fail:</b> INSERT INTO `cpassman_log_items` (`id_item`, `date`, `id_user`, 
`action`) VALUES ('25', '1333998767', '134', 'at_shown');<br />Out of range 
value adjusted for column \'id_user\' at row 
1";$("#div_mysql_error").dialog("open");

This has always been the case for each of the teampass versions I never 
reported it because its a simple solution. I just alter the cpassman_log_items 
table and change the id_user column datatype from tinyint(4) to varchar(7).

Original issue reported on code.google.com by hexxamil...@gmail.com on 9 Apr 2012 at 7:19

GoogleCodeExporter commented 9 years ago
Oh yes you're right, this field is too small.

Corrected in 2.1.7

Original comment by nils.cpa...@gmail.com on 15 Apr 2012 at 7:17