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 :( 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
