New stable #3.521 Released today!

Post your feedback and suggestions for the forum, website, wiki, Twitter-account, Facebook page and tracker (not the Domoticz project itself) here.

Moderator: leecollings

User avatar
gizmocuz
Posts: 2552
Joined: Thursday 11 July 2013 18:59
Target OS: Raspberry Pi / ODroid
Domoticz version: beta
Location: Top of the world
Contact:

Re: New stable #3.521 Released today!

Post by gizmocuz »

EddyG wrote:Nothing to hack. Google for "SQLiteDatabaseBrowserPortable".
Stop Domoticz and copy the database "domoticz.db"
Use the program, open the database, select in browse the DeviceStatus table.
On the header set filter to the Type 243 and SubType 6
and you have all the devices.
Edit the values of the DeviceID by putting 3 zero's in front of them.
Save the database and put it back
Start Domoticz and you are done.

In a way it is a hack, because normally it should never be done like this.
for you this might be easy, for others its a hack, and its now possible to transfer percentage devices which is a cleaner solution (and easier)
Quality outlives Quantity!
Holland
Posts: 179
Joined: Friday 12 July 2013 13:53
Target OS: Raspberry Pi / ODroid
Domoticz version: Beta Ch
Location: The Netherlands
Contact:

Re: New stable #3.521 Released today!

Post by Holland »

Installed the stable 2.3530 today, but encountered an issue with updating the raspberry distribution with sudo apt-get update and sudo apt-get upgrade.

The following error was returned; See bold below.

I solved it with the following;

pi@raspberrypi ~ $ sudo rm /var/lib/dpkg/available
pi@raspberrypi ~ $ sudo sudo touch /var/lib/dpkg/available
pi@raspberrypi ~ $ sudo sh -c 'for i in /var/lib/apt/lists/*_Packages; do dpkg --merge-avail "$i"; done'

After that rerun update and upgrade and you should be fine


Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
bind9-host krb5-locales krb5-multidev libbind9-80 libdns88 libgssapi-krb5-2
libgssrpc4 libisc84 libisccc80 libisccfg82 libk5crypto3 libkadm5clnt-mit8
libkadm5srv-mit8 libkdb5-6 libkrb5-3 libkrb5-dev libkrb5support0 liblwres80
libpng12-0 libraspberrypi-bin libraspberrypi0 libssl-dev libssl-doc
libssl1.0.0 libxml2 mosquitto nodejs ntp openssl raspberrypi-bootloader
unzip wpasupplicant
32 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 49.2 MB of archives.
After this operation, 2,645 kB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://archive.raspberrypi.org/debian/ wheezy/main libraspberrypi-bin armhf 1.20151118-1 [233 kB]
Get:2 http://archive.raspberrypi.org/debian/ wheezy/main libraspberrypi0 armhf 1.20151118-1 [687 kB]
Get:3 http://repo.mosquitto.org/debian/ wheezy/main mosquitto armhf 1.4.5-0mosquitto1~nows1 [133 kB]
Get:4 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libssl-doc all 1.0.1e-2+rvt+deb7u18 [1,198 kB]
Get:5 http://archive.raspberrypi.org/debian/ wheezy/main raspberrypi-bootloader armhf 1.20151118-1 [31.5 MB]
Get:6 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libssl-dev armhf 1.0.1e-2+rvt+deb7u18 [1,499 kB]
Get:7 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libssl1.0.0 armhf 1.0.1e-2+rvt+deb7u18 [1,053 kB]
Get:8 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libkrb5-dev armhf 1.10.1+dfsg-5+deb7u6 [40.3 kB]
Get:9 http://mirrordirector.raspbian.org/raspbian/ wheezy/main krb5-multidev armhf 1.10.1+dfsg-5+deb7u6 [153 kB]
Get:10 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libk5crypto3 armhf 1.10.1+dfsg-5+deb7u6 [113 kB]
Get:11 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libgssapi-krb5-2 armhf 1.10.1+dfsg-5+deb7u6 [133 kB]
Get:12 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libkrb5-3 armhf 1.10.1+dfsg-5+deb7u6 [343 kB]
Get:13 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libkrb5support0 armhf 1.10.1+dfsg-5+deb7u6 [46.8 kB]
Get:14 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libgssrpc4 armhf 1.10.1+dfsg-5+deb7u6 [79.5 kB]
Get:15 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libkdb5-6 armhf 1.10.1+dfsg-5+deb7u6 [61.4 kB]
Get:16 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libkadm5srv-mit8 armhf 1.10.1+dfsg-5+deb7u6 [76.3 kB]
Get:17 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libkadm5clnt-mit8 armhf 1.10.1+dfsg-5+deb7u6 [63.1 kB]
Get:18 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libxml2 armhf 2.8.0+dfsg1-7+wheezy5 [825 kB]
Get:19 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libpng12-0 armhf 1.2.49-1+deb7u1 [179 kB]
Get:20 http://mirrordirector.raspbian.org/raspbian/ wheezy/main ntp armhf 1:4.2.6.p5+dfsg-2+deb7u6 [525 kB]
Get:21 http://mirrordirector.raspbian.org/raspbian/ wheezy/main bind9-host armhf 1:9.8.4.dfsg.P1-6+nmu2+deb7u8 [71.8 kB]
Get:22 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libisc84 armhf 1:9.8.4.dfsg.P1-6+nmu2+deb7u8 [169 kB]
Get:23 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libdns88 armhf 1:9.8.4.dfsg.P1-6+nmu2+deb7u8 [710 kB]
Get:24 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libisccc80 armhf 1:9.8.4.dfsg.P1-6+nmu2+deb7u8 [33.7 kB]
Get:25 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libisccfg82 armhf 1:9.8.4.dfsg.P1-6+nmu2+deb7u8 [55.0 kB]
Get:26 http://mirrordirector.raspbian.org/raspbian/ wheezy/main libbind9-80 armhf 1:9.8.4.dfsg.P1-6+nmu2+deb7u8 [42.0 kB]
Get:27 http://mirrordirector.raspbian.org/raspbian/ wheezy/main liblwres80 armhf 1:9.8.4.dfsg.P1-6+nmu2+deb7u8 [51.9 kB]
Get:28 http://mirrordirector.raspbian.org/raspbian/ wheezy/main krb5-locales all 1.10.1+dfsg-5+deb7u6 [1,504 kB]
Get:29 http://mirrordirector.raspbian.org/raspbian/ wheezy/main openssl armhf 1.0.1e-2+rvt+deb7u18 [702 kB]
Get:30 http://mirrordirector.raspbian.org/raspbian/ wheezy/main unzip armhf 6.0-8+deb7u5 [195 kB]
Get:31 http://mirrordirector.raspbian.org/raspbian/ wheezy/main wpasupplicant armhf 1.0-3+deb7u3 [542 kB]
Get:32 https://deb.nodesource.com/node_0.10/ wheezy/main nodejs armhf 0.10.41-1nodesource1~wheezy1 [6,087 kB]
Fetched 49.2 MB in 12s (4,028 kB/s)
Extracting templates from packages: 100%
Preconfiguring packages ...
dpkg: error: parsing file '/var/lib/dpkg/available' near line 0:
EOF after field name `'
E: Sub-process /usr/bin/dpkg returned an error code (2)


sudo sh -c 'for i in /var/lib/apt/lists/*_Packages; do dpkg --merge-avail "$i"; done'
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest