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!


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks