David, That makes perfect sesne, and I am sure the dbtype is set as MSSQL which means it creates it as text as you described. The other thing that I noticed is the datetime field you add in your pic was not a datetime stamp in mine. Once I made those changes to the DB all works fine.
The other thing I also noticed too is that when either in draft mode or waiting for approval the fron overview screen doesn't show any of this information, and would indicate that there are nothing waiting for approval or currently in draft which is not true. On 4/20/07, Whiterod, David (PIRSA) <[EMAIL PROTECTED]> wrote: > > Andrew, > > FUs are covered on the WIKI [1] > > The FU update should have been run when you ran the b300 updater. > > The FU update drops then re-creates the FU table. The FU update uses the > value of your site's application.dbtype (on our sites, set in > <projectname>/config/_serverSpecificVars.cfm). > For SQL Server databases, if the value is 'odbc' it re-creates the table > using 'varchar(8000)' for the 'friendlyurl' and 'query_string' fields. > Otherwise, it uses the 'text' data type. > > On SQL Server, our sites use varchar(8000). If you are having issues with > 'text' you could try switching to use varchar for these two fields. > > (I would be interested to hear if other are using the text type for these > fields and if they are having trouble with FUs.) > > [1] > http://docs.farcrycms.org:8080/confluence/display/FCDEV30/Friendly+URL+Management > ) > > cheers > > David > > > ------------------------------ > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Andrew Scott > *Sent:* Thursday, 19 April 2007 10:02 PM > *To:* [email protected] > *Subject:* [farcry-dev] Re: Farcry V2.3 - 3.01 update > > > > David, > > > > At this stage I am going blindly on the update, I haven't found one thing > on the website on pitfalls or workarounds. So when it comes to running such > things I have assumed that the updates directory will do these updates for > me. > > > > I did find the bug listed in Jira, however it says it was resolved. With > no clue other than it was fixed in V3.01. > > > > Do you have any links that I can read that gives more detail on what you > mentioned about the FU? > > > > Hmm, my friendurl and query string are showing up as text data types, and > this is on MSSQL server 2000 and just running the 3.0 and 3.01 updates > from www.domain.com/farcry/updates/ and selecting the updates and applying > them. > > > > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
