Device persistent db update request

With Beta features enabled in the current emoncms Master version, I check the Admin page > Update database and I see;

1db

…so I apply changes, and then see;

2db

All good so far, but when I check for further updates, I again see;

1db

…and I continue to go around in a circle, even if I do a reboot.

Checking Mariadb in phpmyadmin, I can see that the name & description columns in the device table look as though they are correct.

3db

Any ideas??

Server Information
Emoncms Version 9.8.31
Modules Administration : App v1.1.0 : Dashboard v1.3.0 : Device v1.1.0 : EventProcesses : Feed : Graph v1.2.0 : Input : CoreProcess : Schedule : Time : User : Visualisation
Git URL GitHub - emoncms/emoncms: Web-app for processing, logging and visualising energy, temperature and other environmental data
Git Branch * master
Server OS Linux 4.14.34-v7+
Host raspberrypi raspberrypi (192.168.1.8)
Date 2018-09-27 20:33:43 BST
Uptime 20:33:43 up 23:04, 2 users, load average: 0.17, 0.32, 0.33
HTTP Server Apache/2.4.25 (Raspbian) HTTP/1.1 CGI/1.1 443
MySQL Version 5.5.5-10.1.23-MariaDB-9+deb9u1
Host localhost (127.0.0.1)
Date 2018-09-27 20:33:43 (UTC 01:00‌​)
Stats Uptime: 83079 Threads: 1 Questions: 84788 Slow queries: 0 Opens: 66 Flush tables: 1 Open tables: 43 Queries per second avg: 1.020
Redis Version 3.2.6
Host localhost:6379 (127.0.0.1)
Size 105 keys (679.45K)
Uptime 0 days
Pi Model Raspberry Pi 3 Model B Rev 1.2 - 1 GB (Sony UK)
SoC Broadcom BCM2835
Serial num. 60B48D30
Temperature CPU: 55.84°C - GPU: 55.3’C
Memory RAM Used: 53.63% Total: 875.66 MB Used: 469.63 MB Free: 406.03 MB
Swap Used: 4.26% Total: 100 MB Used: 4.26 MB Free: 95.74 MB
Disk Mount Stats
/ Used: 74.32% Total: 6.86 GB Used: 5.1 GB Free: 1.42 GB
/boot Used: 52.54% Total: 41.15 MB Used: 21.62 MB Free: 19.53 MB
/mnt/data Used: 17.99% Total: 458.49 GB Used: 82.47 GB Free: 376.02 GB
PHP Version 7.0.27-0+deb9u1 (Zend Version 3.0.0)
Modules apache2handler : bz2 v7.0.27-0+deb9u1 : calendar v7.0.27-0+deb9u1 : Core v7.0.27-0+deb9u1 : ctype v7.0.27-0+deb9u1 : curl v7.0.27-0+deb9u1 : date v7.0.27-0+deb9u1 : dio v0.1.0 : dom v20031129 : exif v7.0.27-0+deb9u1 : fileinfo v1.0.5 : filter v7.0.27-0+deb9u1 : ftp v7.0.27-0+deb9u1 : gd v7.0.27-0+deb9u1 : gettext v7.0.27-0+deb9u1 : hash v1.0 : iconv v7.0.27-0+deb9u1 : json v1.4.0 : libxml v7.0.27-0+deb9u1 : mbstring v7.0.27-0+deb9u1 : mcrypt v7.0.27-0+deb9u1 : mosquitto v0.4.0 : mysqli v7.0.27-0+deb9u1 : mysqlnd vmysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ : openssl v7.0.27-0+deb9u1 : pcre v7.0.27-0+deb9u1 : PDO v7.0.27-0+deb9u1 : pdo_mysql v7.0.27-0+deb9u1 : Phar v2.0.2 : posix v7.0.27-0+deb9u1 : readline v7.0.27-0+deb9u1 : redis v3.1.6 : Reflection v7.0.27-0+deb9u1 : session v7.0.27-0+deb9u1 : shmop v7.0.27-0+deb9u1 : SimpleXML v7.0.27-0+deb9u1 : sockets v7.0.27-0+deb9u1 : SPL v7.0.27-0+deb9u1 : standard v7.0.27-0+deb9u1 : sysvmsg v7.0.27-0+deb9u1 : sysvsem v7.0.27-0+deb9u1 : sysvshm v7.0.27-0+deb9u1 : tokenizer v7.0.27-0+deb9u1 : wddx v7.0.27-0+deb9u1 : xml v7.0.27-0+deb9u1 : xmlreader v7.0.27-0+deb9u1 : xmlwriter v7.0.27-0+deb9u1 : xsl v7.0.27-0+deb9u1 : Zend OPcache v7.0.27-0+deb9u1 : zip v1.13.5 : zlib v7.0.27-0+deb9u1

Client Information
HTTP Browser Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36
Screen Resolution 1366 x 768
Window Size 1675 x 819

Do you have the very latest version of emoncms? I realise that I really need to update the version number to be able to tell…

Yes, it’s the current Master branch.

Aha you also need the latest update for the device module, which includes this commit remove default from text datatype · emoncms/device@6793491 · GitHub

1 Like

Thanks Trystan, sorted.
I’m not used to this rate of change… I can’t keep up!!

Paul

2 Likes