SesssionLockFile

["Black Samba - Staff" <darrenl@blacksamba.com>]

******    message to minivend-users from "Black Samba - Staff" <darrenl@blacksamba.com>     ******

**MiniVend V3.12beta6, Apache 1.3.4, Perl 5.005_2, FreeBSD 2.7.7 Intel**

Apparently there is some conflict in the minivend configuration that is
related to DB-File. The docs say that only one database 'type' can be used
by the server for all catalogs. I am using mysql, have specified it (see
below) in catalog.cfg, yet I am getting errors that point to sessionDatabase
or SessionLockfile not being read properly by DB_File, AND my shopping cart
is STILL showing the simple demo even though that table has been dropped by
mysql..meaning it must be using the memory only default product database
because there is some system wide conflict with the 'types' of databases
allowed.

Where do you specify in the configs that you want all catalogs to run SQL,
and NOT GDBM, DB_File, or memory databases?

And does the session.db HAVE to use DB_file or GDBM?


-D-

Black Samba Design Services
Darren Littlejohn
darrenl@blacksamba.com
831-454-9580

BLACK SAMBA IS NOW!
http://www.blacksamba.com


> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Black Samba -
> Staff
> Sent: Wednesday, March 03, 1999 3:39 AM
> To: minivend-users@minivend.com
> Subject: Hammered session lock?
>
>
> ******    message to minivend-users from "Black Samba - Staff"
> <darrenl@blacksamba.com>     ******
>
> I get below in error_log after setting up a new table in mysql and on my
> searchform. The minvend catalog still is acting as if it's
> reading products
> from the database, even though I've dropped the table products and added
> table music.
>
> First:
>
> After adding a new table to mysql, then configured catalog.cfg
> to read it:
>
> Database             music  dbi:mysql:slrecords:localhost:3333
>
> I set the following on my searchform:
>
> <FORM METHOD=POST ACTION="[process-search]">
>     <INPUT TYPE=hidden NAME=mv_searchtype VALUE="sql">
>     <INPUT TYPE=hidden NAME=mv_sql_query
>         VALUE="select * from music where genre = ? ">
>     <SELECT NAME=mv_searchspec>
> 	<OPTION> Rock
>     <OPTION> Punk
> 	<OPTION> Soul - R&B
>     <OPTION> Jazz\Jazz-Vocals
> 	<OPTION> Classical/20th Century
>     <OPTION> Easy Listening(lounge/Pop vocals)
> <OPTION> Soundtracks/Musicals/Comedy
> <OPTION> Country/Folk/Bluegrass
> </SELECT>
> <INPUT TYPE=SUBMIT VALUE="Do it!">
> </FORM>
>
> This is in error_log:
>
> tsa-16.dialup.ucsc.edu cSSNhRGS:ucsc.edu - [03/March/1999:03:14:00 -0800]
> streetlight /cgi-bin/stree
> tlight/browse Hammered session lock LOCK_cSSNhRGS:ucsc.edu left
> by PID 19732
> tsa-16.dialup.ucsc.edu cSSNhRGS:ucsc.edu - [03/March/1999:03:16:18 -0800]
> streetlight /cgi-bin/stree
> tlight/search Runtime error: Can't locate object method "array_query" via
> package "Vend::Table::DB_F
> ile" at /usr/local/mvend/lib/Vend/Scan.pm line 545.
>
>
> I added the following table to mysql:
>
> CREATE TABLE music
> (code char(16) NULL,
> description char(128) NULL,
> title char(128) NULL,
> artist char(128) NULL,
> format char(128) NULL,
> genre char(128) NULL,
> comment1 char(128) NULL,
> comment2 char(128) NULL,
> comment3 char(128) NULL,
> condition char(128) NULL,
> image char(128) NULL,
> price char(128) NULL,
> ID INT NOT NULL AUTO_INCREMENT,
> PRIMARY KEY (ID));
>
> and the following data:
>
> INSERT INTO music
> (code,description,title,artist,format,genre,comment1,comment2,
> comment3,condition,image,price)
> VALUES ('', 'The best Stones album ever','Some Girls','The
> Rolling Stones',
> 'CD','Rock','','','','Excellent','goats.jpg','9.98');
>
> INSERT INTO music
> (code,description,title,artist,format,genre,comment1,comment2,
> comment3,condition,image,price)
> VALUES ('2611', 'Pink Floyd Rules','Dark Side of the Moon','Pink Floyd',
> 'CD','Rock','','','','Excellent','','9.98');
>
> But I can't find any of it on the minivend catalog.
>
> Any help would be gratefully appreciated.
>
> -d-
>
> -
> 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
>

-
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