[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