Hi,

I have exactly the same problem and I'm on windows/IIS.

The keywords Management UI works in html and Flex. I have activated
the CF debug mode to compare the sql queries in the keywords UI and in
the categorisation tab.

In the UI we have:
SELECT * FROM nested_tree_objects
WHERE   nlevel = 0
AND typename = 'categories'

then:

SELECT nleft, nright, typename, nlevel
FROM nested_tree_objects
where objectid = 'D4A352DA-3FFF-AEA2-3879AD198B6F17A9'

where objectid is the root then:

SELECT
ntm.objectid,ntm.parentid,ntm.typename,ntm.nleft,ntm.nright,ntm.nlevel,ntm.ObjectName
FROM nested_tree_objects ntm
INNER JOIN categories t ON t.categoryid = ntm.objectid
AND ntm.nleft > 1
AND ntm.nleft <12
AND ntm.typename = 'categories'
ORDER BY ntm.nleft


which return the list of the categories.

In the edit categorisation tab, I only have this:
SELECT cat.categoryID
FROM categories cat,refCategories ref
WHERE cat.categoryID = ref.categoryID
AND ref.objectID = 'EE2E7666-3FFF-AEA2-3E07BBF062A2C4B3'

which get the categories of the current object and, more interesting:


SELECT objectname
FROM nested_tree_objects
WHERE objectid = 'D4A352DA-3FFF-AEA2-3879AD198B6F17A9'
AND typename = 'categories'

which only return root, but I suppose that's the buggy thing.

Any idea ?


Thanks

Pv


On Dec 20 2007, 4:19 pm, Zocoloco Studios <[EMAIL PROTECTED]> wrote:
> Is anyone else experiencing this issue? I just setup another clean
> install Farcry 4.09 and it has the same issue.
>
> These are setup on linux. If others are NOT experiencing this, I will
> assume it has something to do with case-sensitivity again - and will
> debugging in that direction.
>
> thanks,
> elaine
>
> On Dec 18, 2007, at 3:41 AM, modius wrote:
>
>
>
> > On Dec 18, 3:22 pm, Zocoloco Studios <[EMAIL PROTECTED]> wrote:
> >> This didn't work. I just checked thecategorycheck box for other
> >> content items (ie, regular site items) - and it doesn't work there
> >> either. I have a feeling it is a problem with the new ajax interface.
> >> That it is not displaying the child nodes.
>
> >> If anyone else has any ideas, I would appreciate it.
>
> > Does the Flex UI forcategorymanagement work?
>
> > -- geoff
> >http://www.daemon.com.au/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to