Approval Problem

[Jason]

Hiya Folks

 

I need some assistance, I have trying to resolve this issue by re-installing several times now (19 if your counting), and I cant get it right.

 

When trying to approve content I get this error message. (see screen shot).

 

Ok, if you can me what I did wrong, or what I got to check for or do to overcome this problem.

 

Thanks

Jason

[modius]

On May 27, 4:19 pm, Jason <j...@blueflight.net> wrote:
> I need some assistance, I have trying to resolve this issue by re-installing
> several times now (19 if your counting), and I cant get it right.

Stop reinstalling -- it won't help ;) It appears that you are missing
the FriendlyURL config for some reason.

What version of FarCry are you attempting to install? What database
and what operating system? I'm sure its a relatively simple fix to
get things going.

-- geoff
http://www.daemon.com.au/

[Jason]

Thanks for the quick reply.

 

FC version is 3.0.1

DB is msSQL 2005 sp2

OS: Both windows 2003 (via vpc 2007) & XP

 

Ok, and where or why would this happen, did i copy something incorrectly?

 

Jason

[modius]

On May 27, 9:07 pm, Jason <j...@blueflight.net> wrote:
> Thanks for the quick reply.
>
> FC version is 3.0.1
> DB is msSQL 2005 sp2
> OS: Both windows 2003 (via vpc 2007) & XP
>
> Ok, and where or why would this happen, did i copy something incorrectly?

If you are starting out development then you should download 4.0 -- if
you can wait a couple of days the bright shiny new FarCRy 4.0 with CMS
plugin suite will be ready.

If you are working with 3.0 in general you should be using the 3.02
release.

With respect to your specific problem, it is likely you do not have
the FriendlyURL table correctly deployed. Did you run the updaters
for this release? If the latter doesn't make any sense its probably
your issue. Updaters can be found under something like
http://localhost/farcry/updates

Hope that helps,

-- geoff
http://www.daemon.com.au/

[Andrew Scott]

Hi guys and Gals,

I am hoping someone can help me, I have done a quick search but can't seem
to net any results and am about to delve into the code for an answer. But
before I do I am posting here for some help on how.

One of our clients has a limit on how big the database can grow, I have only
just switched on archive / history of content for rollbacks. But Audits have
been on from day dot, but it appears that the database is too close to its
limit so this is an urgent solution or answer as quickly as possible.

How can one remove the audit trail and archive from a predefined date in the
past?

Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

[Andrew Scott]

Another repost, as this is very urgent now.

 

Hi guys and Gals,

 

I am hoping someone can help me, I have done a quick search but can't seem to net any results and am about to delve into the code for an answer. But before I do I am posting here for some help on how.

 

One of our clients has a limit on how big the database can grow, I have only just switched on archive / history of content for rollbacks. But Audits have been on from day dot, but it appears that the database is too close to its limit so this is an urgent solution or answer as quickly as possible.

 

How can one remove the audit trail and archive from a predefined date in the past?

 

--

[Andrew Scott]

I take it either no one knows or the developers are not interested in supporting me on this one.

Andrew Scott

[Jake Churchill]

Sorry, I’ve never dealt with this in particular but I know the reporting can take up a lot of space, likely much more than the audits.  You can clear that through the webtop

 

---

[Andrew Scott]

Jake,

 

Thanks for your response I should have said that this is V3.02 and I do not see that option? Can you tell me where that option actually is in the webtop?

 

Much appreciated for your response.

[Jake Churchill]

On my install (3.0.2) you go to the reporting tab and on the left under Maintenance you have “Clear Stats Log”.  Click it and you’ll be able to select the time frame in which you want to clear the log. 

 

---

From: farcr...@googlegroups.com [mailto:farcr...@googlegroups.com] On Behalf Of Andrew Scott
Sent: Sunday, May 27, 2007 11:36 PM
To: farcr...@googlegroups.com
Subject: [farcry-dev] Re: Audits and Archives

[Andrew Scott]

Jake,

 

Cheers for your help, but when I ran that it timed out. And now it just errors each and every time I try to run it.

 

But when I look at the content archives they are still sitting there which tells me that doesn’t do what I want it to do.

 

