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…

Context: Our database contains orphaned records (e.g., Tasks, Notes) where the parent_type and parent_id reference deleted parent records. These orphaned records, some over five years old, need cleanup to improve database efficiency. Objective: …

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…

Dear All, Sugar version 9.0 1 supported MySQL version 8 in windows 10 ? Please suggest as soon as possible.

Rafael Fernandes , the supported platforms for Ent v13 are oddly specific when it comes to MySQL as it lists 5.7 or 8.0.32 https://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_13.0.x_Supported_Platforms/ Is there a reason for the oddly…

Hi team, We're stuck on the final stage of an upgrade whereby the upgrade script wants to create an index table: Error creating table: bcn1_buyer_carbon_nominations_bcn1_buyer_carbon_nominations_1_c 'idx_bcn1_buyer_carbon_nominations_bcn1_buyer_carbon_nominations_1_ida1_deleted…

I am facing an issue after upgrading a test instance of SugarCRM from MYSQL 5.7 to MYSQL 8.0 (in place upgrade after ubuntu server 18.0.4 to 20.0.4 upgrade) Table 'job_queue' from one of the SELECTs cannot be used in global ORDER clause I have configured…

Hi All, Kindly suggest how to add condition in custom report query where clause to get records created in Last Quarter? Thanks, Shreya

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

CreditFields.zip Above is a link to the package I am using. The package installs just fine, yet when I uninstall it I get the following errors. Wed Sep 30 16:05:49 2020 [ 6385 ][ 1 ][ ALERT ] Query Failed: ALTER TABLE campaigns_cstm drop COLUMN…

I have run some tests on our production data and the results look promising. I want to convert all my dropdowns to actual MySQL enum type from the current VarChar types. I am rewriting the MySQL code in Sugar to support this so my QRRs and any New Dropdowns…

The DBManager - http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.7/Data_Framework/Database/DBManagerFac… - is indispensable for querying the database. My favorite way of preventing SQL injection is binding variables, so…

Hey! A client of ours is experiencing some weird slowness issue in Sugar 7.9 running on MySQL 5.7. The problem is caused by some of the sql queries taking an extremely long time which effectively causes many of them to get stacked. This in turn eats up…

If any additional information is needed that would help you solve the problem, just let me know. I'm running SugarCRM 6.5.20 CE I have a logic hook that fires for a custom module and when I go to check the log, the query shows an execution time and appears…

Hi everyone, I'm new with the SugarCRM and I have some difficulties... On the table "accounts_audit" I added two new columns that need to be filled with the value of a custom field. My intention is not to put this value on the field "Field_name", but…

Hello Developers, I wrote a simple function that open a leads csv file and insert them into sugarcrm. there are 100,000 Leads in the file. and i loop through each row (using fget()) and create the lead bean and save() it works perfect! but as soon as…