On Jul 4, 4:34 am, modius <[EMAIL PROTECTED]> wrote:
> On Jul 4, 5:49 am, "Dan T.W." <[EMAIL PROTECTED]> wrote:
>
> > The error is gone if I removed lFilterFields="title" from
> > <ft:objectadmin />.
>
> Not sure how that would fix the problem unless you were actually
> filtering something at the time -- and the filter itself was causing
> an issue. If you restart CF (ie. remove everything from memory) does
> the initial still continue?
>
I restarted CF and the problem persisted.
> > But now my users won't be able to filter on content. Can someone tell
> > me why it's been working fine for months then suddenly behaves this
> > way?
>
> It's not an error I've seen. But it sounds like the system is getting
> something unexpected from the database or alternatively applying the
> filter there is something wrong with something like the casting of
> certain values.
>
Only if I can find out why it's trying to a casting...
> > > qgetData (Datasource=farcry, Time=15ms, Records=0) in E:\farcry\core
> > > \packages\fourq\_fourq\getData.cfm @ 16:26:21.021
> > > SELECT
> > > title,coAuthor,teaserImage,thirdAuthor,displayMethod,publishDate,datetimecr
> > >
> > > eated,vol,expiryDate,status,mainPage,commentlog,Teaser,createdby,publisher
> > >
> > > Letter,Body,datetimelastupdated,ownedby,label,num,catContents,subTitle,fea
> > > ture,versionID,author,lastupdatedby,ObjectID,locked,lockedBy
> > > FROM DBO.dmCPAJ
> > > WHERE ObjectID = 'E5744CF4-1A4B-F8A3-945594B8574C9658'
>
> > > The thing is, it's supposed to be a custom admin for listing content
> > > objects. Why FarCry was looking for an unexisting object in my content
> > > table?
>
> Are you saying that this query returns no result if you run it in
> isolation in a query tool?
>
Yes, I looked for that objectId in both my content table and the
refObjects table. It's not there. Actually the objectId has not been
unique. After a while, it returned a different but still unexisting
objectId.
> You might try running the ADMIN > COAPI > Fix refObjects utility. Its
> a long shot but its designed to clean up inconsistencies in the
> database schema.
>
I tried that. It did not help.
> Best of luck,
>
> -- geoffhttp://www.daemon.com.au/
>
> PS. if you can't get any further, please consider contacting Daemon
> for incident support.
Thanks for trying to help. We have been evaluating FarCry for months.
If this weird situation does not get resolved. We will be forced to
drop FarCry.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
