MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

problems with mySQL



Ok, I'm trying to use mySQL for the first time with Minivend.  I've renamed
my tables to lower case, and now I'm trying to run a query against on of the
tables.

Minivend 3.14 on Mandrake Linux 6.0, 2.2.9 kernel

catalog.cfg excerpts:

ProductFiles jewelry books software apparel

Database        jewelry jewelry.asc dbi:mysql:mmall:localhost:3306
Database        books books.asc dbi:mysql:mmall:localhost:3306
Database        software software.asc dbi:mysql:mmall:localhost:3306
Database        apparel apparel.asc dbi:mysql:mmall:localhost:3306
Database        storeinfo storeinfo.asc dbi:mysql:mmall:localhost:3306

Database        jewelry USER    xxxx
Database        books USER      xxxx
Database        software USER   xxxx
Database        apparel USER    xxxx
Database        storeinfo USER  xxxx

Database        jewelry PASS    xxxx
Database        books PASS      xxxx
Database        software PASS   xxxx
Database        apparel PASS    xxxx
Database        storeinfo PASS  xxxx

# Uppercase field names in the storeinfo table

Database        storeinfo UPPERCASE

NoImport jewelry books software apparel storeinfo


>From the MV page in question:

<table border=2>
[sql type=html]select * from storeinfo[/sql storeinfo]
</table>

When I try and bring up the page, I get a 500 error message.  This is what's
in the error.log:

209.152.204.34 GE87eJQS:209.152.204.34 - [14/July/1999:15:46:27 -0400]
mmall2k /cgi-bin/mmall2k/NE0001/index Runtime error: Can't locate object
method "html_query" via package "Vend::Table::GDBM" at
/usr/local/minivend/lib/Vend/Data.pm line 414.


Now, if I'm trying to do an SQL query, using the [sql] tag, why am I getting
this error?  Why is it even using the GDBM module?


TIA,

Dave






Search for: Match: Format: Sort by: