So Sean you where right it's all about the publish date not being set, that's the issue, for now i will just go and generate all old articles in the dmNews table, don't have to update those articles anyway soon, then if neccesary for specific article i can update individual. Not a best solution but can get going now...
On Aug 6, 10:49 am, Marco van den Oever <[email protected]> wrote: > Ah ok perfect, only when i use the BER version 018 and FC 6.0.3 i have > some other errors. > > I can click overview and site tabs but content and admin tabs give > error like: > > Message The parent argument must be a webtop struct or an id path > specifying an existing webtop struct > Exception Type application > > * C:\websites\Farcry\core\packages\farcry\webtop.cfc (line: 334) > * C:\websites\Farcry\core\tags\admin\subSectionOverview.cfm (line: 51) > * C:\websites\Farcry\core\webtop\custom\content.cfm (line: 9) > > On Aug 6, 4:34 am, AJ Mercer <[email protected]> wrote: > > > I have posted about missing dates for news and events when using Railo > > One of the BER patches fixes that issue. > > > All 3.1.2 (BER) patches will be rolled up and released as Railo 3.2 > > > On 6 August 2010 02:51, Marco van den Oever > > <[email protected]>wrote: > > > > I think i have found the problem. > > > > I am on FC 6.0.3 and Railo 3.1.2.001 and when i select an publish or > > > expiry date it isn't filled in the database. > > > > That's why my migration script worked as i set those values manually. > > > > On Aug 5, 8:29 pm, Marco van den Oever <[email protected]> > > > wrote: > > > > I have added a news item through the webtop, i see that everything is > > > > added ok. > > > > Then i added a news rule that have to display the news item based on > > > > the category. > > > > In the refcategories table there is a record created for the newsrule > > > > but it's not displayed on the page. > > > > > The strange thing is that when i add a news item through the automated > > > > code, the migration script i use to add all old articles into dmNews, > > > > it is working... > > > > > Any idea's? > > > > > On Aug 5, 1:14 pm, Marco van den Oever <[email protected]> > > > > wrote: > > > > > > Ah stupid mistake, was missing a /> at a below code... thanks. > > > > > I tested the code and all is now working fine, the articles are shown, > > > > > thanks all that helped out! > > > > > > On Aug 4, 10:09 pm, Sean Coyne <[email protected]> wrote: > > > > > > > Actually you have a space in your call: > > > > > > > qNews.cat News > > > > > > > should be > > > > > > > qNews.catNews > > > > > > > Sean > > > > > > > On Aug 4, 4:08 pm, Sean Coyne <[email protected]> wrote: > > > > > > > > Syntax error usually means you have a stray # or another typo > > > > > > > somewhere. Check your code for proper CFML syntax. > > > > > > > > On Aug 4, 3:36 pm, Marco van den Oever <[email protected] > > > > > > > > wrote: > > > > > > > > > And the error is "Syntax Error, Invalid Construct" > > > > > > > > > On Aug 4, 9:34 pm, Marco van den Oever < > > > [email protected]> > > > > > > > > wrote: > > > > > > > > > > Ok almost there.. only thing is i get an error about the code: > > > > > > > > > > <cfset > > > > objCategory.assignCategories(objectid=qNews.objectid,lCategoryIDs=qNews.cat > > > News)> > > > > > > > > > > On Aug 4, 9:00 pm, Chris Kent <[email protected]> wrote: > > > > > > > > > > > Yep - that should do it. have just done this importing > > > content fro a > > > > > > > > > > V4 site to V6. > > > > > > > > > > > Just make sure you use the same stProps structure as this > > > will have > > > > > > > > > > the content item objectid and cat ids (should be catNews for > > > dmNews) > > > > > > > > > > > if you have already imported the content, then something > > > > > > > > > > like > > > the > > > > > > > > > > following (untested) code shoudl run through the new items > > > and assign > > > > > > > > > > teh categories. > > > > > > > > > > <cfset objCategory = > > > > CreateObject("component","#application.packagepath#.farcry.category") / > > > > > > > > > > > <cfset qNews = > > > application.fapi.getContentObjects(typename="dmNews", > > > > > > > > > > lProperties="objectID,catNews") /> > > > > > > > > > > <cfloop query="qNews"> > > > > > > > > > > <cfset > > > > objCategory.assignCategories(objectid=qNews.objectid,lCategoryIDs=qNews.cat > > > News)> > > > > > > > > > > </cfloop> > > > > > > > > > > > Chris. > > > > > > > > > > > On 4 Aug, 19:38, Marco van den Oever < > > > [email protected]> > > > > > > > > > > wrote: > > > > > > > > > > > > Mmm still have to follow your example of the > > > refCategories.. I assume > > > > > > > > > > > that is for each item, dmNews, dmImage, that have a > > > category assigned? > > > > > > > > > > > > so after the setData just insert: > > > > > > > > > > > > <cfset objCategory = > > > > CreateObject("component","#application.packagepath#.farcry.category") / > > > > > > > > > > > <cfset > > > > objCategory.assignCategories(objectid=stProps.objectid,lCategoryIDs=stProps > > > .catNews)> > > > > > > > > > > > > ? > > > > > > > > > > > > On Aug 4, 8:24 pm, Marco van den Oever < > > > [email protected]> > > > > > > > > > > > wrote: > > > > > > > > > > > > > Mmmm found the problem for this one, i used "createData" > > > instead of > > > > > > > > > > > > "setData", now that i use "setData" it works... thanks > > > man for helping > > > > > > > > > > > > out. > > > > > > > > > > > > > On Aug 4, 8:22 pm, Chris Kent <[email protected]> > > > wrote: > > > > > > > > > > > > > > refcategories > > > > > > > > > > > > > > Chris > > > > > > > > > > > > > > On 4 Aug, 18:59, Marco van den Oever < > > > [email protected]> > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > Are those relations stored in a table, and where? I > > > indeed must be > > > > > > > > > > > > > > missing something then... > > > > > > > > > > > > > > > On Aug 4, 4:24 pm, Chris Kent <[email protected]> > > > wrote: > > > > > > > > > > > > > > > > Marco, > > > > > > > > > > > > > > > > Do I remember that you have been importing > > > > > > > > > > > > > > > content? > > > > > > > > > > > > > > > > If so, did you assignCategories(...) after each > > > setData(...)? This is > > > > > > > > > > > > > > > required to assign the categories to the content > > > item. > > > > > > > > > > > > > > > > e..g for each content item you woudl be doing > > > somehting like > > > > > > > > > > > > > > > <cfset > > > application.fapi.setData(stProperties=stProps) /> > > > > > > > > > > > > > > > > you also need to do > > > > > > > > > > > > > > > <cfset objCategory = > > > > CreateObject("component","#application.packagepath#.farcry.category") / > > > > > > > > > > > > > > > > <cfset > > > > objCategory.assignCategories(objectid=stProps.objectid,lCategoryIDs=stProps > > > .catNews)> > > > > > > > > > > > > > > > > Chris. > > > > > > > > > > > > > > > > On 4 Aug, 14:58, Marco van den Oever < > > > [email protected]> > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > Filled in a publish date, also removed all null > > > values to make sure > > > > > > > > > > > > > > > > railo wasn't having any problems from that, but > > > no change. > > > > > > > > > > > > > > > > > The issue has something to do with categories. > > > There is something > > > > > > > > > > > > > > > > going on there with FC6.0.3 and Railo 3.1.2.001. > > > > > > > > > > > > > > > > > As soon as i create categories the problem is > > > occurring... > > > > > > > > > > > > > > > > > On Aug 4, 1:42 pm, Sean Coyne < > > > [email protected]> wrote: > > > > > > > > > > > > > > > > > > What database are you on?? > > > > > > > > > > > > > > > > > > I have found issues w/ the "getContentObjects" > > > method on Railo and > > > > > > > > > > > > > > > > > MySQL because of the "null" dates that FarCry > > > uses (Jan 1 1970, if I > > > > > > > > > > > > > > > > > remember correctly). I never had a chance to > > > investigate and raise a > > > > > > > > > > > > > > > > > bug. > > > > > > > > > > > > > > > > > > Do you have a publish date set on the news > > > item? > > > > > > > > > > > > > > > > > > The category filter uses the following query > > > which REQUIRES that you > > > > > > > > > > > > > > > > > have a valid date for a publish date. NULL is > > > not OK. Notice below > > > > > > > > > > > > > > > > > how it allows for expiry date to be null, but > > > not the publish date. > > > > > > > > > > > > > > > > > > <cfset oCat = createObject("component", > > > > > > > > > > > > > > > > > "farcry.core.packages.types.category") /> > > > > > > > > > > > > > > > > > <cfset q = > > > oCat.getDataQuery(lCategoryIDs="#stObj.metadata#" > > > > > > > > > > > > > > > > > ,typename="dmNews" > > > > > > > > > > > > > > > > > ,maxRows="#maximumRows#" > > > > ,bMatchAll="#stobj.bMatchAllKeywords#" > > > > > > > > > > > > > > > > > ,sqlWhere="publishdate <= > > > #now()# AND (expirydate >= #now()# OR > > > > > > > > > > > > > > > > > expirydate is NULL)" > > > > > > > > > > > > > > > > > ,sqlOrderBy="publishDate DESC" > > > > > > > > > > > > > > > > > ) /> > > > > > > > > > > > > > > > > > > On Aug 4, 5:26 am, Marco van den Oever < > > > [email protected]> > > > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > still have the same problems, don't think > > > this resolve my issues. > > > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > > > On Aug 4, 11:24 am, Marco van den Oever < > > > [email protected]> > > > > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > > I have updated to 3.1.2.018 and don't have > > > a problem with Farcry > > > > > > > > > > > > > > > > > > > stopped working, i do have some problems > > > with logging into the webtop, > > > > > > > > > > > > > > > > > > > was that the or one of the problems? > > > > > > > > > > > > > > > > > > > > On Aug 4, 10:57 am, AJ Mercer < > > > [email protected]> wrote: > > > > > > > > > > > > > > > > > > > > > are you keen to try bleeding edge > > > releases? > > > > > > > > > > > > > > > > > > > > if so, on your server, go to > > > > /railo/railo-context/admin/server.cfm?action=services.update > > > > > > > > > > > > > > > > > > > > > change URL tohttp://dev.getrailo.org > > ... > > read more » -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
