On 17-10-2016 15:56, Fisher, Michael (SON) wrote: > > Greetings! > > > > I’ve had this error going on for the last 2 years or so (the cause > seemed to be driven by adding a new Custom Field configuration). I’ve > been on the 4.0 release for a while (upgraded to various versions > through the 2.x and 3.x series). I hoped that it would fix itself when > I migrated up to 4.4 (only done in test so far), but no such luck. > > > > It is generated any time a ticket is shown through the web interface, > so it’s a pretty frequent error! > > > > Oct 16 17:40:36 helium postgres: [5-1] ERROR: column > "main.name" must appear in the GROUP BY clause or be used in an > aggregate function at character 8 > > Oct 16 17:40:36 helium postgres: [5-2] STATEMENT: SELECT main.* > FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 > ON ( ObjectCustomFields_1.CustomField = main.id ) WHERE > (ObjectCustomFields_1.ObjectId = '33' OR ObjectCustomFields_1.ObjectId > = '0') AND (main.Disabled = '0') AND (main.LookupType = > 'RT::Queue-RT::Ticket-RT::Transaction') GROUP BY main.id ORDER BY > MIN(ObjectCustomFields_1.SortOrder) ASC > > > > When this fails, it seems to also prevent the Custom Fields > functionality from working at all, which is a bummer. > > > > I tried deleting everything from CustomFields, CustomFieldValues, > ObjectCustomFields, and ObjectCustomFieldValues, but this didn’t help. > > > > Environment: FreeBSD 9.3 (migrating to 10.3), PostgreSQL 9.1 > (migrating to 9.5), RT 4.0.24 (migrating to 4.4.1). > > > > I did a new RT 4.4.1 build/database in a VM and compared the schemas > between my upgraded RT database and the clean one, and I didn’t see > significant differences in the CustomFields, CustomFieldValues, > ObjectCustomFields, and ObjectCustomFieldValues tables. > > > Have a look at the perl SearchBuilder component, it might be that your fresh build has the latest with some adjustments to prevent the error that is thrown in your current env.
--------- RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017