[Openinteract-help] OI fruit example problem

[Ben A. <be...@th...>]

I'm still working through the fruit example, and have hit another problem:
everything is fine, until the SQL Install stage.

I'm pretty sure I've followed the example exactly, but I get this error:


$ oi_manage --package fruit install_sql
[oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
[oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
Running install_sql...
=========================

OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
WARNING executing manipulate_configuration for test_cares::Page
Cannot discover fields
 -> SELECT * FROM page WHERE 1 = 0
 -> DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist
(DBD ERROR: OCIStmtExecute/Describe) at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/SPOPS/DBI.pm line 56.

Process will continue
Status of the packages requested for SQL install:

fruit (0.06)
  OK: 
      
      Structure:
        * Cannot execute table SQL
      CREATE TABLE fruit (
      id NUMBER(10),
      name VARCHAR2(255),
      taste VARCHAR2(255),
      price VARCHAR2(255)
      )
      
      Error: DBD::Oracle::db do failed: ORA-00955: name is
      already used by an existing object (DBD ERROR:
      OCIStmtExecute) at
      /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/SQL
      Install.pm line 136.
      
      Data: 
        * Error: Cannot create SPOPS object!
      Basic: DBD::Oracle::db prepare failed: ORA-00942:
      table or view does not exist (DBD ERROR:
      OCIStmtExecute/Describe) at
      /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
      ce.pm line 116.
      
      Error: DBD::Oracle::db prepare failed: ORA-00942:
      table or view does not exist (DBD ERROR:
      OCIStmtExecute/Describe) at
      /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
      ce.pm line 116.
      
      
What is the 'page' object it is trying to access in the database? Where does
it get this from?

----------------------------------------------------------------
Ben Avery			YouthNet UK	
Analyst/Programmer		2nd Floor
YouthNet UK			Broadmead House
Tel:+44 020 7925 2530		21 - 23 Panton Street
Fax:+44 020 7925 2830		London SW1Y 4DR              

e-mail:be...@th...
www.thesite.org.uk 
www.do-it.org.uk
www.youthnet.org.uk
----------------------------------------------------------------