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…

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…

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

We user SugarCRM Sell hosted in the cloud. When I perform a custom query like this: select * from tracker t where action = 'detailView' and module_name = 'Reports' order by date_modified desc The data exported just seems to be the date_modified…

Hi all! Where can I find relate fields in the database? In studio we have a custom relate field on account named merged_into_c, which contains a link to another account. I want select the accounts which were merged into another account, but the…

Let me preface this post: I don't know anything about this at all. Because I don't know anything, I am hoping my ignorance may somehow luck into outside of the box thinking. My customer's file storage is huge. We've determined that the Upload…

When I'm in the Resolve Conflicts drawer and I try to click the Preview button, there is an error in the Network tab. When looking at the error itself in the Networks tab: I was able to find the code that is related to this, it seems that the…

I'm trying to add a circular (relationship with itself) M:M relationship to the Product Templates module. I was to create it and the subsequent linking table and add the subpanels for both the left and right side of the relationship. However, when I…

Hi All, How can I created a custom database manager for MySQL. Is it supporting sugarcrm customization standards.

Hello folks, We are trying to implement the Thai Buddha calendar for Sugar enterprise 10.x with SQL server. I would like to know if anyone has tried implementing a non-gregorian calendar for Sugar and if it is possible to implement it at the database…

Hello, Following few weeks of test i'll transfer my on premise server to a cloud server. The application has been installed and tested on cloud few weeks ago with a database from December 2019. In order to update the database, is it enough to 1 - Dump…

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…

Hi, I'd like to ask a general question regarding best practices. In cases like when a client mistakenly deletes a record from any Sugar module, such as Accounts, what is the best way to go on about recovering it? Simply changing the record's deleted flag…

hi All, We have just upgraded our instance from 7.9.5 to 8.0.2 , upgrade failed at post_upgrade checks we are witnessing following error on all module pages - Unknown column 'dashboards.default_dashboard' HTTP: 500 Internal Server Error An exception occurred…

Do following this: http://support.sugarcrm.com/Resources/Environments/Development_Environments/OSX_Development_Environment/ Not clean install set up, all source code is on git and I pulling to my local machine. My apache is working, can run a php file…

Hi Guys, I am unable to connect SQL Server 2014 database from SugarCRM. I have sugarCRM installed on one instance (Web Server) and database is present on another instance (Database server). When I try to open the login page i.e. http://localhost/sugarcrm…

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' ) ; …

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…

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…

Hello, I have a need to query the DB for all products sold to a client then get the total. This then needs to be displayed in a field. I am using SugarCRM CE 6.5.13 I would greatly appreciate any assistance. Thanks.