MantisBT - v2.4 Release (Closed)
View Issue Details
0000835v2.4 Release (Closed)[All Projects] Generalpublic2011-06-16 06:422011-08-16 23:49
Reporterdeepak 
Assigned Tocaseydk 
PrioritynormalSeveritycrashReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version2.4 
Summary0000835: Missing Validations in Budget
DescriptionGetting query failed and there is no validation that estimated and actual budgets are mandatory.

 query failed(UPDATE `projects` SET `project_company` = '1', `project_name` = 'Personal', `project_short_name` = 'Personal', `project_owner` = '2', `project_url` = '', `project_demo_url` = '', `project_start_date` = '2011-06-16 00:00:00', `project_status` = '0', `project_color_identifier` = 'FFFFFF', `project_description` = '', `project_target_budget` = '', `project_actual_budget` = '', `project_creator` = '2', `project_active` = 1, `project_private` = 0, `project_priority` = '0', `project_type` = '0', `project_parent` = '1', `project_location` = '', `project_last_task` = 0, `project_original_parent` = '1', `project_departments` = '', `project_contacts` = '', `project_updated` = '2011-06-16 15:36:50', `project_created` = '2011-06-16 15:36:50' WHERE project_id = '1') - error was: <span style="color:red">Incorrect decimal value: '' for column 'project_target_budget' at row 1</span>
TagsNo tags attached.
Attached Files

Notes
(0001985)
pedroa   
2011-06-17 07:23   
Hi,

I was looking at our base install code and I get:


  `project_target_budget` decimal(10,2) default '0.00',
  `project_actual_budget` decimal(10,2) default '0.00',

So we are accepting nulls on those two fields, question is...
Is Mysql in strict mode?

That's the only reason I see for mysql complaining with '' to inserted into a decimal field.

But I can agree that we could do the default ourselves if those fields are empty.

Pedro A.
(0002069)
caseydk   
2011-07-23 17:53   
Resolved in r2005;

Issue History
2011-06-16 06:42deepakNew Issue
2011-06-17 07:23pedroaNote Added: 0001985
2011-06-17 07:23pedroaStatusnew => feedback
2011-06-25 23:14caseydkProjectv2.3 Release (Closed) => v2.4 Release (Closed)
2011-07-23 17:53caseydkNote Added: 0002069
2011-07-23 17:53caseydkStatusfeedback => resolved
2011-07-23 17:53caseydkResolutionopen => fixed
2011-07-23 17:53caseydkAssigned To => caseydk
2011-08-16 23:49caseydkStatusresolved => closed
2011-08-16 23:49caseydkFixed in Version => 2.4