On Tue, 2013-11-26 at 11:30 +0100, "Budsjö, Martin" wrote: > I tried to upgrade from 4.0.17 to 4.2.1 the other day and no matter > what I do, I get the same result. After upgrading I can login without > any problem and all lists of tickets and graphs etc looks good. (By > the way, I really like the updates to the menus!) > > But if I open a ticket, it looks like the query builder is generating > SQL using the “repeated” column of the CustomFields table, and that > column was removed during the 4.1.11 upgrade process.
Hm -- do you also have RT4.0 tables in a different tablespace or something? RT attempts to inspect the database's list of existent columns to determine which columns are available to GROUP BY. - Alex