[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: SesssionLockFile
****** message to minivend-users from "Michael Radke" <mra@trendware.de> ******
Hi,
I am using MV 3.11 with MySQL, should'nt it look like this..:
Database name_to_mv music dbi:mysql:slrecords:localhost:3333
You specify, which DATABASE should be used (slrecords), and what
the TABLENAME is (music).
If this is your products database, you should set 'name_to_mv'
to 'products' - this name is the default table name for the
products in minivend.
Of course, you can also specify another name there and access
it with suitable minivend tags (look at the docs).
Regards,
Michael
-----Ursprüngliche Nachricht-----
Von: Black Samba - Staff <darrenl@blacksamba.com>
An: minivend-users@minivend.com <minivend-users@minivend.com>
Datum: Donnerstag, 4. März 1999 10:56
Betreff: SesssionLockFile
>****** 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
-
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
