[rt-users] make upgrade-database error

[Ruslan Zakirov]

Hi,

Probably the following select returns more than one row per custom
field. You should delete incorrect records and re-run upgrade:

SELECT ObjectId, Content FROM Attributes WHERE
Name = 'Category' AND  ObjectType = 'RT::CustomFieldValue';

On Thu, Mar 8, 2012 at 16:28, Joe Harris <drey111 at gmail.com> wrote:
> I am going from 3.8.8 to 4.0.4 and am running into an issue during the
> upgrade-database part.
>
> When it goes from 3.8.8 to 3.8.9 there is an error that shows:
>
>  [Thu Mar  8 12:09:37 2012] [warning]: Use of uninitialized value in
> string eq at /usr/local/src/rt-4.0.4/sbin/../lib/RT/Template.pm line
> 627, <> line 1.
> (/usr/local/src/rt-4.0.4/sbin/../lib/RT/Template.pm:627)
>
> It looks like it gets past that and moves on through till it gets to
> 3.9.5 where it dumps me out:
>
> Processing 3.9.5
> Now populating database schema.
> [Thu Mar  8 12:09:50 2012] [crit]: DBD::Pg::st execute failed: ERROR:
> more than one row returned by a subquery used as an expression
> (/usr/local/src/rt-4.0.4/sbin/../lib/RT.pm:341)
> DBD::Pg::st execute failed: ERROR:  more than one row returned by a
> subquery used as an expression
> make: *** [upgrade-database] Error 255
>
> This is our second upgrade as we have 2 RT systems.  The other upgrade
> (3.8.7 to 4.0.4) went flawless.  This upgrade is from an RT
> installation that has more custom fields and maybe a few more
> templates/scrips, but essentially it is very similar to the original
> one.
>
> Any ideas?
>
> Thanks in advance!
>
> Joe



-- 
Best regards, Ruslan.