Page 1 of 1

ZM 1.22.1 -> 1.22.2 upgrade index 6 sql error

Posted: Sun May 28, 2006 10:51 am
by Rutger Diehard
On running the zm_update-1.22.1.sql script to update the database to version 1.22.2 I get an index error.

Digging a bit deeper and this appears to be from the script trying to add a 'Best, High Sensitivity' preset value to a table which already has that value in 1.22.1 and results in a #1062 duplicate entry error.

I just commented out that command in the zm_update-1.22.1.sql script, ran again and now have an upgraded system.

Just a heads up, hope this helps.

Rutger

Posted: Tue May 30, 2006 8:35 am
by zoneminder
Thanks for the post. I had assumed that this line was missing from all previous installs but it appears that it is only some of them. I have updated the upgrade sql to take this into account now.