You said you had it deployed at one time though, right? I believe it stores a copy of it in the application scope.
Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 Toby Tremayne wrote: > Hi Jake, > > no actually I checked that. The table isn't there, and I've removed > all references I know of to the rule in the database. What's > happening is that in alterType.cfc it's trying to get the details of > the table and columns from the postgres catalog, and coming back with > nothing because there's no table there. The second query is then > erroring because the first one came back with nothing. > > What's getting me though is that even though I remove the file and all > references, and get it to work - as soon as I put the file back it's > dying. It's like it's automatically adding the rule name to > application.rules, and the page that's supposed to come up in admin is > crapping out because it's trying to do something with that rule, even > though it hasn't been deployed yet. I'm wondering if this is perhaps > a bug in the code, or have I done something weird? > Toby > > On 13/03/2007, at 0:04 , Jake Churchill wrote: > >> 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 >>> >>> >>> >>> >> >> >> > > > > ----------------------------------- > > 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 -~----------~----~----~----~------~----~------~--~---
