AnsweredAssumed Answered

Custom entity insert error : SugarCRM 7.9 Beta

Question asked by Jenit Ramaiya on May 24, 2017

Hi Team,

 

We have created  a fresh  new MySQL  SugarCRM 7.9 Beta Instance

 

After creating the instance we have installed our  salesfusion bundle on this instance which creates some custom entities eg : sf_EventManagement

 

When I try to  create a record in any of the custom entity eg : sf_EventManagement through the UI or the SugarCRM Rest API i get an error

 

UI Error : Error thrown when we try to create an record  in sf_EventManagement  using user interface

               https://www.screencast.com/t/Ziqc85ueV

with params [\u002238b5febc-3ad3-11e7-9129-00155d640f98\u0022, 0]:
Unknown column sf_eventmanagement_leads_c.0 in field list

API Error: Error thrown when we try to create an record  in sf_EventManagement  using SugarCRM Rest API

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]
Incorrect syntax near \u0027.0\u0027.\n
SQLSTATE [42000, 8180]:
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not be prepared.

Please find attached Fiddler request and response for error using SugarCRM Rest API

 

Regards,

Ambit Support

Attachments

Outcomes