Jason, Correct me if I am wrong and the Farcry code makes me think that I am correct, and if a developer of farcry comes to me and says that you can truncate the dmArchive and then in the same breath, say that the orphaned files should not be an issue and then provide feedback on what to do to get rid of it. In my opinion, I got the answer. I can truncate the dmArchive table and remove files that are in the refObjects table with the dmArchiveId that was deleted in a sql query that I can run at a predefined schedule.
How hard was it to add that, but I was asking for confirmation. I appreciate everyones help, but I do not appreciate a database with orphaned files. It's that simple. And the very first answer I got was I could truncate the dmArchive table, but I wanted to just make sure that I could also delete any referenced object from other tables. And as far as posting many times, I think one of my email posts even said I am not sure if this made it to the list. Now give me one good reason to pay for support for Farcry, when the people who do support it are happy to only give half the answer? I would be more than happy to pay for the support, but not if I am going to get half the answer and get charged double for every call or email to get the full answer. Jason I am not going to discuss this with you anymore, the fact is what I asked for was not fully given and I had to again ask if it was ok to delete the entries in the refObjects table that have the same ObjectId as the archiveId in the dmArchive table, when that was in my first post to start with. Please understand our frustration, the docs are very limiting and don't help us much. I love the product because I can see how powerful it actually is. But there is not enough information on how to use the product. Like I said in a previous post, where is the API information past V2.03? I mean I look at a lot of options in the admin webtop, but there is not enough information on what each section does. How do we go back to the client and answer their questions if we can't find the answer ourselves. I appreciate this is an opensource product, I also appreciate that many people give up their time to participate and help develop it. But at the end of the day the decision on using it is going to be based on how good the support information for that product is. I did the right thing before posting to this gorup, and like I said the wiki said that people do automate this process, so why are there no examples on that then. I mean I could understand if there wasn't anything, but when the wiki says there is and you search high and low. You have no choice but to ask in here... On 5/31/07, Jason <[EMAIL PROTECTED]> wrote: > > > Andrew, > > You posted the same question 3 times in a short period of time and got > petulant when you did not receive an immediate response. Everyone on > this list has actual clients and actual project work they are working > on. We will try and check here often and answer questions as time > allows us. Once you had articulated your requirement clearly, you were > given an answer on how to achieve your goal. > > While it was not necessary for Geoff to say that if you did not choose > to clean up the refobjects table it would not adversely affect the > system, it was however true. I think what Geoff was trying to tell you > was there was no DANGER in truncating the dmArchive table and leaving > the references in the refobjects table was safe. He was not > recommending this is what you do. To then call his advice plain > stupidity I find quite offensive. > > In any case you have your answer, maybe next time a "thank you" will > suffice. > > Regards, > Jason. > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
