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
-~----------~----~----~----~------~----~------~--~---
