> 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 > [email protected] > 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- _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
