Device persistent db update request

Paul · 2018-09-27T19:34:25.068Z

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

TrystanLea · 2018-09-27T19:44:13.398Z

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…

Paul · 2018-09-27T19:50:33.708Z

Yes, it’s the current Master branch.

TrystanLea · 2018-09-27T20:18:06.459Z

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

Paul · 2018-09-27T20:22:03.604Z

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

Paul