I could sit here and write a query to do the job myself, but I do not know enough about the relationships in the tables to make the script or code to do the job myself as yet.

 

Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

 

 

From: farcr...@googlegroups.com [mailto:farcr...@googlegroups.com] On Behalf Of Jake Churchill
Sent: Monday, 28 May 2007 3:17 PM
To: farcr...@googlegroups.com
Subject: [farcry-dev] Re: Audits and Archives

 

On my install (3.0.2) you go to the reporting tab and on the left under Maintenance you have “Clear Stats Log”.  Click it and you’ll be able to select the time frame in which you want to clear the log. 

[modius]

On May 28, 3:47 pm, Andrew Scott <andrew.sc...@aegeon.com.au> wrote:
> Cheers for your help, but when I ran that it timed out. And now it just
> errors each and every time I try to run it.
>
> But when I look at the content archives they are still sitting there which
> tells me that doesn't do what I want it to do.
>
> I could sit here and write a query to do the job myself, but I do not know
> enough about the relationships in the tables to make the script or code to
> do the job myself as yet.

To remove data from the audit table.. feel free to truncate the table
completely. There are no relationships -- its a log only. With
respect to archives, you can delete records from the dmArchive table
using datetimecreated as the property to limit your deletes.

The only purge option available is for stats -- if that times out then
you have too many stats. My overall recommendation to folks who can't
periodically prune the stats table, is to turn off stats completely
and use your web logs or Google Analytics.

Regards,

-- geoff
http://www.daemon.com.au/

PS. These community forums are not an appropriate place for emergency
support -- the "developers" only peruse the forums when they have free
time and generally in their own time. You might consider a commercial
support contract to address priority issues.

[AJ Mercer]

To disable stats
Admin -> Config Files -> General --> LogStats = No

--
If you are not living on the edge,
You are taking up too much space.

[Andrew Scott]

So with regards to dmArchive?

 

What about objects in here that are labeled as type dmArchive, would it be safe to assume that this can be joined by the ObjectID with the ArchiveID from what I see these 2 objects need deleting.

 

On 5/28/07, modius <mod...@gmail.com> wrote:

--

[iHuman]

Hi,

I am trying to add styles to tinyMCE editor, and it doesn't seem to
work. I added theme_advanced_styles, as in the previous version, but
it doesn't work in Gonzales.

I have changed several things in the tinyMCE editor config file
(admin > config files > tinyMCE) and nothing makes a difference. I
also ran update to refresh the scope after doing so.

Because there is a custom Farcry button as one of the menu items in
the editor, I am assuming that tinyMCE is getting its config
information from somewhere other than the built in config. Clues to
where this is located?

Any suggestions?

thanks,
elaine

[MJB]

Hi iHuman

The config is no longer used by default by the formtool "richtext". If
you want to use the config add the ftConfig metadata to the richtext
property. ie. ftConfig="tinyMCE.tinyMCE_config"

If you are trying to update a core type like dmHTML you will need to
extend dmHTML in your project by creating a dmHTML.cfc in your /
project/packages/system directory. It will look something like the
following...

<cfcomponent extends="farcry.core.packages.types.dmHTML" >

<cfproperty ftSeq="12" ftwizardStep="Body" ftFieldset="Body"
name="Body" type="longchar" ftType="richtext"
ftConfig="tinyMCE.tinyMCE_config" />

</cfcomponent>

If you really want to see how any of these formtool types work, take a
peak at /farcry/core/packages/formtools/richtext.cfc and the edit
function is what returns the formtool edit renderer. This is not for
the faint of heart.

[Matthew Bryant]

Hy Jason,

The first thing I would suggest is to use FC 3.0.2. This has a bunch of fixes to 3.0.1 which is over 1 year old.

Ideally, new development should be done on 4.0.1 which is feature complete and final testing being done as we speak. Expect official release any day now.

Kind regards

--

-- Matthew Bryant

Product Development Manager

Daemon Internet Consultants

Adobe Solutions Partner

http://www.daemon.com.au/

p. 02 9380 4162

f. 02 9380 4204

[Andrew Scott]

Geoff,

