Hi Peter,
Don and I talked about this yesterday, and contacting you has been on my to-do list. I don't have any experience with oracle or access to an install (yet), so I definitely can't take on the whole package. I haven't seen the hierachy break yet. (Beyond annoyances like sub folders showing up in the middle of the contents of a folder - which violates what I *think* it should do, but is not high on my to-fix list.)
It looks to me like Bookmarks is at least sort of subsite aware. MY bookmarks show up regardless of which mount point I'm looking at, but others' bookmarks do not. At least that's my conclusion from 2 mins of playtime.
Ok, correction time. (Now in my 3rd minute.) You can ignore what I said up there about hierarchies not breaking or subsites working. I shouldn't post before 5am.
Mounting a second bookmarks instance and adding a new folder and bookmark in the second instance screws up the displayed hierarchy in both subsites. It adds a second root folder with the same tree_sortkeys, which goofs display of the bookmarks up in a major way.
So it looks like we have at least the following issues with at least the postgres version:
- We need to track down and stomp the query with the lack of subsite awareness. That's where the hierarchy problem is coming from, at least THIS example of the hierarchy problem.
- We need to figure out how bookmarks should behave with subsites. Displaying users' bookmarks only in the subsite they were added in seems sensible. Displaying ALL of the owner's bookmarks (regardless of instance) doesn't seem all bad to me, but displaying all of a user's bookmarks in all subsites is Bad, especially if people are building subsites with very different topics. I could sort of go either way on having all the owner's bookmarks available regardless of mount point. Other opinions? (From looking at the code, it's probably easier to confine viewing of the owner's bookmarks to the subsite they were created in.)
- It would be nice if someone with an Oracle install could check if the Oracle version has these issues also.
- I have some undeletable bookmarks in my current install. That may be related to the broken hierarchy problem.
- There's a bug report in SDM that you can see even private bookmarks in the "popular sites" display. Sounds like the query needs to be tweaked.
Peter, Do you have more problems to add to the list? Or things on that list that you already have fixes for or would like to fix? And would you want to handle the oracle side?
Donb, regarding commit privs for bookmarks, I'm happy to commit, or to have Peter commit, or we can both commit, for that matter, as long as SOMEONE is committing the bookmarks patches.
Ok, Insomnia fixed. I'm going back to bed now.
