Re: off by one error in index file creation ? 2nd

[Holm Tiffe <holm@freibergnet.de>]

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

Holm Tiffe wrote:

> ******    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!
[..]
[replaying myself]
Further investigation:

my products.asc file contains the following fields:

code	description	title	manufacturer	comment	image	price	\
category	nontaxable	vat	weight	size	color	related	desc_de

When I use an TAB delimited Database (minivend's builtin) than is
the file products.asc.7 created for the category, with the right contents.
When I try to use DBI:Pg, an products.asc.8 file is created afer minivend
startup.

What the Hell is going on here ?

I have ried to use Database NAME foo bar etc. constructs with no luck,
minivend thinks column 8 is the category.

Some experiments:

Database products INDEX title       --> products.asc.3 w. contents from manufacturer
Database products INDEX description --> products.asc.2 w. contents from title
Database products INDEX comment     --> products.asc.5 w. contents from image
and so on.

the code filed seems to be filed number 1.

If I have

Database products products.asc

I get

Database products INDEX comment --> products.asc.4 w. contents from comment
Database products INDEX title   --> products.asc.2 w. contents from title

the code files seems to be field 0.
...

all is OK.

Can please anyone help here ?

In wich perl module get's the INDEX file created ?, How can I debug this ?

My own patches to minivend have nothing todo with this behavior, I have
verified this with the original minivend files.

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