You answered my question, but still need an answer with the objects table.
Would it be safe to delete the dmArchive archive object type in this table
with the archiveId in the dmArchives table?

Wish there was better support on these issues, or even docs:-(

[Zocoloco Studios]

Thanks! This is exactly what I was looking for!
elaine

[Zocoloco Studios]

I added HTML content to make a Global SideBar, called from the
dmSideBar.cfm. Part of this HTML content includes an embedded
container for news items <con:container --- which contains Global
News - another container I made with newsitems.

The Global Sidebar works fine EXCEPT it will not display the embedded
Global Container.

Any suggestions?

thanks,
elaine

[Jake Churchill]

How are you naming the containers? In my experience, both unique and global
containers are called with <con:container... the difference is the name. If
#stObj.objectID#_ is prepended to the name then it is unique. If it is just
a name like "sidebar" or something, then it is global because there is no
way to tie it to the object id of the dmHTML object which references it.

-----Original Message-----
From: farcr...@googlegroups.com [mailto:farcr...@googlegroups.com] On
Behalf Of Zocoloco Studios
Sent: Tuesday, May 29, 2007 6:21 PM
To: farcr...@googlegroups.com

[Matthew Bryant]

Hi Elaine,

Nesting containers in Farcry does not work. At the beginning of a container it initializes request.aInvocations. If you nest containers, the request.aInvocations has been flushed in the child... well.... it just don't work.

Make sure you are logged in and then append "debug=1" to the end of the url of a page where a nested container is located and you should see this error. It will show itself because the container will be looking at a position in the array but that position will not exist. Their are exceptions to this if 1 container does not have anything published in it but I cant remember off hand the scenario.

Basically, if you are using nested containers, there will be an alternate (perhaps better) approach.

If I have totally misunderstood your problem then I apologize in advance ;)

Kind regards

--

-- Matthew Bryant

Product Development Manager

Daemon Internet Consultants

Adobe Solutions Partner

http://www.daemon.com.au/

p. 02 9380 4162

f. 02 9380 4204

[Matthew Bryant]

Hi Elaine,

Nesting containers in Farcry does not work. At the beginning of a container it initializes request.aInvocations. If you nest containers, the request.aInvocations has been flushed in the child... well.... it just don't work.

Make sure you are logged in and then append "debug=1" to the end of the url of a page where a nested container is located and you should see this error. It will show itself because the container will be looking at a position in the array but that position will not exist. Their are exceptions to this if 1 container does not have anything published in it but I cant remember off hand the scenario.

Basically, if you are using nested containers, there will be an alternate (perhaps better) approach.

If I have totally misunderstood your problem then I apologize in advance ;)

Kind regards

--

-- Matthew Bryant

Product Development Manager

Daemon Internet Consultants

Adobe Solutions Partner

http://www.daemon.com.au/

p. 02 9380 4162

f. 02 9380 4204

On 30/05/2007, at 9:20 AM, Zocoloco Studios wrote:

[Andrew Scott]

Geoff,

I am still seeking a definitive answer to my question.

Can the dmArchive type in the objects table that has the same archiveId in
the dmArchive table be deleted as well. I am assuming yes but would like to
know 100% before I do this on a production server database.

Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273

-----Original Message-----
From: farcr...@googlegroups.com [mailto:farcr...@googlegroups.com] On
Behalf Of modius
Sent: Monday, 28 May 2007 7:20 PM
To: farcry-dev
Subject: [farcry-dev] Re: Audits and Archives

[modius]

On May 30, 2:07 pm, Andrew Scott <andrew.sc...@aegeon.com.au> wrote:
> I am still seeking a definitive answer to my question.

May I politely remind you, again, that this is not a commercial
support forum and FarCry is an open source solution. If you want
"definitive" answers when you want them, may I suggest you consider
paying for them.

> Can the dmArchive type in the objects table that has the same archiveId in
> the dmArchive table be deleted as well. I am assuming yes but would like to
> know 100% before I do this on a production server database.

There is no objects table. Are you referring to the refObjects
table? If so you can run the refObjects repair utility (ADMIN > COAPI
utils) after you have truncated the dmArchive table. refObjects is
simply a lookup table for determining typename. Having orphaned
dmArchive objects in this table should not affect the system
adversely. But as always, I would recommend backing up your database
prior to any operation of this kind.

