Results 1 to 2 of 2

Thread: Missing contact_id in INSERT sql query

  1. #1
    brownbear is offline Junior Member
    Join Date
    Aug 2008
    Posts
    3

    Default Missing contact_id in INSERT sql query

    Hi,

    We had some problems with 4.5.0h, so we upgraded to 5.2.0a.

    When we go to a Contact's page, click on "Create Note or Attachment" in the History subpanel, fill out a quick note and save it, here are the two sql commands that are run:

    Sat Mar 7 12:15:10 2009 [12348][1][INFO] Query:INSERT INTO notes_cstm (id_c ,action_c ) VALUES ('5d0f00b5-a46f-ee00-5393-49b2b96882a6' ,'Call' )
    Sat Mar 7 12:15:10 2009 [12348][1][INFO] Query:INSERT into notes set id='5d0f00b5-a46f-ee00-5393-49b2b96882a6', date_entered='2009-03-07 18:15:10', date_modified='2009-03-07 18:15:10', modified_user_id='1', created_by='1', name='test 6', portal_flag='0', description='66', deleted='0'

    As you can see, there was a custom field added to the note called 'action' that records the type of activity associated with the note. In this case it was a 'Call'.

    But the problem is in the second sql command. It is not inserting a parent_id, nor a contact_id. So the note ends up having a contact_id of NULL, and is therefore not associated with the contact.

    I did look in the HTML source, and the correct contact_id is listed there in the post form.

    Any ideas on what could be going wrong? Thanks much!

  2. #2
    brownbear is offline Junior Member
    Join Date
    Aug 2008
    Posts
    3

    Default Re: Missing contact_id in INSERT sql query

    Anyone have any ideas?

    If not, is there a good company to call for hourly support?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert Query Problem in Zucker Report
    By chetanvalueone in forum Help
    Replies: 3
    Last Post: 2009-01-19, 11:15 AM
  2. Query Failed:INSERT into emails set
    By ftrevinoalbert in forum Help
    Replies: 1
    Last Post: 2008-10-07, 08:47 PM
  3. Replies: 1
    Last Post: 2006-10-26, 06:30 PM
  4. how to print insert query
    By rohitdsouza in forum Help
    Replies: 0
    Last Post: 2006-04-03, 06:35 AM
  5. Where is the insert query string for leads
    By laluciano in forum Help
    Replies: 0
    Last Post: 2005-07-01, 04:10 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
  •