Results 1 to 2 of 2

Thread: SQL Error : Invalid column name 'monitor_id'.

  1. #1
    Currier is offline Member
    Join Date
    Jun 2008
    Posts
    7

    Exclamation SQL Error : Invalid column name 'monitor_id'.

    I received the error SQL Error : Invalid column name 'monitor_id'. doing an import of accounts from a tab delimited file -- Version 5.1.0RC (Build 4469) -- my txt file contains the following columns
    Company
    BusinessStreet
    BusinessCity
    BusinessState
    BusinessPostalCode
    BusinessCountry
    BusinessFax
    BusinessPhone
    and are mapped to the corresponding equivalent

    Also, on a previous import, where I imported only a name and phone to accounts, some but not all names were imported with quotation marks around the name when were were clearly none in the source file, and I didn't see any specific pattern as it appeared random...

  2. #2
    ptemplin7 is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Puget Sound Washington
    Posts
    380

    Default Re: SQL Error : Invalid column name 'monitor_id'.

    Did you turn on the logging levels higher and check the log. Use you myphpoadmin or other toll to check the DB. Might have some columns there you didn't know about. Also, could the monitor_id be an index or required field that you didn't supply?

    Just some ideas. Hope you figure out,
    Paris

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: 2008-02-22, 04:25 PM
  2. Manually drop scheme (5.0 upgrade) ?
    By niallhannon in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2008-01-07, 05:41 PM
  3. Replies: 1
    Last Post: 2006-09-11, 03:38 PM
  4. SugarCrm 4.0 Patch
    By mgamboa in forum General Discussion
    Replies: 0
    Last Post: 2005-12-21, 04:14 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
  •