Can you tell me what are the table types - from the source data of these charts?
Are they perhaps Manual tables, or SQL Query based, or tables linked from a Sheet like Excel/CSV/Google Sheets?
Did you change something in the column structure from one or more of the chart source tables? For example - if you change a column header name, to any column which is already chosen for a chart; or remove a column which is used in a chart; Or change the data type - All these changes can create an issue and a connected chart would stop rendering.
Let me know if that helps to isolate it?
If not - can you check do all the charts load correctly at the back-end in WP-Admin? Is there any chart that does not load there?
If any chart doesn't load on back-end Wp-Amin in Chart Wizard preview - can you try making a new chart from the same table, see if that works? If you are able to make a new chart from the same table - then check is it possible that you made any column structure change - for any column used in the old chart that made it 'break'?
Or, if it's not always the same chart, but as you said - random on the Page, like sometimes Chart 1 and 2 and another time chart 4 and 5;
It could be if your source table(s) are server-side processing enabled and if you have any caching active on your WP Page. If so - please try excluding the URL where you got tables/or charts from caching - that should solve it.
I am just posting a reply to provide documentation in case there were others like me who struggled.
1) The data was being pulled live from GoogleSheets. There were several >10 charts that would be loaded every time a webpage got loaded, so Googlesheets could not keep up with the live data feed
2) The solution is to cache the data and have it update every 15 minutes.
Error: "There was an issue displaying the chart. Please edit the chart in the admin area for more details."
Charts will be inconsistent in their ability to generate. I'm still in WP staging, but it seems that the error is random.
See attachment, this is the latest refresh but different charts will fail to load on a different refresh.
Attached files: Screenshot 2024-10-15 220914.png
I just refreshed 20 seconds later. Here's the latest refresh with the latest failures (now at the top)
Attached files: Screenshot 2024-10-15 220914.png
Hi Amer,
Can you tell me what are the table types - from the source data of these charts?
Are they perhaps Manual tables, or SQL Query based, or tables linked from a Sheet like Excel/CSV/Google Sheets?
Did you change something in the column structure from one or more of the chart source tables?
For example - if you change a column header name, to any column which is already chosen for a chart;
or remove a column which is used in a chart;
Or change the data type - All these changes can create an issue and a connected chart would stop rendering.
Let me know if that helps to isolate it?
If not - can you check do all the charts load correctly at the back-end in WP-Admin?
Is there any chart that does not load there?
If any chart doesn't load on back-end Wp-Amin in Chart Wizard preview - can you try making a new chart from the same table, see if that works?
If you are able to make a new chart from the same table - then check is it possible that you made any column structure change - for any column used in the old chart that made it 'break'?
It could be if your source table(s) are server-side processing enabled and if you have any caching active on your WP Page.
If so - please try excluding the URL where you got tables/or charts from caching - that should solve it.
Let me know if that helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Milos,
I am just posting a reply to provide documentation in case there were others like me who struggled.
1) The data was being pulled live from GoogleSheets. There were several >10 charts that would be loaded every time a webpage got loaded, so Googlesheets could not keep up with the live data feed
2) The solution is to cache the data and have it update every 15 minutes.
Thank you for your help
Hi Amer,
Thank you very much for sharing what you did to resolve this issue. It will be very useful for other users who might experience the same issue.
If anything else comes up, please don't hesitate to open new tickets.
Thanks again.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables