I am not getting the quick charts to show opportunities by pipeline. It shows “No Data.” Is there a way to reset the sales_stage_dom key list? I modified this dropdown, BUT there are some of the defaults left there. Is that the issue? How do I reset, through the UI, the default items/keys in the sales_stage_dom dropdown list?
Hello ,
that’s the default in 8.9:
“resetting” probably the easiest way is manually entering the original data.
It’s possible to build custom charts:
https://docs.suitecrm.com/8.x/developer/extensions/frontend/examples/add-charts-extension/
Did you change the the display values only or did you delete original values and add new ones?
Deleted the originals and added new ones.
I reset the server to back when I first installed the software. For some reason, even with the default sales stages now, when in the view opportunities screen, when I click insights, the quick charts “pipeline by sales stage” shows no data.
That implies, that you’re using the demo data?
I am using my own URL, on my own server, with real data.
And I assume you’re on MySQL, not MariaDB?
In that case, there is a bug ticket already online:
opened 12:32PM - 29 Aug 25 UTC
Type: Bug
Priority:Important
Area: MySQL8
Severity: Moderate
### Issue
Hello,
the quick diagram is empty, even though it was displaying data… a while ago. In the log, I only see the following MySQL error:
Do. Aug. 28 2025 at 13:12:05 [139021][1][FATAL] Query Failed: SELECT opportunities.sales_stage, SUM(opportunities.amount_usdollar) as amount_usdollar FROM opportunities LEFT JOIN opportunities_cstm ON opportunities.id = opportunities_cstm.id_c LEFT JOIN users jt0 ON opportunities.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON opportunities.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON opportunities.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accounts_opportunities jtl3 ON opportunities.id=jtl3.opportunity_id AND jtl3.deleted=0
LEFT JOIN accounts accounts ON accounts.id=jtl3.account_id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN campaigns jt4 ON opportunities.campaign_id=jt4.id AND jt4.deleted=0
AND jt4.deleted=0 where opportunities.deleted=0 AND opportunities.amount_usdollar is not null AND opportunities.sales_stage is not null GROUP BY opportunities.sales_stage DESC: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DESC’ at line 12
### Possible Fix
_No response_
### Steps to Reproduce the Issue
```bash
1.
2.
3.
...
```
### Context
_No response_
### Version
8.8.1
### What browser are you currently using?
Firefox
### Browser Version
_No response_
### Environment Information
MySQL 8.0.43-0ubuntu0.22.04.1 + PHP 8.4.11
### Operating System and Version
0.22.04.1
I am using MySQL. Thanks.
