![](https://secure.gravatar.com/avatar/ecb2aea5855f61674508e8c889a01846.jpg?s=120&d=mm&r=g)
hey there
just moving from community edition to latest subscriber edition
I am getting an error here
root@observium.lax:/opt/observium# ./discovery.php -u
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7231 http://www.observium.org
-- Updating database/file schema 185 -> 186 ... (db) done (9 errors).
any idea how to fix this? here is how my logs look like
root@observium.lax:/opt/observium# tail /opt/observium/logs/update-errors.log [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `devices` ADD INDEX `disabled_lastpolled` (`disabled`, `last_polled_timetaken`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'disabled_lastpolled' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv4_addresses` ADD INDEX `ipv4_address` (`ipv4_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv4_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv6_addresses` ADD INDEX `ipv6_address` (`ipv6_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv6_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `mac_accounting` ADD INDEX `device_ma` (`device_id`, `ma_id`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'device_ma' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `dbSchema` ADD PRIMARY KEY (`version`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1062) Duplicate entry '185' for key ‘PRIMARY'
![](https://secure.gravatar.com/avatar/0fa97865a0e1ab36152b6b2299eedb49.jpg?s=120&d=mm&r=g)
Did you press ctrl-c during an attempted upgrade then restart?
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 23 December 2015 23:08:06 Mehmet Akcin mehmet@akcin.net wrote:
hey there
just moving from community edition to latest subscriber edition
I am getting an error here
root@observium.lax:/opt/observium# ./discovery.php -u
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7231 http://www.observium.org
-- Updating database/file schema 185 -> 186 ... (db) done (9 errors).
any idea how to fix this? here is how my logs look like
root@observium.lax:/opt/observium# tail /opt/observium/logs/update-errors.log [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `devices` ADD INDEX `disabled_lastpolled` (`disabled`, `last_polled_timetaken`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'disabled_lastpolled' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv4_addresses` ADD INDEX `ipv4_address` (`ipv4_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv4_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv6_addresses` ADD INDEX `ipv6_address` (`ipv6_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv6_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `mac_accounting` ADD INDEX `device_ma` (`device_id`, `ma_id`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'device_ma' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `dbSchema` ADD PRIMARY KEY (`version`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1062) Duplicate entry '185' for key ‘PRIMARY'
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Adam Armstrong
-
Mehmet Akcin