Results 1 to 5 of 5

Thread: SQL Error : Invalid column name 'name'. - MS SQL Express server

  1. #1
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Exclamation SQL Error : Invalid column name 'name'. - MS SQL Express server

    As the title says - we are receiving a SQL error : Invalid column name 'name'. error. on the sugar db

    Any ideas on how to fix this?

    Any guidance appreciated.

    Thanks in advance.
    Last edited by TakeMarket; 2007-04-27 at 02:47 PM.

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  2. #2
    pblag's Avatar
    pblag is offline Sugar Community Member
    Join Date
    Jul 2006
    Location
    Ukraine (Chernivtsy)
    Posts
    347

    Default Re: SQL Error : Invalid column name 'name'. - MS SQL Express server

    Hi!

    Sometimes when you install new modules you can have some problems with field "name" in Leads Module.

    Please let me know what module do you try to use?
    Petro Blagodir
    petro@blagodir.ua
    http://www.blagodir.com
    Blagodir Ltd.( SugarCRM - Consultations, Development and Support)

  3. #3
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Default Re: SQL Error : Invalid column name 'name'. - MS SQL Express server

    Hi,

    Thanks for your reply.

    We are for the moment just running the standard clean sugar crm without any extension modules, so what can be the reason then?

    Thanks in advance for your answer.

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  4. #4
    frischf50 is offline Junior Member
    Join Date
    Jan 2008
    Posts
    1

    Default Re: SQL Error : Invalid column name 'name'. - MS SQL Express server

    I am getting the same error an it appears to be in the calendar module. When looking at shared calendars it will display the first 4 indivudals calendars and then give me the SQL error "INVLAID COLUMN NAME 'NAME'

    Any and all help is appreciated. We don't use the LEADS module.

  5. #5
    orionmedya is offline Junior Member
    Join Date
    Apr 2008
    Posts
    1

    Default Re: SQL Error : Invalid column name 'name'. - MS SQL Express server

    I am getting the same error in a similar way:

    SQL Error : Invalid column name 'ID'.

    I checked the database and the identifiers are named as "id", not "ID". Could this be the main problem?
    Any resolution will be appreciated.

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. Replies: 1
    Last Post: 2006-09-11, 03:38 PM
  3. 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
  •