Results 1 to 7 of 7

Thread: Apparent Defect: Problem creating Note - 2.0.1b

  1. #1
    ksg
    ksg is offline Sugar Community Member
    Join Date
    Aug 2004
    Posts
    14

    Default Apparent Defect: Problem creating Note - 2.0.1b

    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'

  2. #2
    ksg
    ksg is offline Sugar Community Member
    Join Date
    Aug 2004
    Posts
    14

    Default Re: Apparent Defect: Problem creating Note - 2.0.1b - Addendum

    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?

  3. #3
    Markku's Avatar
    Markku is offline Sugar Community Member
    Join Date
    Nov 2004
    Location
    Helsinki
    Posts
    910

    Default Re: Apparent Defect: Problem creating Note - 2.0.1b

    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)
    Last edited by Markku; 2004-12-10 at 06:18 AM.

  4. #4
    techex's Avatar
    techex is offline Sugar Community Member
    Join Date
    Oct 2004
    Location
    UK
    Posts
    409

    Default Re: Apparent Defect: Problem creating Note - 2.0.1b


  5. #5
    Markku's Avatar
    Markku is offline Sugar Community Member
    Join Date
    Nov 2004
    Location
    Helsinki
    Posts
    910

    Default Re: Apparent Defect: Problem creating Note - 2.0.1b

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

  6. #6
    techex's Avatar
    techex is offline Sugar Community Member
    Join Date
    Oct 2004
    Location
    UK
    Posts
    409

    Default Re: Apparent Defect: Problem creating Note - 2.0.1b

    OR yust use "c" as released last night !

  7. #7
    ksg
    ksg is offline Sugar Community Member
    Join Date
    Aug 2004
    Posts
    14

    Default Re: Apparent Defect: Problem creating Note - 2.0.1b

    2.0.1c cured it. Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 2006-10-12, 12:07 AM
  2. 4.0.1 Installation Problem
    By clawton in forum Help
    Replies: 14
    Last Post: 2006-02-13, 04:17 PM
  3. Fatal error: Max
    By spokes2k4 in forum Help
    Replies: 3
    Last Post: 2006-01-15, 03:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •