I have just done a fresh install of 409 (with updates from branches p400)
and I don't have the reffriendlyURL table either

win2003/iis/CF702/oracle

On Dec 11, 2007 12:00 PM, modius <[EMAIL PROTECTED]> wrote:

>
> On Dec 10, 8:19 pm, Jedi <[EMAIL PROTECTED]> wrote:
> > I am seeing an error when i set the Action in the news administartion
> > page of a news item to approve and then submitting.
> >
> > Looking at the error there seems to be a table missing.
> > The install didnt produce any errors so a little confused on why this
> > is happening.
> >
> > Using CF8 IIS and Oracle 10g.
> >
> > Any help is appreciated.
>
> Looks like you are completely missing the friendly URL table.  Its the
> last thing the installer installs -- did something happen with your
> initial installation?
>
> In any event it should be an easy fix.  You will need to create the
> table:
>
> CREATE TABLE dbowner.reffriendlyURL (
> objectid                varchar2(50) NOT NULL,
> refobjectid             varchar2(50) NOT NULL,
> friendlyurl             varchar2(4000) NULL,
> query_string            varchar2(4000) NULL,
> datetimelastupdated     date NULL,
> status                  numeric NULL
> )
>
> Obviously create the dbowner with whatever is relevant.
>
> Hope that helps,
>
> -- geoff
> http://www.daemon.com.au/
> >
>


-- 

AJ Mercer
Web Log: http://webonix.net

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

Reply via email to