[rt-users] 4.0.0: Errors/warnings upgrading database from 3.8.7

[Kevin Falcone]

On Sun, Jun 12, 2011 at 11:54:47AM +1000, Alex Peters wrote:
> Got a couple Perl warnings and errors while attempting to
> upgrade a copy of my RT 3.8.7 schema to 4.0.0.
> 
> Ran rt-setup-database in this manner:
> 
> $INSTDIR/sbin/rt-setup-database --action upgrade --datadir
> $TARBALL/etc/upgrade/
> 
> Got these errors in order of perceived severity:

All of the important warnings/errors here have patches on 4.0.1-releng
It would be great if you retested when 4.0.1rc2 is released.

-kevin

> 1.  RTFM-related errors
> 
>     [Sun Jun 12 01:18:40 2011] [error]: You appear to be
>         upgrading from RTFM 2.0 - We don't support upgrading
>         this old of an RTFM yet ($TARBALL/etc/upgrade//3.9.8/
>         content:12)
>     [Sun Jun 12 01:18:40 2011] [error]: We found RTFM tables in
>         your database.  Checking for content. ($TARBALL/etc/
>         upgrade//3.9.8/content:15)
>     [Sun Jun 12 01:18:40 2011] [warning]: DBD::mysql::db
>         selectall_arrayref failed: Table '$DBNAME.FM_Articles'
>         doesn't exist at $TARBALL/etc/upgrade//3.9.8/content
>         line 17. ($TARBALL/etc/upgrade//3.9.8/content:17)
> 
>     These concern me because I've never even had an RTFM
>     installation to my knowledge.  Do these indicate a problem
>     with my converted 4.0.0 schema?
> 
> 2.  Other, no-op-looking errors
> 
>     Use of qw(...) as parentheses is deprecated at $INSTDIR/
>         sbin/../lib/RT/Articles.pm line 586.
>     Use of qw(...) as parentheses is deprecated at $INSTDIR/
>         sbin/../lib/RT/Articles.pm line 794.
>     [Sun Jun 12 01:18:06 2011] [warning]: Couldn't set
>         SortOrder: That is already the current value ($TARBALL/
>         etc/upgrade//3.8.8/content:32)
>     [Sun Jun 12 01:18:16 2011] [warning]: Use of uninitialized
>         value in string eq at $INSTDIR/sbin/../lib/RT/
>         Template.pm line 627, <> line 1. ($INSTDIR/sbin/../lib/
>         RT/Template.pm:627)
> 
>     I assume that these are all rather harmless.  Running Perl
>     5.14.0 if that's of any value.
> 
> Complete rt-setup-database dialogue attached, with paths/
> database connection details edited for clarity.

> $ $INSTDIR/sbin/rt-setup-database --action upgrade --datadir $TARBALL/etc/upgrade/
> Use of qw(...) as parentheses is deprecated at $INSTDIR/sbin/../lib/RT/Articles.pm line 586.
> Use of qw(...) as parentheses is deprecated at $INSTDIR/sbin/../lib/RT/Articles.pm line 794.
> In order to create or update your RT database, this script needs to connect to your  mysql instance on $DBHOST as $DBUSER
> Please specify that user's database password below. If the user has no database
> password, just press return.
> 
> Password: 
> Working with:
> Type:   mysql
> Host:   $DBHOST
> Name:   $DBNAME
> User:   $DBUSER
> DBA:    $DBUSER
> Enter RT version you're upgrading from: 3.8.7
> 
> Going to apply following upgrades:
> * 3.8.8   
> * 3.8.9   
> * 3.9.1   
> * 3.9.2   
> * 3.9.3   
> * 3.9.5   
> * 3.9.6   
> * 3.9.7   
> * 3.9.8   
> * 4.0.0rc2
> * 4.0.0rc4
> * 4.0.0rc7
> 
> Enter RT version if you want to stop upgrade at some point,
>   or leave it blank if you want apply above upgrades:
> 
> IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
> 
> Proceed [y/N]:y
> Processing 3.8.8
> Now inserting data.
> [Sun Jun 12 01:18:06 2011] [warning]: Couldn't set SortOrder: That is already the current value ($TARBALL/etc/upgrade//3.8.8/content:32)
> [Sun Jun 12 01:18:06 2011] [warning]: Couldn't set SortOrder: That is already the current value ($TARBALL/etc/upgrade//3.8.8/content:32)
> [Sun Jun 12 01:18:06 2011] [warning]: Couldn't set SortOrder: That is already the current value ($TARBALL/etc/upgrade//3.8.8/content:32)
> [Sun Jun 12 01:18:06 2011] [warning]: Couldn't set SortOrder: That is already the current value ($TARBALL/etc/upgrade//3.8.8/content:32)
> Processing 3.8.9
> Now inserting data.
> [Sun Jun 12 01:18:16 2011] [warning]: Use of uninitialized value in string eq at $INSTDIR/sbin/../lib/RT/Template.pm line 627, <> line 1. ($INSTDIR/sbin/../lib/RT/Template.pm:627)
> [Sun Jun 12 01:18:16 2011] [warning]: Use of uninitialized value in string eq at $INSTDIR/sbin/../lib/RT/Template.pm line 627, <> line 1. ($INSTDIR/sbin/../lib/RT/Template.pm:627)
> [Sun Jun 12 01:18:16 2011] [warning]: Use of uninitialized value in string eq at $INSTDIR/sbin/../lib/RT/Template.pm line 627, <> line 1. ($INSTDIR/sbin/../lib/RT/Template.pm:627)
> Processing 3.9.1
> Now inserting data.
> Processing 3.9.2
> Now inserting data.
> Processing 3.9.3
> Now populating database schema.
> Processing 3.9.5
> Now populating database schema.
> Processing 3.9.6
> Now populating database schema.
> Processing 3.9.7
> Now populating database schema.
> Now inserting data.
> Processing 3.9.8
> Now populating database schema.
> Now inserting data.
> [Sun Jun 12 01:18:40 2011] [error]: You appear to be upgrading from RTFM 2.0 - We don't support upgrading this old of an RTFM yet ($TARBALL/etc/upgrade//3.9.8/content:12)
> [Sun Jun 12 01:18:40 2011] [error]: We found RTFM tables in your database.  Checking for content. ($TARBALL/etc/upgrade//3.9.8/content:15)
> [Sun Jun 12 01:18:40 2011] [warning]: DBD::mysql::db selectall_arrayref failed: Table '$DBNAME.FM_Articles' doesn't exist at $TARBALL/etc/upgrade//3.9.8/content line 17. ($TARBALL/etc/upgrade//3.9.8/content:17)
> Processing 4.0.0rc2
> Now populating database schema.
> Processing 4.0.0rc4
> Now populating database schema.
> Processing 4.0.0rc7
> Now inserting data.
> Done.
> 
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110613/51ba3169/attachment.sig>