[ic] interchange foundation demo not working with Oracle

Richard Chen interchange-users@interchange.redhat.com
Tue Jan 29 22:53:00 2002


I fixed the problem by stealing the code from the file
	interchangefoundation/pages/account.html
which works correctly. Here is the diff file that allowed
the correct Shipping method pull down menu to show correctly
on the checkout page.

$ cd interchange/foundation/pages/ord
$ diff -u checkout.html checkout.html.orig
--- checkout.html       Tue Jan 29 21:25:03 2002
+++ checkout.html.orig  Tue Jan 29 21:15:49 2002
@@ -472,11 +472,10 @@
            </td>
            <td colspan="3" class="contentbar1">
              <SELECT NAME=mv_shipmode>
-               [loop option=mv_shipmode
-                       list=|[data table=country key='[default country US]' col
=shipmodes]|
-               ]
-                       <OPTION VALUE="[loop-code]"> [shipping-desc [loop-code]]
-               [/loop]
+             [shipping
+               label=1
+               mode=|[data table=country key='[default country US]' col=shipmod
es]|
+              ]
              </SELECT>
            </td>
          </tr>


On Tue, Jan 29, 2002 at 04:04:18PM -0800, Jonathan Lee wrote:
> I also have this issue. But after I login, it's fine.
> 
> --- Richard Chen <chenri@snet.net> wrote:
> > This fixed the pulldown menu problem for
> > State/Province.
> > However, the Shipping method pull down still only
> > shows
> > blank entries, just like State/Province before the
> > fix.
> > 
> > Any ideas on what caused that?
> > 
> > Thanks
> > 
> > Richard
> > 
> > On Tue, Jan 29, 2002 at 11:08:18AM -0800, Jonathan
> > Lee wrote:
> > > State not show up is because of the bug in
> > state.ora
> > > file.
> > > Add the following line to your state.ora file:
> > > Database  state  UPPERCASE    1
> > > 
> > > --- Richard Chen <chenri@snet.net> wrote:
> > > > Hi,
> > > > 	I just tried interchange foundation demo. The
> > > > regular DBM database worked. But when I tried
> > using
> > > > Oracle, there are problems upon starting
> > > > interchange:
> > > > 
> > > > Configuring catalog foundation...Using Oracle,
> > > > DSN=dbi:Oracle:...table
> > > > country created: create table country (
> > > > code VARCHAR2(3) PRIMARY KEY,
> > > > sorder VARCHAR2(128),
> > > > region VARCHAR2(128),
> > > > selector VARCHAR2(3),
> > > > shipmodes VARCHAR2(64),
> > > > name VARCHAR2(32) DEFAULT '',
> > > > iso CHAR(3) DEFAULT '' NOT NULL,
> > > > isonum CHAR(3) DEFAULT '' NOT NULL,
> > > > tax VARCHAR2(128)
> > > > )
> > > > 
> > > > table 'country' failed: country import failed:
> > > > ORA-01400: cannot insert
> > > > NULL into ("INTERCHANGE"."COUNTRY"."ISO") (DBD
> > > > ERROR: OCIStmtExecute)
> > > > 
> > > > Apparently there are data records with iso and
> > > > isonum having no values.
> > > > 
> > > > I had tried removing the 'NOT NULL' restriction
> > from
> > > > foundation/dbconf/oracle/country.ora. But the
> > > > resulting
> > > > checkout page does not have the correct pull
> > down
> > > > menu for
> > > > State/Provice entry. No state/province were
> > listed.
> > > > All entries
> > > > in the pull down are blank.
> > > > 
> > > > Also, the shipping method pull down on checkout
> > page
> > > > is blank.
> > > > 
> > > > This means that the demo allows buying stuff but
> > no
> > > > checkout :-(
> > > > 
> > > > Anyone got a workaround for this? Do I have to
> > > > remove the entries
> > > > with iso and isonum blank from the datafile?
> > > > 
> > > > Thanks for any info.
> > > > 
> > > > Richard
> > > > _______________________________________________
> > > > interchange-users mailing list
> > > > interchange-users@interchange.redhat.com
> > > >
> > >
> >
> http://interchange.redhat.com/mailman/listinfo/interchange-users
> > > 
> > > 
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Great stuff seeking new owners in Yahoo! Auctions!
> > 
> > > http://auctions.yahoo.com
> > > _______________________________________________
> > > interchange-users mailing list
> > > interchange-users@interchange.redhat.com
> > >
> >
> http://interchange.redhat.com/mailman/listinfo/interchange-users
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@interchange.redhat.com
> >
> http://interchange.redhat.com/mailman/listinfo/interchange-users
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions! 
> http://auctions.yahoo.com
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users