off by one error in index file creation ?

[Holm Tiffe <holm@freibergnet.de>]

******    message to minivend-users from Holm Tiffe <holm@freibergnet.de>     ******

Hi all,

I'm in the process to get a modified "simle" demo from 3.12 online,
but today I have a new problem.

I've tried to switch the products database over to PostgreSQL
and have the following configuration in catalog.cfg:

Database            products products.asc SQL
Database            products DSN DBI:Pg:dbname=shop;host=sol.freibergnet.de;port
=5432;user=xxx;password=yyy;
Database            products USER       xxx
Database            products PASS       yyy
Database            products COLUMN_DEF code=varchar,description=varchar
Database            products COLUMN_DEF title=varchar,manufacturer=varchar
Database            products COLUMN_DEF comment=text,image=varchar
Database            products COLUMN_DEF price=float8,category=varchar
Database            products COLUMN_DEF nontaxable=varchar,vat=float8
Database            products COLUMN_DEF weight=float8,size=varchar
Database            products COLUMN_DEF color=varchar,related=varchar
Database            products COLUMN_DEF desc_de=varchar
Database            products LongReadLen  128
Database            products INDEX category

the last line generates an products.asc.8 file linked to products.asc.category
(category is the 8 field of products.asc ok).
The products SQL Database is successfully created and polluted with proper
values, fine.

Now my problem:

the products.asc.8 looks like this:

no      00-001
no      00-002
no      00-003
no      01-001
no      01-002
no      01-003
no      02-001
no      02-002
no      03-001
no      04-001
no      05-001
no      05-002
yes     03-002

those no's and that yes come not from the category column, but from the
next column in the database, the "nontaxable" column!

Can anyone confirm this ?
This is not a Bug report, because I've patched some things in minivend itself,
and I doesn't know if I broke this myself. But where the Hell is this
products.asc.8 file generated ?

When I change the contents of the 1st column from this file, the catalog is
working as expected with PostgreSQL.

Without the index file I could'nt browse the categories, eg. sorry nothing
found about ....  Why this ? It looks that the [area scan di=category
df=yes dl=BSD] does'nt work with PostgreSQL, but the srchform.html
from the simple catalog works.... This is only with PostgreSQL.

BTW:
could we please add a mv_credit_card_valid_month and a
mv_credit_card_valid_year to the minivend ?
It seems that the "valid since" field from the card is required 
to make some bank's (?) here in germany lucky....


Holm
-- 
FreibergNet Systemhaus GbR      Holm Tiffe  * Administration, Development
Systemhaus f&#252;r Daten- und Netzwerktechnik           phone +49 3731 781279
Unternehmensgruppe Liebscher & Partner                fax +49 3731 781377
D-09599 Freiberg * Am St. Niclas Schacht 13    http://www.freibergnet.de/

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list