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
pgpCCWRqGmTHJ.pgp
Description: PGP signature
-- RT Training in Seattle, June 19-20: http://bestpractical.com/training