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