OK so thats an issue w/ a <cfqueryparam /> call somewhere. What are you using to get a list of news items?
Have you deployed all the types and properties? Did you reinitialize the app? Sean On Aug 20, 12:24 pm, Marco van den Oever <[email protected]> wrote: > With or without i get: > > Error with rule \'ruleNews\' > invalid CF SQL Type [] > > On Aug 20, 12:53 am, Sean Coyne <[email protected]> wrote: > > > > > Have you tried wrapping the entire execute.cfm in a cftry/cfcatch and > > dumping the full cfcatch rather than relying on FarCry's limited error > > messages? > > > That may help you track down where the error is occurring. > > > On Aug 19, 3:06 pm, Marco van den Oever <[email protected]> > > wrote: > > > > Any updates on this matter?? > > > > On Aug 13, 3:39 pm, Marco van den Oever <[email protected]> > > > wrote: > > > > > Somehow that field was not deployed anymore??? Now still only the > > > > parameter 2 error and the publish date not being saved. > > > > > On Aug 12, 9:47 pm, Marco van den Oever <[email protected]> > > > > wrote: > > > > > > mmm i removed the news rule and was trying to add a new one to check > > > > > if it's working then but now i get: > > > > > > Unknown column 'numPages' in 'field list' > > > > > > On Aug 10, 7:59 pm, Marco van den Oever <[email protected]> > > > > > wrote: > > > > > > > And still the publish date... > > > > > > > On Aug 10, 7:57 pm, Marco van den Oever <[email protected]> > > > > > > wrote: > > > > > > > > Correction, the only error that is stil here is: > > > > > > > > Error with rule \'ruleNews\' > > > > > > > No value specified for parameter 2 > > > > > > > > On Aug 10, 4:26 pm, Marco van den Oever > > > > > > > <[email protected]> > > > > > > > wrote: > > > > > > > > > I have checked but the publish date is still not kept when > > > > > > > > selected. > > > > > > > > > The category issue was due to my own fault that i was not > > > > > > > > filling in > > > > > > > > the refcategories table! > > > > > > > > > On Aug 10, 5:58 am, Blair McKenzie <[email protected]> wrote: > > > > > > > > > > I have converted the queries to use getContentObjects. This > > > > > > > > > should > > > > > > > > > (hopefully) fix both the publish date and category issues. > > > > > > > > > Can you test > > > > > > > > > Marco? > > > > > > > > > > Blair > > > > > > > > > > On Tue, Aug 10, 2010 at 12:01 PM, Marco van den Oever < > > > > > > > > > > [email protected]> wrote: > > > > > > > > > > Any updates on this error? Thanks! > > > > > > > > > > > On Aug 7, 1:14 pm, Marco van den Oever > > > > > > > > > > <[email protected]> > > > > > > > > > > wrote: > > > > > > > > > > > Ok thanks. > > > > > > > > > > > > On Aug 7, 1:05 pm, Blair McKenzie <[email protected]> > > > > > > > > > > > wrote: > > > > > > > > > > > > > I'll ask around on Monday. I'm sure something like that > > > > > > > > > > > > was fixed, but > > > > > > > > > > maybe > > > > > > > > > > > > it accidentally reverted. > > > > > > > > > > > > > On Sat, Aug 7, 2010 at 6:59 PM, Marco van den Oever < > > > > > > > > > > > > > [email protected]> wrote: > > > > > > > > > > > > > I have now but no change. > > > > > > > > > > > > > > I have copied the CMS folder content into farcrycms > > > > > > > > > > > > > folder, is that > > > > > > > > > > ok > > > > > > > > > > > > > or has it to be cms folder now? > > > > > > > > > > > > > > Shoul i reenter newsarticles due to the updated cms > > > > > > > > > > > > > and then it > > > > > > > > > > should > > > > > > > > > > > > > work? > > > > > > > > > > > > > > On Aug 7, 9:29 am, Blair McKenzie <[email protected]> > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > That sounds familiar... Do you have the latest > > > > > > > > > > > > > > version of farcrycms > > > > > > > > > > > > > fromhttp://farcry.jira.com/svn/CMS/trunk? > > > > > > > > > > > > > > > On Sat, Aug 7, 2010 at 5:04 PM, Marco van den Oever > > > > > > > > > > > > > > < > > > > > > > > > > > > > > > [email protected]> wrote: > > > > > > > > > > > > > > > I have selected pagination for my news listing > > > > > > > > > > > > > > > rule and get an > > > > > > > > > > error: > > > > > > > > > > > > > > > > "variable [STOBJECT] doesn\'t exist" > > > > > > > > > > > > > > > > Any idea's? > > > > > > > > > > > > > > > > On Aug 6, 5:30 pm, Marco van den Oever < > > > > > > > > > > [email protected]> > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > Ok thanks, will go for that solution. > > > > > > > > > > > > > > > > > On Aug 6, 3:40 pm, AJ Mercer > > > > > > > > > > > > > > > > <[email protected]> wrote: > > > > > > > > > > > > > > > > > > That is the other post I have put on this > > > > > > > > > > > > > > > > > list about Railo > > > > > > > > > > BER > > > > > > > > > > > > > > > > > I submitted a work around > > > > > > > > > > > > > > > > > but it will be resolved in 019 > > > > > > > > > > > > > > > > > > On 6 August 2010 16:49, 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" > > ... > > 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
