[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Newbie Question
I've made and installed MiniVend Successfully on a Linux Box kernel
2.0.32 (Redhat).
I had to Install Perl into my user directory since as the Install Docs
said, this copy of RedHat had a broken
POSIX implementation.
I built and ran the "Simple" Demo and Everything works Great.
Here is my problem, I have a mysql database that I need to hook into. I
have DBI installed as well as the
drivers for Mysql.. I checked these out and all tests passed.
my problem comes when I made my catalog and try to make a SQL
connection.
When I start the server, everything is great, it connects to the mysql
server and looks like everything is good, but
I made a page with only 1 minvend directive cause I am trying to test
and learn how this all works.
when I put:
[sql html][/sql]
into a page then I get a internal server error on the page and the log
files contain this
x.x.x.x yGat2bPT:x.x.x.x - [15/July/1999:13:32:51 -0700] health
/cgi-bin/health/index1 Runtime error: Can't locate object method
"html_query" via package "Vend::Table::GDBM" at
/client/home/awhealth/mvend/lib/Vend/Data.pm line 414.
>
As far as I can tell it shouldnt be using Vend::Table::GDBM, but it
should be using Vend::Table::DBI as this is the only file that has the
html_query subroutine.
anyway there is a variable called $db that gets set from whatever calls
Data.pm and uses either DBI, GDBM, DB or in-memory
My question is, Do I have to have a specific table structure for this to
work or is there some place I have to tell
it that I have an SQL database.
I thought i told it I had a SQL database when I put these lines in my
catalog.cfg
Database awhealth Items.asc
dbi:mysql:databasename:myhost:3306
Database awhealth USER username
Database awhealth PASS password
Does anyone know what else I need to do to get this to work? I have been
reading the instructions but see
nothing more to do except what I already have outlined here.
Any help would be appreciated
Brian Korsund