[Andrew Scott]

Geoff,

Yes you can politely remind me that this is not a commercial support forum.
However when I read the wiki it stated as I posted that most automate this
process. Yet when you go looking to see how people have automated this
process there are no examples what so ever.

Secondly, someone like yourself could have been a bit more descriptive about
what is needed in the first place. I did say that I am not that familiar
with the relationships etc, if any and that I am seeking advice on that
matter of how to go about it.

And yet when I made mention of (yes the refObjects table) it wasn't
discussed by anyone.

Now if the wiki says that most people automate this procedure, that means
there are people here who could have answered that question. Yet I really
only got half the answer to my question, now that might be because I didn't
explain myself that well. But when you are learning, we don't always say
what you guys already know.

I just felt that when I asked a question, and only got half an answer to
what I asked I am left wondering why the Farcry CMS system is not fully
documented after all this time. I even went looking for the API's to 3.0+
and all I can find is 2.03 API's. I understand that you guys do this and
have it opensourced, but a bit more documentation wouldn't go astray:-)

Now, the thing as I stated I want to truncate and remove all objects that
are older than a certain date (archived objects) the reason for this is that
our client has a limit on the size that database can be, I made that very
clear and wanted to know what I need to do to remove these references. So if
I truncate the dmArchive table, if there is any other table that has link
based on that dmArchiveId then I want to remove that as well.

What is the point of only doing half the job? If we have the chance to clean
the DB properly then we should do that, and I find that leaving orphaned
data behind a lack of care by any programmer. And if that is your answer
about leaving orphaned files behind, then I am seriously debating on the
future of Farcry as its developers do not care about the product at all.

So if I was to go back to my Boss and say well we can do this, but it is
going to leave this and that and I am not sure if it is going to hinder the
rest of the application. And then show him the response I got, how is that
going to be any good for Farcry in the future?

So I appreciate your help on this matter, but seriously I am going to be
recommending we move away from Farcry based on the answer that Geoff has
outlined below.

Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

-----Original Message-----
From: farcr...@googlegroups.com [mailto:farcr...@googlegroups.com] On
Behalf Of modius
Sent: Wednesday, 30 May 2007 4:05 PM
To: farcry-dev
Subject: [farcry-dev] Re: Still seeking an answer Geoff : RE: [farcry-dev]
Re: Audits and Archives

Having orphaned dmArchive objects in this table should not affect the system
adversely.

Regards,

-- geoff
http://www.daemon.com.au/

[Jason]

Hi Andrew,

Out of curiosity how many records are in your dmArchive table? I think
the largest dmArchive table I have seen from our biggest client has
around 7000 records. I am not sure what sort of gain you would get by
truncating a table of this size. Remember this table is only populated
when you create draft objects and archive items etc.

Are you sure you just don't need to purge the stats table which can
definitely grow to a large amount if not regularly purged. If you have
space limitations I would disable stats and rely on the weblogs for
reporting purposes. Is this sql server? In which case a good starting
point is to also check the databases transaction log and consider
truncating and shrinking it. You should definitely do this if you have
just purged an extremely large stats table. A guide for truncating and
shrinking sql logs is available at:

http://www.sql-server-performance.com/fg_sql_server_agent.asp

FYI the fixrefobjects function Geoff mentioned removes orphan records
from the refobjects table.

Regards,
Jason.

[Michael Sharman]

Andrew,

> So I appreciate your help on this matter, but seriously I am going to be
> recommending we move away from Farcry based on the answer that Geoff has
> outlined below.

The phrase 'unbelievable' comes to mind right about now.

1. If you'd base recommendations on a product based upon this then I
really wouldn't want you to be my vendor of choice.

2. If you'll read Geoff's response you'll see that in both cases he
has helped you out. Firstly with 'pruning' of the dmStats table (and
he even suggests other means of collecting stats) and in the second
with deleting data from dmArchive.

Note that in his final response (see below) he actually gives you a
way to clean these 'orphaned' records in the refObjects table. What he
does say is that "Having orphaned dmArchive objects in this table
should not affect the system adversely". In others words...it won't
result in a system meltdown if (and only if) you didn't use the repair
utility!

