Apparent Defect: Problem creating Note - 2.0.1b

[ksg]

When I attempt to create a Note relating to an opportunity I enter the Contact name, the subject and the text of a note, and get the following error:

Query Failed:INSERT into notes set id='323ea275-75ac-0585-9391-41b88e03e851', date_entered='20041209104235', date_modified='2004-12-09 10:42:35', assigned_user_id='9b482413-4fae-0fa1-3139-417e7c54a4da', [details of note removed] filename='', parent_type='Opportunities', parent_id='eb38c13f-8eac-b513-880c-41b8745e8f96', contact_id='2968a195-ae65-01df-924b-41b875df4265'::MySQL error 1054: Unknown column 'assigned_user_id' in 'field list'

[ksg]

Clicked Submit too early - I intended to add at the end of my previous message

I didn't see anything in the upgrade from earlier versions of 2.0.1 that implied a need to rebuild the database. Did I miss something?

[Markku]

You just have to add assigned_user_id field (varchar 36, null) to your Notes table. I haven't seen any info regarding database changes so I guess this one just slipped through (by the SugarCRM team I mean)

[techex]

http://www.sugarcrm.com/forums/showt...=2689#post2689

[Markku]

OK, so the other option is to use older version (pre 2.0.1b) of note.php file, thanks.

[techex]

OR yust use "c" as released last night !

[ksg]

2.0.1c cured it. Thanks.