[rt-users] make upgrade-database error

[Kai Storbeck]

On Thu, Mar 8, 2012 at 07:39 Ruslan Zakirov <ruz at bestpractical.com> 
wrote:
> 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';

Hi Ruz,

I dug this thread up from the archives, as I ran into the same error 
while doing a test upgrade.

IIUC, every CustomFieldValue needs to be updated to contain a category 
field from the old attributes table.

Rewriting the upgrade script for 3.9.5 into this:

UPDATE CustomFieldValues SET Category = att.Content
         from Attributes att
         WHERE att.ObjectId = CustomFieldValues.id
         AND att.ObjectType = 'RT::CustomFieldValue'
         AND att.Name = 'Category'

This fixed the problems for me.


Are you sure the original SQL is correct?

Regards,
Kai

> 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.