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