>>>
Are you referring to the refObjects table? If so you can run the
refObjects repair utility (ADMIN > COAPI utils) after you have
truncated the dmArchive table. refObjects is simply a lookup table for

determining typename. Having orphaned dmArchive objects in this table
should not affect the system adversely. But as always, I would

recommend backing up your database prior to any operation of this
kind.
>>>

Andrew this forum and many others are about a knowledge share when the
community can find the time. We'd all like more time to help each
other out but sometimes that just isn't case as I would hope you
understand.

Posting 3 messages within a few hours and having a tantrum when you
don't get the response you want if quite frankly childish behaviour
which really doesn't foster the community spirit.

Please remember that we are all here to help each other, also don't
forget to read responses carefully as you might find that you actually
did get the answer you were looking for.

Michael

[modius]

On May 31, 2:07 pm, Andrew Scott <andrew.sc...@aegeon.com.au> wrote:
> What is the point of only doing half the job? If we have the chance to clean
> the DB properly then we should do that, and I find that leaving orphaned
> data behind a lack of care by any programmer. And if that is your answer
> about leaving orphaned files behind, then I am seriously debating on the
> future of Farcry as its developers do not care about the product at all.

As per my last email, there is a dedicated utility for repairing
refObjects for all registered content types:
ADMIN > COAPI Management > Fix refObjects Table

My reference to orphans was simply that having them will not break the
system.

I've added a page to the WIKI to get you started, anything you can add
to the documentation would be appreciated:
http://docs.farcrycms.org:8080/confluence/display/FCDEV40/refObjects+Table

> So I appreciate your help on this matter, but seriously I am going to be
> recommending we move away from Farcry based on the answer that Geoff has
> outlined below.

Sorry the community was unable to help sufficiently.

[Andrew Scott]

Jason,

1) We have around 17K of records in there, that are going back around 2
years.

2) It is possible that the stats need to be purged often, but I have already
done that. And it is switched off.

3) I do not have access to the DB from an Admin point of view, only from a
user point of view. And this needs to be an automated option that runs once
a week, nightly and left at that.

Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

-----Original Message-----
From: farcr...@googlegroups.com [mailto:farcr...@googlegroups.com] On
Behalf Of Jason
Sent: Thursday, 31 May 2007 4:23 PM
To: farcry-dev
Subject: [farcry-dev] Re: Still seeking an answer Geoff : RE: [farcry-dev]
Re: Audits and Archives

[Andrew Scott]

Michael,

But he should've given that option first and foremost the first time I asked
the question. To then say that orphaned entries shouldn't be a problem is
suspect to me, there should never be orphaned entries.

And that comes from the people who started Farcry, what sort of support do
you call that.

Lets all leave orphaned entries in the database...

[Jason]

Andrew,

Maybe that's because what you are doing is actually outside of the
Farcry framework? But hey guess what, even if you do something like
this outside of the farcry framework there is a tool to help you fix
it! And Geoff even told you what that tool was, before adding that if
you chose not to use this tool it would not adversely affect the
system in any case (which you have kindly chosen to take out of
context).

If your real complaint is that within Farcry there should be an option
to truncate/purge dmArchive then sure feel free to make a suggestion
on this list or even better log it at:

http://bugs.farcrycms.org:8080/secure/CreateIssue!default.jspa

You can categorise it as improvement. If you go ahead and build a tool
to do this yourself even better! Contribute it back to the farcry code
base after all that's what is great about being open source. However
you must consider this one particular feature you have requested is
not something there has been a great demand for, so it's probably
understandable that the documentation for it is lacking. Most people
who run Farcry do not have a problem with dmArchive being too big.

And please remember this is the farcry dev list not the farcry support
list with guaranteed 3 hour turn around response time or your money
back list. Most of us would prefer this remain a place where you can
ask questions, exchange ideas and talk about farcry development. Not
"demand" answers.

Regards,
Jason.

[Andrew Scott]

Jason,

Actually, I think you are taking me well and truly out of context.

Yes this is needed to be run inside farcry, on an automated basis.

No I did not ask for this as a feature.

