Message: Error: Could not save Dashboard. Dashboard not updated

Dave · 2021-03-08T19:50:19.369Z

Hi All
I seem to be getting the below error message when trying to save a dashboard.
It seems to be caused by creating duplicate “Feed Values”

Error818×368 33 KB

Dave · 2021-03-12T22:22:22.251Z

For anybody who runs into this problem in the future, I was hitting the SQL limit on the table that the dashboard saves too. The solution was to change the SQL table properties from TEXT to LONGTEXT

Robert.Wall · 2021-03-12T23:03:34.036Z

I think @Trystan needs to know about this.

Dave · 2021-03-13T09:22:43.740Z

My dashboard is as below, I take it that I must have the most complex dashboard then

Dashboard 22142×1060 347 KB

Luiflm2 · 2021-04-19T19:24:10.518Z

Hi Dave, unfortunately I am not very skilled with SQL, but have the error you described on a dashboard, can you create a step by step guide on how I can change the SQL table properties from TEXT to LONGTEXT. Thanks for your efforts.

Luiflm2 · 2021-04-24T15:15:04.585Z

here are the steps I have taken today:

sudo mysql -u root -p
show databases;
use emoncms;
show fields from dashboard;
ALTER TABLE dashboard MODIFY content LONGTEXT;
show fields from dashboard;
quit
hope it is so correct

VETL · 2021-06-20T16:21:31.399Z

Hi All!
Sorry for my bad English.
I have updated the emoncms I have on a linux web hosting.
It worked fine for a long time, but with this update, I can’t save editing dashboards when they have graphic / visualisation elements. Works fine with all widgets, text, containers, etc., except visualization elements (graphs). This error appears when I try to save the dashboard:

Capturar

This happens whether I use “branch master” or “branch stable”.
I’ve already tried doing the above procedure, change the SQL table properties from TEXT to LONGTEXT, but it didn’t work.

If possible, I would be very grateful if someone could guide me, where should I start a screening route.

Additional data:

EMONCMS
Version 10.4
Modules
Administration | App v2.2.7 | Dashboard v2.0.10 | EventProcesses | Feed | Graph v2.1.0 | Input | CoreProcess | Schedule | Time | User | Visualisation

SERVER OS
Linux 3.10.0-962.3.2.lve1.5.52.el7.x86_64

HTTP Server
Apache HTTP/1.0 80

MYSQL
Version 10.2.37-MariaDB-cll-lve
Host localhost (127.0.0.1)

REDIS Version
Redis Server 3.2.12
PHP Redis 5.3.2

PHP Version
7.4.16 (Zend Version 3.4.0)

Dave · 2021-06-20T20:31:17.983Z

The solution for me was to change the SQL table properties from TEXT to LONGTEXT