Even a recycle of the server doesn't seem to fix it. On 13/03/2007, at 1:15 , Jake Churchill wrote:
> 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 >> >> >> >> > > > ----------------------------------- 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 -~----------~----~----~----~------~----~------~--~---
