Query Error when EDITING tasks

[The Sugar Newb]

im having the following message when updating tasks:

Query Failed:Update project_task set date_modified='2010-06-12 14:05:51', project_id='baa762ad-7a66-dcaa-d75d-4bfec7a0c864', project_task_id=0, name='TEST1 trhrt', status='Complete', description='FGBHTWRJT ERGnbntgmn', predecessors=null, date_start='2010-06-15', time_start=null, time_finish=null, date_finish='2010-09-27', duration=0, duration_unit=null, actual_duration=null, percent_complete=null, parent_task_id=null, assigned_user_id='7ee6571f-cb45-105c-52cc-4bf2a93e2205', modified_user_id='1a622f29-3c48-3708-0d4e-4bf29bdade82', priority='1', created_by='1a622f29-3c48-3708-0d4e-4bf29bdade82', milestone_flag='0', order_number=1, task_number=null, estimated_effort=null, actual_effort=null, deleted='0', utilization=100 WHERE ID = 'a9169a3b-d597-6b28-4664-4c1392d3a83c'::MySQL error 1048: Column 'duration_unit' cannot be null

If someone could please help me figure out why sugar is doing this it would be greatly appreciated

[davidboris]

Hi,

As suggested by mysql, you have a not null field 'duration_unit', either you provide a value to it, while editing a task or you can extend the vardef and make the field null.

[The Sugar Newb]

Thanks!

i simply went into studio added duration unit to the edit view (no fields are added or changed) and now it will let me save.