[Spacewalk-list] Error upgrading from 0.3 to 0.4

[Milan Zazrivec]

On Monday 19 January 2009 19:54:19 romain.pelissier at bell.ca wrote:
> Hi,
> I have testes the upgrade process and it fails with the schema upgrade.
> Le log show :
>
> 'SPACEWALK-SCHEMA-0.3-TO-SPACEWALK-SCHEMA-0.4/156-RHNPACKAGE-COMPAT-NUMBER.
>SQ
> ---------------------------------------------------------------------------
>--
> spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.s
>ql
>
> SQL> --
> SQL> -- Copyright (c) 2008 Red Hat, Inc.
> SQL> --
> SQL> -- This software is licensed to you under the GNU General Public
> License, SQL> -- version 2 (GPLv2). There is NO WARRANTY for this software,
> express or SQL> -- implied, including the implied warranties of
> MERCHANTABILITY or FITNESS SQL> -- FOR A PARTICULAR PURPOSE. You should
> have received a copy of GPLv2 SQL> -- along with this software; if not, see
> SQL> -- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
> SQL> --
> SQL> -- Red Hat trademarks are not licensed under GPLv2. No permission is
> SQL> -- granted to use or replicate Red Hat trademarks that are
> incorporated SQL> -- in this software or its documentation.
> SQL> --
> SQL> --
> SQL> -- $Id$
> SQL> --
> SQL>
> SQL> alter TABLE rhnPackage MODIFY (compat number(1));
> alter TABLE rhnPackage MODIFY (compat number(1))
>                                *
> ERROR at line 1:
> ORA-01440: column to be modified must be empty to decrease precision or
> scale
>
> Any help will be greatly appreciated :)

This problem was fixed in
http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=76c6badd7ea8f3191513138cd46bc350d9c01cf4
new version containing this fix is spacewalk-schema-0.4.18-1.el5.

Jesus, can we please push this updated schema live?

Thanks
-Milan