I just wanted to know how to do it, I could see that there was at least 2
tables that could be impacted on with me doing this. I needed one to make
sure that my approach was correct, and my heart sank when the wiki said
people are automating it and there was no docs on what tables are affected,
or what tables are linked.

I made that very clear in my very first post.

Now what I do not like is a fellow developer saying I can truncate one
table, and leave orphaned entries in another table that is just pure
stupidity to have even mentioned it in the first place.

[Andrew Scott]

Well then let me say this then.

I am a developer, developing a website with Farcry CMS. There is no
documentation to look at, no flow charts and no DB diagrams to ponder over.

So where the hell do you go then?

I asked a simple question on how do I do something, I got half the answer
simple as that.

So I should be able to ask what about? Without people like you taking it out
of context.

Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

-----Original Message-----

From: farcr...@googlegroups.com [mailto:farcr...@googlegroups.com] On

Behalf Of Jason
Sent: Thursday, 31 May 2007 5:00 PM
To: farcry-dev
Subject: [farcry-dev] Re: Still seeking an answer Geoff : RE: [farcry-dev]
Re: Audits and Archives

Andrew,

[Jason]

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.

[Andrew Scott]

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...

[modius]

On May 31, 6:16 pm, "Andrew Scott" <andrew.sc...@aegeon.com.au> wrote:
> 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.

Orphaning records is *not* something we advocate. It is important to
understand that orphaning records in this sceanrio will not cause the
system to fail -- it gives you options for approaching the task at
hand. You have chosen to interpret this statement as a
recommendation. It was not.

There is a tool designed to clean up orphans in refObjects. Removing
orphans is a common requirement if you are migrating, truncating or
otherwise bypassing the application framework to manipulate the
underlying data model. We built this tool specifically to address
this issue as we do *not* advocate leaving orphaned references in the
system.

I understood you needed to truncate records in a hurry and get your
database into a manageable state. Therefore, I outlined a perfectly
adequate and immediate response for the scenario. It's unfortunate
that my best intentions have been so misconstrued.

> 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.

This is not correct. And is one of the reasons this was not part of my
response.

The relationship between refObjects and all content type tables is
based on objectid and *not* dmarchive.archiveid. archiveid is a
reference to the live content object that is currently being
versioned. It is not the primary key of the dmarchive table.

If you are deleting objects from dmArchive table then you need to
remove records from refObjects that match refobjects.objectid to
dmArchive.objectid and are of typename "dmarchive". Removing
references that match dmarchive.archiveid to refobjects.objectid will
corrupt the refobjects table.

Finally, I would not recommend the periodic truncation of the
dmArchive table based on a simple timestamp as a matter of course.
These records represent the ability to "roll back" to previous
iterations of a piece of content. Just because an archive is older
does not mean it is less important. It would be better to attempt to
limit individual content items to a set number of roll back points.
For example, each content item can only have a maximum of 3 archives.

[Beth Bowden]

How to learn FarCry? My approach was to read all the source code. It
took a day but has repaid me many times in time saved later.

It's a given that I'm a geek but I love that FarCry is open source and
I can go straight to the source.

Beth

[Andrew Scott]

Now there is a nice little tid bit...

 

Is this a setting in the webtop? And also if I was to set this, would it be safe to still truncate the data older than 6 months for example? Which is what i want to do in the first place.

 

On 5/31/07, modius <mod...@gmail.com> wrote:

Finally, I would not recommend the periodic truncation of the
dmArchive table based on a simple timestamp as a matter of course.
These records represent the ability to "roll back" to previous
iterations of a piece of content.  Just because an archive is older
does not mean it is less important.  It would be better to attempt to
limit individual content items to a set number of roll back points.
For example, each content item can only have a maximum of 3 archives.

Regards,

-- geoff
http://www.daemon.com.au/

[Andrew Scott]

Beth,

 

Nice if you have the time to do so...

 

[iHuman]

Hi,

I would like to only display the multiPageNav if there is more than
one page.

I saw a post that used cfif with r_Pages.recordcount gt 1 and tried
this, but it returns an error. I am assuming r_Pages is no longer
used in Gonzales?

What would be used in its place?

thanks,
elaine