This is a repost (first one did not get through in nabble): 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?
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 ); Thanks for anticipated answer(s)! ;-) Albert PS: problems with the fishEye repository: I cannot DL generated zipped files (server error 500). On Sep 5, 9:56 am, modius <[EMAIL PROTECTED]> wrote: > On Sep 5, 5:34 am, "Redding, Ian (NIH/NIEHS) [C]" > > <[EMAIL PROTECTED]> wrote: > > FC 4 is still not compatible w/oracle & there are many issues that arise > > while installing. > > We have several clients running on Oracle with FarCry 4.0.x > > It may simply be that there are some bugs in your version of the > installer. For example, teh following issue was > fixed:http://bugs.farcrycms.org:8080/browse/FC-920 > > But you'll need the latest installer code base, and copy it over the > top of > ./projects/mollio/www/installhttp://fisheye3.cenqua.com/browse/farcrycms/install/trunk > > We will be releasing a new FarCry CMS bundle shortly including the > latest FarCry Core framework, installer, CMS plugin etc. > > Hope that helps, > > -- 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 -~----------~----~----~----~------~----~------~--~---
