I got the following error while upgrading (from CVS):

journal module needs upgrading

--------------------------------------------------------------------------------

(mysql): ALTER TABLE mdl_journal CHANGE assessed assessed INTEGER(10) DEFAULT '0' not null

--------------------------------------------------------------------------------

Success

--------------------------------------------------------------------------------

(mysql): ALTER TABLE mdl_journal_entries CHANGE rating rating INTEGER(10) DEFAULT '0' not null

--------------------------------------------------------------------------------

Success

--------------------------------------------------------------------------------

(mysql): SHOW COLUMNS FROM mdl_scale

--------------------------------------------------------------------------------

1146: Table 'moodle.mdl_scale' doesn't exist

An error occurred while inserting the default journal scale

Upgrading journal from 2002122300 to 2003081705 FAILED!