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 > > > > > > > > > > > > > > > > > > then execute updates > > > > > > > > > > > > > > > > > > > > You can always remove any patches > > > > > > > > > > > > > > > > > > > > Also - see my post about a minor change > that is required to farcry until > > > > > > > > > > > > > > > > > > .019 comes out > > > > > > > > > > > > > > > > > > > > On 4 August 2010 16:49, Marco van den > Oever <[email protected]>wrote: > > > > > > > > > > > > > > > > > > > > > Railo 3.1.2.001 final > > > > > > > > > > > > > > > > > > > > > On Aug 4, 10:21 am, AJ Mercer < > [email protected]> wrote: > > > > > > > > > > > > > > > > > > > > what version of Railo do you have? > > > > > > > > > > > > > > > > > > > > > > On 4 August 2010 16:13, Marco van den > Oever <[email protected] > > > > > > > > > > > > > > > > > > > >wrote: > > > > > > > > > > > > > > > > > > > > > > > I have no bubble messages at all, > also i am sure about the category > > > > > > > > > > > > > > > > > > > > > existing and selected for the > dmNews item. > > > > > > > > > > > > > > > > > > > > > I also saw a similar problem with > adding a dmImage item for a dmNews > > > > > > > > > > > > > > > > > > > > > item, when i edit the dmImage item > i don't see a category selected > > > > > > > > > > > > > > > > > > > > > while there is a category objectid > in catImage... > > > > > > > > > > > > > > > > > > > > > > > Maybe it's a Railo bug? > > > > > > > > > > > > > > > > > > > > > > > On Aug 4, 1:45 am, Sean Coyne < > [email protected]> wrote: > > > > > > > > > > > > > > > > > > > > > > I haven't tried it with the > category filters. Are you getting any > > > > > > > > > > > > > > > > > > > > > > output at all? Does a black > growl-like error bubble appear on the > > > > > > > > > > > > > > > > > > > > > > screen if you view that page > while logged into FarCry? > > > > > > > > > > > > > > > > > > > > > > > > Are you sure you have news items > in the selected categories? > > > > > > > > > > > > > > > > > > > > > > > > On Aug 3, 4:22 pm, Marco van den > Oever <[email protected]> > > > > > > > > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > I have tested with a non > customized dmNews.cfc, when i have no > > > > > > > > > > > > > > > > > > > > > > > categories the listing rule > works. > > > > > > > > > > > > > > > > > > > > > > > When i select one category or > when i have categories and non > > > > > > > > > > > > > > > > > > > selected > > > > > > > > > > > > > > > > > > > > > > > in the rule it isn't working. > > > > > > > > > > > > > > > > > > > > > > > > > I am on FC 6.0.3 and Railo. > > > > > > > > > > > > > > > > > > > > > > > Is this a bug? > > > > > > > > > > > > > > > > > > > > > > > > > On Aug 3, 9:59 pm, Sean Coyne < > [email protected]> wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > The news listing rule is part > of the FarCry CMS plugin. I'm not > > > > > > > > > > > > > > > > > > > sure > > > > > ... > > > > > 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]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > -- *AJ Mercer* <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org community="Open" /> <http://webonix.org> http://twitter.com/webonix -- 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
