At the moment, I've ran most of the diagnostics (including rebuild tree
metadata). The one that I haven't is "Reattach Orphan Folders" which, if I
look at the cfm file, seems to have some sql queries. I think I fixed the
bigger problems with "AS" being in there, but I am still running into
problems:

1) I can't get the form to work in "flash" mode. It says RSL Failed, Please
Reload, but if I try to refresh, update app, etc. it comes back. I can get
around this by putting the mode in "html" which, while ugly, at least loads.


However, that leaves me with :

2) Nothing comes up... in any of the boxes or drop downs. I think this might
be related to the following SQL query:

SELECT objectid, label + ' (' + lnavidalias + ')' display
FROM dmNavigation
WHERE lnavidalias <> ''
ORDER BY label

Which I can't quite wrap my head around. I don't understand why you would
want to send something like "label(lnavidalias) display" ... Maybe if I knew
what that meant, I could work it out, but I'm not fluent in SQL.

I was able to get the selection boxes to populate by using the following SQL
query, but I'm not sure that it is the same thing:

SELECT objectid, label, lnavidalias  display
FROM dmNavigation
WHERE lnavidalias is not null
ORDER BY label

I've just spent some time looking through all of the tables and values, and
found FarCry Support as a title in the dmHTML table. Could it be that I just
delete from there and I'm set?

Could I also find out which file handles the delete process? just so I can
look for any Oracle SQL errors perhaps?

I don't know if I have access to backing up the database. Plus, even if I
asked the webmaster for one (which he probably has) , it would take a week
to get back to me, judging by previous emails...

Thanks,

Tomek

On Thu, Aug 21, 2008 at 12:45 AM, modius <[EMAIL PROTECTED]> wrote:

>
> On Aug 21, 10:11 am, "Tomek Kott" <[EMAIL PROTECTED]> wrote:
> > I was trying to delete the default "Support" page that exists in the
> default
> > install. I believe at the time I had "archive" turned on. When I right
> > clicked on the page and clicked delete, an error popped up saying that
> write
> > permission was unavailable (it appears that it tried to write something
> to
> > project/(name)/archive which I had set as my archive folder.
>
> This can be caused by a partial delete from the tree.  The tree
> content is removed by the array references are not correctly updated.
>
> > Now, whenever I try to access the folder in navigation (Home) where the
> > Support file was, it just keeps spinning the little loading icon. I have
> > tried resetting the refobjects table to no avail, and updating the
> > application scope.
>
> This would normally fix the problem.  Have you also run "rebuild tree
> metadata"?  I'd try running all the diagnostic utilities.
>
> > I noticed that this had been a problem before viahttp://
> bugs.farcrycms.org/browse/FC-713, and that there was a workaround
> > involving some setting. I have tried this as well, also to no avail.
>
> Yeah this is a rare but seemingly persistent bug.  If the diagnostic
> utilities don't work would you mind attaching a backup of the database
> to the issue database that we can review?
>
> > I would much prefer to not have to move the entire home folder to trash
> and
> > start over, but can if that is the only solution. I just wanted to see if
> > anyone else had ran into the same problem.
>
> Yeah.. don't trash Home.  That would not be good.  Might be easier to
> spin up a fresh install and use that database.  These issues are
> generally relatively easy to fix fro the database level if you have an
> understanding of the nested tree model schema and navigation folders.
> But in any event it shouldn't be happening in the first place and i'd
> like to get to the bottom of it.
>
> 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