[rt-users] make upgrade-database error

[Kevin Falcone]

On Fri, May 03, 2013 at 02:47:24PM +0200, Kai Storbeck wrote:
> 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.

Since this doesn't break on a 'clean' RT 3.8 with categories, I - like
ruz - suspect some bad data in your tables.  I'd like to see what he
requested.

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

Or potentially a slightly modified form:
SELECT Content, CustomFieldValues.id, CustomFieldValues.Name FROM
Attributes, CustomFieldValues WHERE Attributes.Name = 'Category' AND
ObjectType = 'RT::CustomFieldValue' AND CustomFieldValues.id =
Attributes.ObjectId;

Tweak that to find the places with multiple values.

> Are you sure the original SQL is correct?

The original SQL works fine on a test upgrade.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130528/2c8a84c7/attachment.sig>