ZM 1.22.1 -> 1.22.2 upgrade index 6 sql error

Rutger Diehard · Post by **Rutger Diehard** » Sun May 28, 2006 10:51 am

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

Post by **zoneminder** » Tue May 30, 2006 8:35 am

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.