On a newly installed system database namings and columns are missing

[maglub]

pi@reto-r001wue:~/piLogger/bin $ ./refreshCaches 
20160725_134912;refreshCaches;  - Refreshing caches 
20160725_134912;refreshCaches;  - Refreshing sensorData.json
20160725_134912;exportJSON;* Starting export of JSON for default 
Error: near line 1: no such column: sensor.multiplier
ERROR: opening '/var/lib/piLogger/db/.28.2F0143050000.rrd': No such file or directory
20160725_134912;refreshCaches;  - Refreshing caches 168h
20160725_134912;refreshCaches;  - Refreshing caches 12h
20160725_134912;refreshCaches;  - Refreshing caches 24h
20160725_134912;refreshCaches;  - Refreshing sensorData.default.12h.cache
20160725_134912;refreshCaches;  - Refreshing sensorData.default.168h.cache
20160725_134912;refreshCaches;  - Refreshing sensorData.default.24h.cache
20160725_134913;exportJSON;* Starting export of JSON for default 12h
20160725_134913;exportJSON;* Starting export of JSON for default 168h
20160725_134913;exportJSON;* Starting export of JSON for default 24h
Error: near line 1: no such column: sensor.multiplier
Error: near line 1: no such column: sensor.multiplier
Error: near line 1: no such column: sensor.multiplier
ERROR: opening '/var/lib/piLogger/db/.28.2F0143050000.rrd': No such file or directory
ERROR: opening '/var/lib/piLogger/db/.28.2F0143050000.rrd': No such file or directory
ERROR: opening '/var/lib/piLogger/db/.28.2F0143050000.rrd': No such file or directory
20160725_134913;refreshCaches;  - Refreshing caches sensors
20160725_134913;refreshCaches;  - Refreshing sensorAllInfo.json
20160725_134913;listDevices;Found devices in the database.

[maglub]

Quick workaround:

sqlite3 /var/lib/piLogger/db/app.sqlite3<<EOT
alter table sensor add column multiplier float;
update sensor set multiplier=1;
alter table plotgroup add column metric text ;
update plotgroup set metric = 'temperature' where metric is null ;
EOT

This has earlier been added to the upgrade.sh script, but not been properly dealt with in dbSetup.sh and the db/ddl.sql