• Performance Issues with Custom Table Joins and Sorting in SugarCRM After MySQL Upgrade to 8.0.41

    We recently upgraded MySQL from version 5.7 to 8.0.41. Post-upgrade, we have observed a noticeable improvement in overall query performance. However, we are encountering a significant performance issue, specifically when accessing list views in modules…
  • For API customization in SugarCRM

    Dear All, I want to customized Some input received in Sugar by Default API . How can I customized if ? And Also share the path of default API in SugarCRM used. For Example :- I have share a case crate API with portal user and I received regularly in…
  • HTTP: 500 Internal Server Error Invalid subscription json data

    Dear Team, I have Upgraded our sugar CRM 11.0.6 to 12.0.3 & we are Getting CRM after login screen ( HTTP: 500 Internal Server Error Invalid subscription json data ) Please help what can i do for this issue
  • external cache db    what does it do

    Hello Community, Using SugarCRM 9.01 - onsite I am running into an issue of my database server filling up its temp file and then slowly filling up the HDD space causing Sugar to stop functioning. After looking at everything I possibly can I have come…
  • Simple SugarQuery using a custom field returns no results

    I created a custom Integer field called ticket_id_c in the Cases module and I can clearly see the field having the value my code is looking for in the cases_cstm table, but I still get no results. $sq = new SugarQuery ( ) ; $sq - > select ( 'id' ) ; …
  • create custom field in sugarcrm database and get that value using REST

    Hi I just created a custom field in in database(in user table, i don't know it is good way or not), now i want to get the custom field value using REST api,all value are retrieving except my custom field. Below is my rest api params $get_entries_parameters…
  • Sugarcrm 7 Multi-select keys display wrong characters in database

    Hello fellow sugarers ! I have a big weird issue with multiple choice dropdowns, the keys in the database are encapsulated within "^" characters In admin, via the Studio, i create a new Multi choice Dropdown field under Accounts module, called list_test_c…