[ic] ProductFiles

[interchange-users@interchange.redhat.com]

> > Why can't interchange use my secondary products data table?
> >
> > Using 4.8.3, this catalogue uses MySQL
> >
> > I can find and sort data using [query] OK
> >
> > I have added:
> >
> > Database  products  products.txt  TAB
> > Database  products2  products2.txt  TAB
> >
> > ProductFiles   products products2
>
> That should do it, assuming you reconfigged the catalog.
>
> > [order 1234 1]Order item in products2[/order] does not find anything
>
> It should indeed find 1234 in the second if it doesn't find it in
> the first. I know this works, as it is in the regression tests.

Have tried for many hours/days now and still no joy.

I thought I would test a second products table with a default foundation
catalogue using DBM instead of MySQL

I copied products.txt to products2.txt
Added a Z in front of all the SKUs

Added to catalog.cfg:
ProductFiles   products products2
Database  products2  products2.txt  TAB

Copied dbconf/default_db/products.dbm to
dbconf/default_db/products2.dbm
This now reads:
Database            products2     products2.txt      TAB
Database            products2     HOT               1
Database            products2     INDEX             category:c

Restarted IC

which created products2.gdb and other files similar to products.txt

Test:

http://www.store.com/cgi-bin/defaultstore/Zos28065.html

Sorry, the page (Zos28065) was not found

Same for ordering; no such product.

What else should I try?
I have minivend 3.16 stores using several product files no problem.

What am I missing to make this work under 4.8.3?

Interchange version - 4.8.3
Perl Version - Perl 5.6.0 (called with: /usr/bin/perl)
Database Interfaces -
GDBM available (v1.03)
No Berkeley DB_File.
DBI enabled (v1.18), available drivers:
ADO
ExampleP
Multiplex
Proxy
mysql

Optional Module Information:
Digest::MD5 found (v2.13).
LWP::Simple found (v1.34).
MIME::Base64 found (v2.12).
SQL::Statement found (v0.1020).
Safe::Hole found (v0.08).
Storable found (v1.011).
Tie::Watch found (v1.0).
URI::URL found (v5.02)