Hammered session lock?

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

******    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