Project

General

Profile

Help needed - Upgrade DomotiGa failed

Added by Samfox2 almost 4 years ago

Hi,

I did the Upgrade but got the following message after database Upgrade:

~/domotiga $ ./DomotiGaServer3.gambas a
gbx3: warning: cannot switch to language 'en_US.UTF-8': Datei oder Verzeichnis nicht gefunden. Did you install the corresponding locale packages?
2015/10/30 15:41:06 [Main] ---
Program Restart ----
2015/10/30 15:41:06 [Main] Starting DomotiGaServer3 V1.0.022 last updated on 2015-10-30 15:33:11
2015/10/30 15:41:06 [Main] Running on host 'raspberrypi' (pid 3940) as user 'pi'. (id 1000)
2015/10/30 15:41:06 [Main] Detected IP Address '192.168.2.103'.
2015/10/30 15:41:06 [Main] Detected Broadcast Address '192.168.2.255'.
2015/10/30 15:41:06 [Main] System language is 'en_US.UTF-8' on architecture 'arm'.
2015/10/30 15:41:06 [Main] Program base directory is '/home/pi/domotiga'.
2015/10/30 15:41:06 [Main] Database settings are loaded from 'server-domotiga.conf'.
2015/10/30 15:41:06 [Main] Active logfiles are 'server-main-2015-10.log', 'server-speak-2015-10.log' and 'server-debug-2015-10.log'.
2015/10/30 15:41:06 [Main] Running on Gambas version 3.8.2
2015/10/30 15:41:06 [Main] Server uptime is 15:41:06 up 16 min, 1 user, load average: 0.01, 0.25, 0.25
2015/10/30 15:41:06 [Main] Checking directory structure ...
2015/10/30 15:41:06 [Main] Connecting to database ...
2015/10/30 15:41:06 [MySQL] Database on host 'localhost'.
2015/10/30 15:41:06 [MySQL] Port used 3306.
2015/10/30 15:41:06 [MySQL] Version is '50546'.
2015/10/30 15:41:06 The version of your database is 1.0.021 but the version of the program is 1.0.022!
ERROR 1062 (23000) at line 4 in file: '/home/pi/domotiga/upgrade/10021to10022.sql': Duplicate entry '671' for key 'PRIMARY'
2015/10/30 15:41:06 MySQL command returned an error! The database is now at version 1.0.021

Andy Ideas?


Replies (5)

RE: Help needed - Upgrade DomotiGa failed - Added by rdnzl almost 4 years ago

You ran beta code before upgrade, simply remove the line in upgrade/10021to10022.sql with 671 in it (the first)
And restart DomotiGa.

RE: Help needed - Upgrade DomotiGa failed - Added by Samfox2 almost 4 years ago

Thanks for your help, now I get:

ale packages?
2015/10/30 17:39:37 [Main] ---- Program Restart ----
2015/10/30 17:39:37 [Main] Starting DomotiGaServer3 V1.0.022 last updated on 2015-10-30 15:33:11
2015/10/30 17:39:37 [Main] Running on host 'raspberrypi' (pid 6168) as user 'pi'. (id 1000)
2015/10/30 17:39:37 [Main] Detected IP Address '192.168.2.103'.
2015/10/30 17:39:37 [Main] Detected Broadcast Address '192.168.2.255'.
2015/10/30 17:39:37 [Main] System language is 'en_US.UTF-8' on architecture 'arm'.
2015/10/30 17:39:37 [Main] Program base directory is '/home/pi/domotiga'.
2015/10/30 17:39:37 [Main] Database settings are loaded from 'server-domotiga.conf'.
2015/10/30 17:39:37 [Main] Active logfiles are 'server-main-2015-10.log', 'server-speak-2015-10.log' and 'server-debug-2015-10.log'.
2015/10/30 17:39:37 [Main] Running on Gambas version 3.8.2
2015/10/30 17:39:37 [Main] Server uptime is 17:39:37 up 1:05, 1 user, load average: 0.00, 0.05, 0.11
2015/10/30 17:39:37 [Main] Checking directory structure ...
2015/10/30 17:39:37 [Main] Connecting to database ...
2015/10/30 17:39:37 [MySQL] Database on host 'localhost'.
2015/10/30 17:39:37 [MySQL] Port used 3306.
2015/10/30 17:39:37 [MySQL] Version is '50546'.
2015/10/30 17:39:37 The version of your database is 1.0.021 but the version of the program is 1.0.022!
ERROR 1091 (42000) at line 4 in file: '/home/pi/domotiga/upgrade/10021to10022.sql': Can't DROP 'sslcertificate'; check that column/key exists
2015/10/30 17:39:37 MySQL command returned an error! The database is now at version 1.0.021

RE: Help needed - Upgrade DomotiGa failed - Added by Samfox2 almost 4 years ago

Ok, deleted a few more, line by line.
Now it's working.
Thanks again rdnzl :)

RE: Help needed - Upgrade DomotiGa failed - Added by jessekerkhoven almost 4 years ago

Besides that you ran beta code before upgrade, please note that we discovered that the upgrade file was incorrect please run the following sql commands to fix the database:

--
-- Fix 10020 to 10021 upgrade problem
--
DELETE FROM plugins WHERE id=94;

INSERT INTO plugins (`id`, `interface`, `name`, `type`) VALUES (94, 'GPS', 'GPS', 'class');
INSERT INTO plugins (`id`, `interface`, `protocols`, `name`, `type`) values (95,'Buienradar','','Buienradar','class');

RE: Help needed - Upgrade DomotiGa failed - Added by Samfox2 almost 4 years ago

Ok, I will do. thanks.

    (1-5/5)