=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2014-08-04 14:27:32 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2014-08-08 10:25:32 +0000 @@ -1164,7 +1164,7 @@ private void updateOptions() { - String sql = "insert into optionvalue(optionid, code, name, optionsetid, sort_order) " + String sql = "insert into optionvalue(optionvalueid, code, name, optionsetid, sort_order) " + "select " + statementBuilder.getAutoIncrementValue() + ", optionvalue, optionvalue, optionsetid, ( sort_order + 1 ) " + "from optionsetmembers";