[Spacewalk-list] Error displaying package details

[Sajesh Singh]

> Sure, there is. However I do not believe, it will fix your issue. If you're missing
> a change from 2010, there might be much more troubles than this one.
> 
> Let us know, what Spacewalk version you originally installed and to what
> versions you upgraded afterwords.
> 
> And what do following commands say:
> # rhn-schema-version
> # rpm -q spacewalk-schema spacewalk-java
> 
> ==============
> Regarding your missing column you may try this:
> # spacewalk-sql -i
> and paste following lines (do not paste lines that start with "-"):
> - following is the line, that adds you the missing column:
> ALTER TABLE rhnErrata ADD    errata_from varchar2(127);
> - your advisory and advisory_name columns were extended:
> ALTER TABLE rhnErrata MODIFY advisory_name varchar2(100); ALTER TABLE
> rhnErrata MODIFY advisory varchar2(100);
> - we did the same for unpublished errata (I suppose you'll miss them, too):
> ALTER TABLE rhnErrataTmp ADD    errata_from varchar2(127);
> ALTER TABLE rhnErrataTmp MODIFY advisory_name varchar2(100); ALTER
> TABLE rhnErrataTmp MODIFY advisory varchar2(100);
> - within the same commit an extra column was added to the rhnErrataBuglist
> table:
> ALTER TABLE rhnErrataBuglist add(href VARCHAR2(255));
> - ok, that was it
> quit
> ==============
> 
> But as I wrote already - after you resolve this, other issues may pop up.
> In that case a fresh installation would be recommended.
> 
> Regards,
> --
> Tomas Lestach
> Red Hat Satellite Engineering, Red Hat
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list


If I remember correctly we started with version 1.0 and did upgrades to 1.2 -> 1.4 -> 1.7 and now 2.0

# rhn-schema-version: 
2.0.2-1.el5

# rpm -q spacewalk-schema spacewalk-java
spacewalk-schema-2.0.2-1.el5
spacewalk-java-2.0.5-1.el5

You are correct a clean install would be the way to go. Is there a way to save my data from this install and then import into another install even if there may be missing data in some columns of the database? 

-Sajesh-