Results 1 to 2 of 2

Thread: Importing error on custom basic module

  1. #1
    URtech is offline Sugar Community Member
    Join Date
    Oct 2006
    Posts
    34

    Default Importing error on custom basic module

    I've built a simple custom module in MB using the basic template. I published it and then loaded the module into a test instance I have setup of sugar. I then added a one-to-many relationship from Leads to my custom basic module via Studio since I can't currently do this in MB on version 5.2.0. I made sure the Leads relate field that was auto-created by Studio was saved to all the views of the custom basic module.

    When I try to run a simple import into my custom basic module, I get the following error:

    Want only a single row Query Failed:SELECT id FROM leads WHERE name = 'Jonathan Berkey' AND deleted != 1 LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'where clause'

    In this case, the Leads relate field should allow me to import the Lead's name (in my example, it's Jonathan Berkey which is an existing Lead name) or the Lead's ID which I also tried. Please note that the screenshot shows "Data," but that is only because I've relabeled the "Leads" module to be the "Data" module.

    Does anyone else have something like this setup working properly without this kind of error? Any ideas on a technique to fix this? Thanks!
    Attached Images Attached Images

  2. #2
    URtech is offline Sugar Community Member
    Join Date
    Oct 2006
    Posts
    34

    Default Re: Importing error on custom basic module

    Sugar confirmed that this is a bug: http://bugs.sugarcrm.com?bug_number=27955

    Best, Sean

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 2009-02-21, 01:10 AM
  2. importing mail to a custom module
    By wattoo2 in forum Developer Help
    Replies: 0
    Last Post: 2009-02-11, 08:22 AM
  3. importing mail to a custom module
    By wattoo2 in forum Help
    Replies: 0
    Last Post: 2009-01-30, 03:27 PM
  4. Replies: 3
    Last Post: 2008-12-03, 10:16 PM
  5. importing data to a custom module
    By yucelozcan in forum Help
    Replies: 3
    Last Post: 2007-12-21, 01:44 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
  •