ZM 1.22.1 -> 1.22.2 upgrade index 6 sql error
Posted: 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
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