There should be a database table matching the rule name with rule as a prefix so if your rule name is poet, the DB table would be rulePoet. It's probably erroring out trying to create that table when it already exists. try dropping that table and re-creating the rule.
Toby Tremayne wrote: > Every time I try to add a rule, I create a cfc in the correct > location, then hen going to Admin > COAPI Management > Rule Classes I > get the error below. > I have previously added rules fine, and there are currently several > custom rules in the app working fine. But now for some reason > whenever I add a new one I get this - any ideas? > > Toby > > Error Executing Database Query. > ERROR: invalid input syntax for type oid: "" > > > > The error occurred in > /Users/poet/workspace/farcry/farcry_core/packages/farcry/alterType.cfc: > line 1108 > Called from > /Users/poet/workspace/farcry/farcry_core/packages/farcry/alterType.cfc: > line 1089 > Called from > /Users/poet/workspace/farcry/farcry_core/packages/farcry/alterType.cfc: > line 1030 > Called from > /Users/poet/workspace/farcry/farcry_core/admin/admin/coapiRules.cfm: > line 92 > Called from > /Users/poet/workspace/farcry/farcry_core/packages/farcry/alterType.cfc: > line 1108 > Called from > /Users/poet/workspace/farcry/farcry_core/packages/farcry/alterType.cfc: > line 1089 > Called from > /Users/poet/workspace/farcry/farcry_core/packages/farcry/alterType.cfc: > line 1030 > Called from > /Users/poet/workspace/farcry/farcry_core/admin/admin/coapiRules.cfm: > line 92 > > 1106 : not a.attnotnull as isnullable > 1107 : FROM pg_catalog.pg_attribute a > 1108 : WHERE a.attrelid = '#getTableId.oid#' AND a.attnum > 0 > AND NOT a.attisdropped > 1109 : ORDER BY a.attnum > 1110 : </cfquery> > > > > ----------------------------------- > > Life is poetry, write it in your own words > > ----------------------------------- > > Toby Tremayne > Senior Technical Consultant > Lyricist Software > 0416 048 090 > ICQ: 13107913 > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
