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_1Here 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
PGP.sig
Description: This is a digitally signed message part
_______________________________________________ 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
