package ocsinventory-server 1.02.1-1 failed to upgrade:

[Carl Davis]

Binary package hint: ocsinventory-server

1)
Description: Ubuntu 9.10
Release: 9.10

2)
ocsinventory-server:
  Installed: 1.02.1-1
  Candidate: 1.02.1-1
  Version table:
 *** 1.02.1-1 0
        500 http://us.archive.ubuntu.com karmic/universe Packages
        100 /var/lib/dpkg/status

I attempted to perform an upgrade from 9.04 to 9.10. The database updgrade script was broken. I tried to deal with the errors but when I got an error of duplicate column names I gave up. I created this list of commands and kept executing and adding to it for about an hour:

drop table blacklist_serials, blacklist_macaddresses, download_affect_rules, download_servers, engine_mutex, engine_persistent, groups, groups_cache, hardware_osname_cache, prolog_conntrack, softwares_name_cache, tags, registry_name_cache, registry_regvalue_cache;
drop index userid on accesslog;
drop index userid on hardware;
drop index name on devices;
drop index name on engine_persistent;
drop index name on hardware;
drop index name on regconfig;
drop index name on registry;
drop index name on registry_name_cache;
drop index name on softwares;
drop index name on softwares_name_cache;
drop index ivalue on devices;

ProblemType: Package
Architecture: i386
Date: Sun Nov 14 08:52:47 2010
DistroRelease: Ubuntu 9.10
ErrorMessage:
 ErrorMessage: subprocess installed post-installation script returned error exit status 1
Package: ocsinventory-server 1.02.1-1
PackageArchitecture: all
ProcVersionSignature: Ubuntu 2.6.28-19.66-server
SourcePackage: ocsinventory-server
Title: package ocsinventory-server 1.02.1-1 failed to install/upgrade:
Uname: Linux 2.6.28-19-server i686