Code: Select all
[user@zoneminder ~]$ sudo zmupdate.pl
Initiating database upgrade to version 1.31.1 from version 1.30.4
Please ensure that ZoneMinder is stopped on your system prior to upgrading the database.
Press enter to continue or ctrl-C to stop :
Do you wish to take a backup of your database prior to upgrading?
This may result in a large file in /var/lib/zoneminder/temp if you have a lot of events.
Press 'y' for a backup or 'n' to continue : n
Upgrading database to version 1.31.1
Loading config from DB 208 entries
Saving config to DB 208 entries
Upgrading DB to 1.31.0 from 1.30.4
Database successfully upgraded to version 1.31.0.
Upgrading DB to 1.31.1 from 1.30.4
Database successfully upgraded to version 1.31.1.
Upgrading DB to 1.31.2 from 1.30.4
ERROR 1062 (23000) at line 1: Duplicate entry '28' for key 'PRIMARY'
Output:
Command 'mysql -hlocalhost -uzmuser -p"zmpass" zm < /usr/share/zoneminder/db/zm_update-1.31.2.sql' exited with status: 1I edited the /usr/share/zoneminder/db/zm_update-1.31.2.sql SQL script to insert at line 30 instead of 28 (28 was Keekoon) and the upgrade completed successfully. I don't use either camera so I'm not sure if this is the right solution, but it's up and running again.
jt