nvmd, I always forget to refresh app scope before posting silly emails... it
all seems to work now, though I don't quite like my kludge for fixing the
NULL error.
Tomek
On Fri, Sep 5, 2008 at 8:38 AM, Tomek Kott <[EMAIL PROTECTED]> wrote:
> Hmm, so I found lines 164 and 165 in /core/packages/rules/rules.cfc
> <cfset stProperties.webskinTypename = "" />
> <cfset stProperties.webskinTemplate = "" />
> Clearly for me, part of the problem is that Oracle interprets "" as NULL
> instead of Empty String, so trying to put that in fails. So I tried just
> putting in a space, which takes care of the errors I'm seeing.
>
> However, now what is happening is this: When I try to view the page in
> design mode, everything shows up great! However, when I try to view things
> normally (even with admin logged in), everything disappears again... Any
> ideas why its disappearing and not throwing an error, even with ?debug=1
> passed in?
>
> Thanks,
>
> Tomek
>
> On Fri, Sep 5, 2008 at 7:57 AM, Tomek Kott <[EMAIL PROTECTED]> wrote:
>
>> Hi All,
>>
>> I turned on the object broker webskins by extending the types and rules
>> that I used like Joel suggested. The HTML pages are certainly loading faster
>> now. However, it now appears that I have the following errors on all the
>> rules on any of my HTML pages.
>>
>> Error with rule 'Events: Calendar Rule'
>> Error Executing Database Query.
>> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into
>> ("GSG"."DMWEBSKINANCESTOR"."WEBSKINTEMPLATE")
>>
>>
>> Error with rule 'Utility: Handpicked Rule'
>> Error Executing Database Query.
>> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into
>> ("GSG"."DMWEBSKINANCESTOR"."WEBSKINTEMPLATE")
>>
>>
>> Error with rule 'Events: Listing Rule'
>> Error Executing Database Query.
>> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into
>> ("GSG"."DMWEBSKINANCESTOR"."WEBSKINTEMPLATE")
>>
>> It looks like a simple enough problem to fix, if I knew which file the
>> queries were coming from! If you have any ideas,please let me know, I'll be
>> happy to fix them for me and others using Oracle!
>>
>> Tomek
>>
>>
>> On Thu, Sep 4, 2008 at 11:00 PM, Joel Cass <[EMAIL PROTECTED]> wrote:
>>
>>> Hi Tomek,
>>>
>>>
>>>
>>> No, unless you add any new properties, extending existing types happens
>>> automatically (you just need to restart the application)
>>>
>>>
>>>
>>> Cheers
>>>
>>>
>>> ------------------------------
>>>
>>> *From:* [email protected] [mailto:[EMAIL PROTECTED]
>>> *On Behalf Of *Tomek Kott
>>> *Sent:* Friday, 5 September 2008 11:55 AM
>>> *To:* [email protected]
>>> *Subject:* [farcry-dev] Re: ObjectBroker default settings
>>>
>>>
>>>
>>> Thanks Joel and Mat. Not the answer I wanted to hear, but hey, what can
>>> you do.
>>>
>>>
>>>
>>> So now I just have what might sound like a silly question but might be an
>>> important one for my understanding of farcry.
>>>
>>>
>>>
>>> If I were to extend the objects like you, Joel, suggest, wouldn't I have
>>> to deploy all those types again under farcry admin and transfer all the
>>> information over to the new types? Or would it simply override the default
>>> options to some extent?
>>>
>>>
>>>
>>> Thanks for the input,
>>>
>>>
>>>
>>> Tomek
>>>
>>>
>>>
>>> On Thu, Sep 4, 2008 at 8:34 PM, Joel Cass <[EMAIL PROTECTED]> wrote:
>>>
>>> Just extend all the objects that you use and add the
>>> oObjectBrokerWebskins attribute, e.g.
>>>
>>>
>>>
>>> <cfcomponent extends="farcry.core.packages.types.dmHTML" bObjectBroker=
>>> "true" objectbrokermaxobjects="100" lObjectBrokerWebskins="display*">
>>>
>>>
>>>
>>> </cfcomponent>
>>>
>>>
>>>
>>> Place all files under /farcry/projects/<projectName>/packages/types and
>>> that way when you next upgrade farcry you won't need to worry about your
>>> changes being overwritten.
>>>
>>>
>>>
>>> But yeah, serious bummer about the hosting. We had a similar problem with
>>> another client where every single query takes 300ms to execute, no matter
>>> how small.
>>>
>>>
>>>
>>> Avoid low-budget shared hosting providers as much as possible. Just
>>> getting farcry setup correctly is a headache.
>>>
>>>
>>>
>>> My 2c
>>>
>>>
>>> ------------------------------
>>>
>>> *From:* [email protected] [mailto:[EMAIL PROTECTED]
>>> *On Behalf Of *Tomek Kott
>>> *Sent:* Friday, 5 September 2008 7:44 AM
>>> *To:* farcry-dev
>>> *Subject:* [farcry-dev] ObjectBroker default settings
>>>
>>>
>>>
>>> Hi All,
>>>
>>> Having finally set up things correctly, with content and almost
>>> everything working with my shared host setup, I am finally ready to tackle
>>> the speed issue I am facing. Most of the pages I load take anywhere between
>>> 3 to 10 seconds to load. Now, while setting things up I don't mind too much,
>>> but for a live environment, that won't quite work.
>>>
>>> I noticed that ObjectBroker was on for all the default filetypes in
>>> FarcryCMS, but that none of the webskins were being cached. I know that I
>>> can go into each type/dm*.cfc and whatnot, and add
>>> *lObjectBrokerWebskins="display*"*
>>>
>>> to include all the displayPageStandard etc., but I was wondering if there
>>> was a way to change the *default* lObjectBrokerWebskins value to use that. I
>>> believe (if I understand correctly) that this would cache any pages using,
>>> eg. the displayPageStandard with dmHTML. Is this the only way to speed up
>>> processing?
>>>
>>> I recognize that part of the problem is the host: the oracle server is
>>> not on the same machine as the CF server (I believe), so that surely adds
>>> some time. However, I think the bigger problem is probably the cache not
>>> quite working completely.
>>>
>>> Any help would be appreciated!
>>>
>>> Tomek
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> >>>
>>>
>>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
