Error starting Domotiga since 203: Error: Unknown field: pol

[wwolkers]

Does anyone have the solution for this one:

domotiga@server:~/domotiga$ ./DomotiGaServer.gambas -a
2012/02/27 10:43:14 ---- Program Restart ----
2012/02/27 10:43:14 Starting DomotiGaServer V0.1.204 last updated on 2012-02-27 at 10:42:48
2012/02/27 10:43:14 Running on host 'server' (pid 19040) as user 'domotiga' (id 1001) with language en_US.UTF-8
2012/02/27 10:43:14 Program base directory is '/home/domotiga/domotiga'.
2012/02/27 10:43:14 Database settings are loaded from 'server-domotiga.conf'.
2012/02/27 10:43:14 Active logfiles are 'server-main-2012-02.log', 'server-speak-2012-02.log' and 'server-debug-2012-02.log'.
2012/02/27 10:43:14 Running on Gambas version 2.23.1
2012/02/27 10:43:14 Server uptime is 10:43:14 up 1 day, 15:43, 1 user, load average: 1.46, 1.12, 1.08
2012/02/27 10:43:14 Checking directory structure ...
2012/02/27 10:43:14 Connecting to database ...
2012/02/27 10:43:14 Loading modules ...
2012/02/27 10:43:14 Starting setup ...
2012/02/27 10:43:14 Error: Unknown field: polltime -1 while loading settings! Is your database version correct?
2012/02/27 10:43:14 Stopping running timers.
domotiga@server:~/domotiga$

It was running fine with 202, when I did an upgrade to SVN 203 I got this error, and now checked with 204 and still have this message.

[RDNZL]

Wouter,
you can restore your backup and rerun the upgrade with newer upgrade/01202to01203.sql file I just commited, or just do this to manually fix it:

Code: Select all

$ mysql -u root -p domotiga
mysql> ALTER TABLE `settings_zwave` ADD COLUMN `polltime` int(11) DEFAULT NULL AFTER `useozw`;
mysql> quit
Bye

[wwolkers]

I choose for the manual upgrade, and ran the command above, And then I get:

2012/02/27 22:04:45 Error: Type mismatch: wanted Integer, got Null instead 6 while loading settings! Is your database version correct?

[RDNZL]

Try to fill it with some sensible data:

Code: Select all

$ mysql -u root -p domotiga
mysql> INSERT INTO `settings_zwave` VALUES (0,0,'/dev/ttyUSB4','115200',0,0,0,0),(1,0,'/dev/ttyUSB10','115200',0,0,0,0);
mysql> quit
Bye

[wwolkers]

mysql> INSERT INTO `settings_zwave` VALUES (0,0,'/dev/ttyUSB4','115200',0,0,0,0),(1,0,'/dev/ttyUSB10','115200',0,0,0,0);
ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'


mysql> select * from settings_zwave;
+----+---------+---------------+----------+-------------+-------+--------+----------+
| id | enabled | serialport | baudrate | reloadnodes | debug | useozw | polltime |
+----+---------+---------------+----------+-------------+-------+--------+----------+
| 0 | 0 | /dev/ttyUSB4 | 115200 | 0 | 0 | 0 | NULL |
| 1 | 0 | /dev/ttyUSB10 | 115200 | 0 | 0 | 0 | NULL |
+----+---------+---------------+----------+-------------+-------+--------+----------+
2 rows in set (0.00 sec)


After looking at the table, I noticed the problem. fixed it by doing:

update settings_zwave set polltime='0';

Thanks for the support Ron! great as always.