> distinctquery, Tickets main WHERE (main.id = distinctquery.id) Shouldn't be present a comma between Tickets and main?
> -----Messaggio originale----- > Da: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Per conto > di Jesse Vincent > Inviato: mercoledì 10 ottobre 2007 15.42 > A: Emmanuel Lacour > Cc: [email protected] > Oggetto: Re: [rt-users] Chart grouped by customfield > > > On Oct 10, 2007, at 9:38 AM, Emmanuel Lacour wrote: > > > On Wed, Oct 10, 2007 at 09:09:58AM -0400, Jesse Vincent wrote: > >> > > > > Hi, dear RT primary Author ;) > > > >> what shows up in your error logs? > > > > That's the good question ... sorry I forgot to look here :( > > > > I suspect that it has to do with "this was tested on mysql and pg" > > Any oracle folks see what we're doing wrong with that SQL? > > > There is DBD prepare errors: > > > > RT: RT::Handle=HASH(0x8134df1c) couldn't prepare the query 'SELECT > > COUNT(main.id) AS id, ObjectCustomFieldValues_1.Content AS > col1 FROM ( > > SELECT DISTINCT main.id FROM Tickets main LEFT JOIN > > ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( > > ObjectCustomFieldValues_1.CustomField = '1' ) AND ( > > ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND ( > > ObjectCustomFieldValues_1.Disabled = '0' ) AND ( > > ObjectCustomFieldValues_1.ObjectId = main.id ) WHERE > (main.Status != > > 'deleted') AND (main.Status != 'resolved') AND (main.Type = > 'ticket') > > AND (main.EffectiveId = main.id) ) > > distinctquery, Tickets main WHERE (main.id = distinctquery.id) > > GROUP BY ObjectCustomFieldValues_1.Content > > > > 'ORA-00904: "OBJECTCUSTOMFIELDVALUES_1"."CONTENT": invalid > identifier > > (DBD ERROR: error possibly near <*> indicator at char 596 > in 'SELECT > > COUNT(main.id) AS id, ObjectCustomFieldValues_1.Content AS > > col1 FROM ( SELECT DISTINCT main.id FROM Tickets main LEFT JOIN > > ObjectCustomFieldValues ObjectCustomFieldValues_1 > > > > > > Here is more information on my setup: > > > > DBIx-SearchBuilder-1.49 > > DBD-Oracle-1.19 > > Oracle Xe 10.2.0.1 > > Perl 5.8.8 > > > > Thanks for your help :) > > > > _______________________________________________ > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > Community help: http://wiki.bestpractical.com Commercial support: > > [EMAIL PROTECTED] > > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com > > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
