OK: - Farcry version: 4.03 (downloaded on tuesday?). I didn't get the latest because of problems with the repository I mentioned. - Wrong SQL: CREATE TABLE FARCRY.ruleNews( bArchive number default false NOT NULL ,bMatchAllKeywords number default false NULL ,datetimelastupdated varchar2(255) default 'displayTeaserBullets' NOT NULL ,intro varchar2(255) default '' NULL ,label nvarchar2(255) default '' NULL ,metadata default 5 NOT NULL ,numPages number default 1 NOT NULL ,objectID varchar2(50) NOT NULL ,suffix varchar2(255) default '' NULL )
Note the "default false" extra parameters Thanks for your support! On Sep 7, 12:29 pm, modius <[EMAIL PROTECTED]> wrote: > On Sep 7, 7:56 pm, Beru <[EMAIL PROTECTED]> wrote: > > > I got the same kind of problems (Oracle 10g), we corrected some SQL > > (added the "from dual" sql stuff) and then got to an error while > > creating table "ruleNews". Our DBA corrected the SQL and ran it to > > create the table, but we still got probs afterwards. I asked to erase > > the schema and recreate it, so to do the reinstall from scratch, but: > > Where can I correct the SQL in the install code, to run the install > > again? Is this a paramters file or a SQL install script? > > What version of FarCry is this? Presumably you are running the latest > core and installer milestones? > > > Here is the corrected SQL that enabled us to create the ruleNews > > table: > > CREATE TABLE FARCRY.ruleNews( > > bArchive number NOT NULL , > > bMatchAllKeywords number NULL , > > datetimelastupdated date NULL , > > displayMethod varchar2(255) default 'displayTeaserBullets' NOT NULL , > > intro varchar2(255) default '' NULL , > > label nvarchar2(255) default '' NULL , > > metadata nclob default '' NULL , > > numItems number default 5 NOT NULL , > > numPages number default 1 NOT NULL , > > objectID varchar2(50) NOT NULL , > > suffix varchar2(255) default '' NULL ); > > What was the incorrect SQL statement? Knowing that might help us to > correct the problem. > > -- geoffhttp://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
