This looks like an Oracle bug. Do you want to submit it to
bugs.farcrycms.org.
Cheers,
--Mat.
On Fri, Sep 5, 2008 at 10:47 PM, Tomek Kott <[EMAIL PROTECTED]> wrote:
> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>
> >
>
--
--
-- Matthew Bryant
Product Development Manager
Daemon Internet Consultants
Adobe Solutions Partner
http://www.daemon.com.au/
p. 02 8302 4600
f. 02 9380 4204
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
