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. -- geoff http://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 -~----------~----~----~----~------~----~------~--~---
