• I was asked to create a report of all our SugarCRM reports and the number of times they have been accessed. Is this data even available with the Tracker module?

    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…

  • default_dashboard unknown column

    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…

  • Queries getting stuck on 'creating sort index', slowing Sugar down.

    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…

  • Query counts all contacts but one?

    I have a query that is repeated regularly and is pretty heavy on the database: SELECT COUNT ( id ) AS count FROM contacts WHERE team_set_id = '1' AND deleted = 0 AND id != '62f0e518-5d7e-8e98-f809-58d3bd75e98c' The contact ID parameter changes, as does…

  • Simple logic hook Error 500 on On-Demand

    I created a namespaced before_save logic hook that queries the DB for the largest number in a custom field, increments the result and sets that on the record when a new opportunity is created. It works perfectly on On-Premise, but responds with an Error…